hai da kindly chk this coding da.....
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click1(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=10.242.17.143;Initial Catalog='CCloud_Metlife_21JanQA'; uid='Cclouddev';pwd=password-12;");
con.Open();
SqlCommand cmd = new SqlCommand("getexception", con);
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter sqlParam = new SqlParameter();
sqlParam.ParameterName = "@TicketID";
sqlParam.DbType = DbType.Int64;
sqlParam.Value=TextBox1.Text;
sqlParam.Direction = ParameterDirection.Input;
cmd.Parameters.Add(sqlParam);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
GridView1.DataSource = dr;
GridView1.DataBind();
}
con.Close();
}
}