Click here to Skip to main content
       

C#

 
AnswerRe: multiple loading of assemblies - does it have any associated problems? PinmemberBobJanova3-Oct-12 5:05 
QuestionWhen to use .PerformClick() PinmemberMAW301-Oct-12 15:07 
AnswerRe: When to use .PerformClick() PinmentorDaveyM691-Oct-12 16:05 
GeneralRe: When to use .PerformClick() PinmemberMAW301-Oct-12 16:55 
AnswerRe: When to use .PerformClick() PinmvpDave Kreskowiak2-Oct-12 1:32 
GeneralRe: When to use .PerformClick() PinmentorDaveyM692-Oct-12 3:02 
AnswerRe: When to use .PerformClick() PinmemberRavi Bhavnani2-Oct-12 6:22 
Questionwhy i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberKay Pee Singh1-Oct-12 12: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 .....?? PinmemberSmart Arab2-Oct-12 2:45 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberEddy Vluggen2-Oct-12 3:24 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberKay Pee Singh2-Oct-12 6:52 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberEddy Vluggen2-Oct-12 8:06 
Generalcan u tell me where is the error in this code so i can change .....?? PinmemberKay Pee Singh2-Oct-12 10:08 
AnswerRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberEddy Vluggen2-Oct-12 3:25 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberKay Pee Singh2-Oct-12 6:51 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinprotectorPete O'Hanlon2-Oct-12 7:34 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberKay Pee Singh2-Oct-12 9:52 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberKay Pee Singh2-Oct-12 10:02 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinprotectorPete O'Hanlon2-Oct-12 10:24 
Generalhow can i check my entered value is going to SQL server or not ???? PinmemberKay Pee Singh2-Oct-12 10:56 
GeneralRe: how can i check my entered value is going to SQL server or not ???? PinprotectorPete O'Hanlon2-Oct-12 11:16 
GeneralRe: how can i check my entered value is going to SQL server or not ???? PinmemberKay Pee Singh2-Oct-12 11:27 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberKay Pee Singh2-Oct-12 11:16 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinprotectorPete O'Hanlon3-Oct-12 0:15 
GeneralRe: why i cant store values in database but my data is correct its not showing any error help me .....?? PinmemberKay Pee Singh3-Oct-12 4: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.141015.1 | Last Updated 21 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid