Comments by VandrenSKL (Top 16 by date)

Sorry, I'm getting this error "The SelectCommand property has not been initialized before calling 'Fill'."

Below are my code:

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();

// SqlCommand cd = new SqlCommand("EmailDup", conn);

{

String FullName;
String FirstName;
String LastName;

String email = TextBox3.Text.Trim();
String select = select ID from Customer where email=@email limit 1;
cmd.Parameters.AddWithValue("@email", email);

DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Emailid exists')", true);
return;
}


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["Email"].Value = this.TextBox3.Text.Trim();

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.Add("Staff", SqlDbType.NVarChar);
cmd.Parameters["Staff"].Value = this.Label1.Text;


FirstName = TextBox1.Text;
LastName = TextBox2.Text;
FullName = TextBox1.Text + " " + TextBox2.Text;

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)";


try
{
conn.Open();



cmd.ExecuteNonQuery();
ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Record Saved Successfully.');window.location='DataEntry.aspx';", true);


}
catch (Exception ex)
{

yes it doesn't checking on it and still allowing insert data

Hi,

still not success.

Should I use if else?

As it's still able to submit the data without checking it. I just need to pop out the message after submit and it will check it and not allow to submit.

Hi guys,

I able to submit the data into database but how to display if any duplicate data especially email?

Hi Webmaster442,

which line do i need to put?

is it under here?

try
{
conn.Open();

cmd.ExecuteNonQuery();

ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Record Saved Successfully.');window.location='DataEntry.aspx';", true);
}
catch (Exception ex)
{
*CHANGE THIS?*>>>>> Response.Write("Oops!! Following error occured: " + ex.Message.ToString());
}
finally
{
conn.Close();
cmd.Dispose();
}

Sorry, just ignore the DataItemIndex. Which code suppose I put? as all textbox, dropdownlist, those able to put .text but detailsview is not able to put it.

As i had recall the data from Staff table into Customer table.

Sorry, just ignore the DataItemIndex. Which code suppose I put? as all textbox, dropdownlist, those able to put .text but detailsview is not able to put it.

As i had recall the data from Staff table into Customer table.

yes, sorry for that my wrong as I want display username not numeric. Confusing of it.

yes it's come out the result is in numeric, not the user name. That's why I'm confusing this, how to code it.

Hi bro,

the value in the cmd.Parameters["Staff"] is the name of the user.

It will display on the data entry page after login. I want make sure that whoever key in the data, we can able to know whose key in and both are different table.

thank you

this line:

cmd.Parameters.AddWithValue("Staff";, SqlDbType.NVarChar);
cmd.Parameters["Staff"].Value = this.DetailsView2.DataItemIndex;

Others field able to goes into database after user key in the textbox.

For the detailsview, it will display the username from Staff table. How to make it insert into Customer table?

thank you