hey i'm using C Sharp with Sql Server 2005
i have created two table which are as
table 1( CardType): Cardcode, Description.
table 2(CreditCard):Cardcode,number, expirationdate,SecCode.
the both the table having relation between them of Cardcode.
but when i used Combo box in C sharp to display the value of CardType.description it work
but when i want to save the value of cardType.description to creditcard.cardcode it is not working
can anybody over here tell me how itz work
public partial class CreditCard : Form
{
public CreditCard()
{
InitializeComponent();
}
private void CreditCard_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'inFlowDataSet.Card_Type' table. You can move, or remove it, as needed.
this.card_TypeTableAdapter.Fill(this.inFlowDataSet .Card_Type);
}
private void button1_Click(object sender, EventArgs e)
{
string ConnectionString = "Data source=MAHER-PC\\SQLEXPRESS1;Initial Catalog=inFlow;Integrated Security=true";
SqlConnection MyConnection = new SqlConnection(ConnectionString);
string SQLquery = "Insert into Credit_Card(Card_code,number,Expiration_Date,Sec_C ode)";
SQLquery += " values(@Card_code,@number,@Expiration_Date,@Sec_Co de)";
try
{
MyConnection.Open();
SqlCommand Cmd = new SqlCommand(SQLquery, MyConnection);
Cmd.Parameters.AddWithValue("@Card_code", card_TypeTableAdapter = CreditCard.Card_code comboBox1.Text.ToString());
Cmd.Parameters.AddWithValue("@number", Convert.ToInt64(textBox1.Text));
Cmd.Parameters.AddWithValue("@Expiration_Date", textBox2.Text);
Cmd.Parameters.AddWithValue("@Sec_Code", (textBox3.Text).ToUpper());
Cmd.ExecuteNonQuery();
MessageBox.Show("records successfully added", "Howdy", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Close();
}
catch (SqlTruncateException sqlTruncateEx)
{
MessageBox.Show(sqlTruncateEx.Message);
}
catch (SqlTypeException sqlTypeEx)
{
MessageBox.Show(sqlTypeEx.Message);
}
catch (Exception er)
{
MessageBox.Show(er.Message);
//}
finally
{
MyConnection.Close();
}
}