if you want more related search please click here
please help to other
http://scriptquery.blogspot.in/
simple telerick grid and dispaly the database table values usinpg c# .net
---------------------------------------------------------------------------------------------------------------
simple 3 steps:
1)btnSave_Click 'button click
2)GetDataTable(parameter is query here) ' calling function from grid
3)DataTable GetDataTable(string query) ' defination of above function
or if you want to show the table separtely write code in view button.
step 1):
-------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace myFirstOfficeDemo
{
public partial class alert : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSave_Click(object sender, EventArgs e)
{
string str = "Data Source=.;Initial Catalog=alertDb;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
SqlCommand com = new SqlCommand("SP_ADD_ALERT", con);
com.Parameters.Add("@header", SqlDbType.VarChar).Value = txtHeader.Text;
com.Parameters.Add("@text", SqlDbType.VarChar).Value = txtText.Text;
com.CommandType = CommandType.StoredProcedure;
com.ExecuteNonQuery();
string script = "alert('Saved');";
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);
con.Close();
txtHeader.Text = "";
txtText.Text = "";
}
'protected void btnView_Click(object sender, EventArgs e)
'{
'
'}
step 2):
-------
public void RadGrid1_NeedDataSource1(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
RadGrid1.DataSource = GetDataTable("SELECT alertId, header, text FROM utilAlert");
}
step 3):
-------
public DataTable GetDataTable(string query)
{
String ConnString = ConfigurationManager.ConnectionStrings["alertDbConnectionString"].ConnectionString;
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable myDataTable = new DataTable();
using (SqlConnection conn = new SqlConnection(ConnString))
{
adapter.SelectCommand = new SqlCommand(query, conn);
adapter.Fill(myDataTable);
}
return myDataTable;
}
}
}
if you want more related search please click here
please help to other
http://scriptquery.blogspot.in/
11:39 PM
Share:
0 comments: