Hi guys,
I need some help and advice.
I had create the web data entry for user. Once user login, the name of user will appear in the data entry.
After the user entry all the data and submit, all the data are display in the database but without the user name.
The End user named as Staff, I plan to once user login and the name appeared in the data entry page, once they key in, it will auto pump into database and shown who had key in the data.
I using the Detailsview as my display in the page.
Please advice.
Please refer to my below code:
namespace WebPortal
{
public partial class DataEntry : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button7_Click(object sender, EventArgs e)
{
string connectionString = "Data Source=.\\SQLEXPRESS;"
+ "AttachDbFilename=\"C:\\Users\\KLSIT\\Documents\\Visual Studio 2008\\Projects\\WebPortal\\WebPortal\\App_Data\\emaildata.mdf\";"
+ "Integrated Security=True;"
+ "Connect Timeout=30;"
+ "User Instance=True";
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connectionString);
System.Data.SqlClient.SqlCommand cmd = conn.CreateCommand();
String FullName;
String FirstName;
String LastName;
cmd.Parameters.Add("Type", SqlDbType.NVarChar);
cmd.Parameters["Type"].Value = this.DropDownList2.Text;
cmd.Parameters.Add("Title", SqlDbType.NVarChar);
cmd.Parameters["Title"].Value = this.DropDownList1.Text;
cmd.Parameters.Add("FirstName", SqlDbType.NVarChar);
cmd.Parameters["FirstName"].Value = this.TextBox1.Text;
cmd.Parameters.Add("LastName", SqlDbType.NVarChar);
cmd.Parameters["LastName"].Value = this.TextBox2.Text;
cmd.Parameters.Add("Fullname", SqlDbType.NVarChar);
cmd.Parameters["Fullname"].Value = this.TextBox1.Text + "" + this.TextBox2.Text;
cmd.Parameters.Add("Email", SqlDbType.NVarChar);
cmd.Parameters["Email"].Value = this.TextBox3.Text;
cmd.Parameters.Add("Job_Title", SqlDbType.NVarChar);
cmd.Parameters["Job_Title"].Value = this.TextBox4.Text;
cmd.Parameters.Add("Company", SqlDbType.NVarChar);
cmd.Parameters["Company"].Value = this.TextBox5.Text;
cmd.Parameters.Add("Mobile_Phone", SqlDbType.NVarChar);
cmd.Parameters["Mobile_Phone"].Value = this.TextBox6.Text;
cmd.Parameters.Add("Office_Phone", SqlDbType.NVarChar);
cmd.Parameters["Office_Phone"].Value = this.TextBox7.Text;
cmd.Parameters.AddWithValue("Staff", SqlDbType.NVarChar);
cmd.Parameters["Staff"].Value = this.DetailsView2.DataItemIndex;
FirstName = TextBox1.Text;
LastName = TextBox2.Text;
FullName = LastName + " " + FirstName;
cmd.CommandText = "INSERT INTO [Customer] ([Type], [Title], [Firstname], [Lastname], [Fullname], [Company], [Email], [Mobile_Phone], [Office_Phone], [Job_Title], [Staff]) VALUES (@Type, @Title, @Firstname, @Lastname, @Fullname, @Company, @Email, @Mobile_Phone, @Office_Phone, @Job_Title, @Staff)";
conn.Open();
int numberOfRows = cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect("Homepage.aspx");