using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["payroll"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
}
protected void button_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into payroll values (nameemployee,[Employee Code],Department,Designation,numberofLeave)";
cmd.Connection = cn;
SqlParameter nameemployee = new SqlParameter("[nameemployee]", SqlDbType.VarChar, 50);
nameemployee.Value = txtnameemployee.Text.ToString();
cmd.Parameters.Add(nameemployee);
SqlParameter employeecode = new SqlParameter("[Employee Code]", SqlDbType.VarChar, 50);
employeecode.Value = txtemployeecode.Text.ToString();
cmd.Parameters.Add(employeecode);
SqlParameter desigation = new SqlParameter("Designation", SqlDbType.VarChar, 50);
desigation.Value = ddlDsg.SelectedItem.Text.ToString();
cmd.Parameters.Add(desigation);
SqlParameter department = new SqlParameter("Department", SqlDbType.VarChar, 50);
department.Value = ddlDept.SelectedItem.Text.ToString();
cmd.Parameters.Add(department);
SqlParameter numberofleave = new SqlParameter("numberofLeave", SqlDbType.VarChar,50);
numberofleave.Value = ddlcl.SelectedItem.Text.ToString();
cmd.Parameters.Add(numberofleave);
SqlParameter numberofleave1 = new SqlParameter("numberofLeave", SqlDbType.VarChar,50);
numberofleave.Value = ddlpl.SelectedItem.Text.ToString();
SqlParameter LeaveofRequestForm = new SqlParameter("LeaveofRequestForm", SqlDbType.VarChar, 50);
LeaveofRequestForm.Value = txtleaveofrequestform.Text.ToString();
cmd.Parameters.Add(LeaveofRequestForm);
//cmd.ExecuteNonQuery();
txtnameemployee.Text = "";
txtemployeecode.Text = "";
ddlDsg.SelectedItem.Text = "";
ddlDept.SelectedItem.Text = "";
ddlpl.SelectedItem.Text = "";
ddlcl.SelectedItem.Text = "";
txtleaveofrequestform.Text = "";
}
}
I my running my project. mmy data is not going on sql database.please tell me. it is urgently
Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator