i have problem with insertion where when i add parameters using store procedure its added to sql datanase but not shown on grid view and the below the code using
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.IO;
using System.Drawing;
public partial class Admin_Leader : System.Web.UI.Page
{
String strConnString = ConfigurationManager.ConnectionStrings["EVDBConnectionString2"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBind();
}
Stamp.Text = DateTime.Now.ToString("MM'/'dd'/'yyyy HH':'mm':'ss");
Month.Text = DateTime.Now.ToString("MMM");
TLscore.Text = "";
Intiative.Text = "";
Label7.Visible = false;
TLscore.Visible = false;
Intiative.Visible = false;
Label1.Visible = false;
Label2.Visible = false;
Button3.Visible = false;
}
protected void Button1_Click(object sender, EventArgs e)
{
if (GridView1.Rows.Count == 0)
{
GridView1.Visible = false;
TLscore.Visible = true;
Intiative.Visible = true;
Label1.Visible = true;
Label2.Visible = true;
Button3.Visible = true;
Label5.Visible = true;
Label6.Visible = true;
Label5.Text = " No Score Adding for " ;
Label6.Text = DateTime.Now.ToString("MMM");
}
else
{
GridView1.Visible = true;
}
}
protected void Stamp_TextChanged(object sender, EventArgs e)
{
}
protected void LoginID_TextChanged(object sender, EventArgs e)
{
}
protected void Button3_Click(object sender, EventArgs e)
{
Label5.Visible = false;
Label6.Visible = false;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "tlscore";
cmd.Parameters.Add("@loginid", SqlDbType.Int).Value = LoginID.Text.Trim();
cmd.Parameters.Add("@tlscore", SqlDbType.Int).Value = TLscore.Text.Trim();
cmd.Parameters.Add("@initative", SqlDbType.Int).Value = Intiative.Text.Trim();
cmd.Parameters.Add("@month", SqlDbType.NVarChar).Value = Month.Text.Trim();
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
Label7.Visible = true;
Label7.Text = "Record inserted successfully";
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
con.Close();
con.Dispose();
}
}
}
