Click here to Skip to main content
11,412,833 members (74,383 online)
   

C#

 
AnswerRe: multiple loading of assemblies - does it have any associated problems? Pin
BobJanova at 3-Oct-12 6:05
memberBobJanova3-Oct-12 6:05 
QuestionWhen to use .PerformClick() Pin
MAW30 at 1-Oct-12 16:07
memberMAW301-Oct-12 16:07 
AnswerRe: When to use .PerformClick() Pin
DaveyM69 at 1-Oct-12 17:05
mentorDaveyM691-Oct-12 17:05 
GeneralRe: When to use .PerformClick() Pin
MAW30 at 1-Oct-12 17:55
memberMAW301-Oct-12 17:55 
AnswerRe: When to use .PerformClick() Pin
Dave Kreskowiak at 2-Oct-12 2:32
mvpDave Kreskowiak2-Oct-12 2:32 
GeneralRe: When to use .PerformClick() Pin
DaveyM69 at 2-Oct-12 4:02
mentorDaveyM692-Oct-12 4:02 
AnswerRe: When to use .PerformClick() Pin
Ravi Bhavnani at 2-Oct-12 7:22
memberRavi Bhavnani2-Oct-12 7:22 
Questionwhy i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Kay Pee Singh at 1-Oct-12 13:46
memberKay Pee Singh1-Oct-12 13:46 
why i cant store vales in database ???



private void Form8registration_Load(object sender, EventArgs e)
{
conn.Open();

}


private void ExecuteInsert(string empname, string desgination, string emailid, string phone, string skype, string address, string shifttime, string panel)
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}

using (conn)
{

try
{


SqlCommand cmdd = new SqlCommand();
//cmdd.CommandType = CommandType.StoredProcedure;
cmdd.CommandText = "Insert into registrationn values (@empname,@desgination,@emailid,@phone,@skype,@address,@shifttime,@panel)";
cmdd.CommandType = CommandType.Text;
cmdd.Connection = conn;

// cmdd.Parameters.Add("@empid", SqlDbType.VarChar, 150).Value = textBox7_empid.Text;



cmdd.Parameters.Add("@empname", SqlDbType.VarChar, 150).Value = empname;
cmdd.Parameters.Add("@desgination", SqlDbType.VarChar, 150).Value = desgination;
cmdd.Parameters.Add("@emailid", SqlDbType.VarChar, 150).Value = emailid;
cmdd.Parameters.Add("@phone", SqlDbType.VarChar, 150).Value = phone;
cmdd.Parameters.Add("@skype", SqlDbType.VarChar, 150).Value = skype;
cmdd.Parameters.Add("@address", SqlDbType.VarChar, 150).Value = address;
cmdd.Parameters.Add("@shifttime", SqlDbType.VarChar, 150).Value = shifttime;
cmdd.Parameters.Add("@panel", SqlDbType.VarChar, 150).Value = panel;
SqlParameter p1 = new SqlParameter("@ret", SqlDbType.VarChar, 150);
p1.Direction = ParameterDirection.ReturnValue;




cmdd.ExecuteNonQuery();
cmdd.Dispose();
}

catch (Exception ex)
{
string msg = "insert error ";
msg += ex.Message;
throw new Exception(msg);

}

finally
{
conn.Close();

}

}

}




private void button2_reset_Click(object sender, EventArgs e)
{
Reset();
}

private void Reset()
{
textBox1_add.Text = "";
textBox3_phoneno.Text = "";
textBox4_emailid.Text = "";
textBox5_desgination.Text = "";
textBox6_name.Text = "";
textBox7_empid.Text = "";
comboBox1_shifttime.SelectedText= "";
textBox1_skpid.Text = "";
}

private void button3_cancel_Click(object sender, EventArgs e)
{
Close();
}






private void button1_submit_Click(object sender, EventArgs e)
{
if (radioButton1_employe.Checked == true)
{
ExecuteInsert(textBox6_name.Text, textBox5_desgination.Text, textBox4_emailid.Text, textBox3_phoneno.Text, textBox1_skpid.Text, textBox1_add.Text, comboBox1_shifttime.SelectedItem.ToString(), radioButton1_employe.Checked.ToString());
}
else
{

MessageBox.Show("data not stored ");
}
}
AnswerRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Smart Arab at 2-Oct-12 3:45
memberSmart Arab2-Oct-12 3:45 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Eddy Vluggen at 2-Oct-12 4:24
memberEddy Vluggen2-Oct-12 4:24 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Kay Pee Singh at 2-Oct-12 7:52
memberKay Pee Singh2-Oct-12 7:52 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Eddy Vluggen at 2-Oct-12 9:06
memberEddy Vluggen2-Oct-12 9:06 
Generalcan u tell me where is the error in this code so i can change .....?? Pin
Kay Pee Singh at 2-Oct-12 11:08
memberKay Pee Singh2-Oct-12 11:08 
AnswerRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Eddy Vluggen at 2-Oct-12 4:25
memberEddy Vluggen2-Oct-12 4:25 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Kay Pee Singh at 2-Oct-12 7:51
memberKay Pee Singh2-Oct-12 7:51 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Pete O'Hanlon at 2-Oct-12 8:34
protectorPete O'Hanlon2-Oct-12 8:34 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Kay Pee Singh at 2-Oct-12 10:52
memberKay Pee Singh2-Oct-12 10:52 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Kay Pee Singh at 2-Oct-12 11:02
memberKay Pee Singh2-Oct-12 11:02 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Pete O'Hanlon at 2-Oct-12 11:24
protectorPete O'Hanlon2-Oct-12 11:24 
Generalhow can i check my entered value is going to SQL server or not ???? Pin
Kay Pee Singh at 2-Oct-12 11:56
memberKay Pee Singh2-Oct-12 11:56 
GeneralRe: how can i check my entered value is going to SQL server or not ???? Pin
Pete O'Hanlon at 2-Oct-12 12:16
protectorPete O'Hanlon2-Oct-12 12:16 
GeneralRe: how can i check my entered value is going to SQL server or not ???? Pin
Kay Pee Singh at 2-Oct-12 12:27
memberKay Pee Singh2-Oct-12 12:27 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Kay Pee Singh at 2-Oct-12 12:16
memberKay Pee Singh2-Oct-12 12:16 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Pete O'Hanlon at 3-Oct-12 1:15
protectorPete O'Hanlon3-Oct-12 1:15 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? Pin
Kay Pee Singh at 3-Oct-12 5:55
memberKay Pee Singh3-Oct-12 5:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.150427.1 | Last Updated 27 Apr 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid