Saturday, October 18, 2014

how to use gridview in c#

Posted by Gnani Palepu  |  No comments

 if you want more related search please click here  
 please help to other  

 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);  
       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;  
       string script = "alert('Saved');";  
       ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);  
       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);  
       return myDataTable;  

 if you want more related search please click here  
 please help to other  

11:39 PM Share:


Get updates in your email box
Complete the form below, and we'll send you the best coupons.

Deliver via FeedBurner
Proudly Powered by Blogger.
back to top