Click here to Skip to main content
15,884,177 members
Home / Discussions / C#
   

C#

 
QuestionTask ContinueWith Pin
MAW3012-Mar-13 16:20
MAW3012-Mar-13 16:20 
AnswerRe: Task ContinueWith Pin
Simon_Whale13-Mar-13 0:11
Simon_Whale13-Mar-13 0:11 
QuestionRetreiving a list of network computer Pin
R4yth3ron12-Mar-13 6:55
R4yth3ron12-Mar-13 6:55 
AnswerRe: Retreiving a list of network computer Pin
Ingo12-Mar-13 7:08
Ingo12-Mar-13 7:08 
GeneralRe: Retreiving a list of network computer Pin
R4yth3ron12-Mar-13 7:18
R4yth3ron12-Mar-13 7:18 
AnswerRe: Retreiving a list of network computer Pin
Ingo17-Mar-13 22:56
Ingo17-Mar-13 22:56 
AnswerRe: Retreiving a list of network computer Pin
OriginalGriff12-Mar-13 21:08
mveOriginalGriff12-Mar-13 21:08 
QuestionError C# : Conversion failed when converting the nvarchar value 'd' to data type int. Pin
Hodamdi11-Mar-13 22:31
Hodamdi11-Mar-13 22:31 
Hi I want to insert data from some text box to table of sqldatabase but some field is int and some one is nvarchar how to convert text of text box to them i do below code but i have

constr = "Data Source=SAFA4-PC;Initial Catalog=StudentDb;Integrated Security=True";
System.Data.SqlClient.SqlConnection Conn = new System.Data.SqlClient.SqlConnection();
Conn.ConnectionString = constr;
Conn.Open();
System.Data.SqlClient.SqlCommand Comm = new System.Data.SqlClient.SqlCommand();
Comm.CommandText = "insert into Tbl_Student (Code ,Name ,LastName ,CityCode ,Address ,BirthDay ,FatherName ,ID,CodeMeli,tel ) values( @Code,@Name,@LastName,@FatherName,@Id,@MeliCode,@Tel,@Address,@BirthDay,@CityCombo)";
Comm.CommandType = System.Data.CommandType.Text;
Comm.Connection = Conn;
Comm.Parameters.Add("@Code", SqlDbType.Int);//, int.Parse(StudentCode.Text));
Comm.Parameters["@Code"].Value = int.Parse(StudentCode.Text);
Comm.Parameters.Add("@Name", SqlDbType.NVarChar);//Name.Text);
Comm.Parameters["@Name"].Value = Name.Text;
Comm.Parameters.Add("@LastName", SqlDbType.NVarChar);// LastName.Text);
Comm.Parameters["@LastName"].Value = LastName.Text;
Comm.Parameters.Add("@FatherName", SqlDbType.NVarChar);// FatherName.Text);
Comm.Parameters["@FatherName"].Value =FatherName.Text;
Comm.Parameters.Add("@Id", SqlDbType.Int); //int.Parse(Id.Text));
Comm.Parameters["@Id"].Value = int.Parse(Id.Text);
Comm.Parameters.Add("@MeliCode",SqlDbType.Int);
Comm.Parameters["@MeliCode"].Value = int.Parse(MeliCode.Text);
Comm.Parameters.Add("@Tel",SqlDbType.Int);
Comm.Parameters["@Tel"].Value = int.Parse(Tel.Text);
Comm.Parameters.Add("@Address",SqlDbType.NVarChar);
Comm.Parameters["@Address"].Value = Address.Text;
Comm.Parameters.Add("@BirthDay", SqlDbType.Char);// BirthDay.Text);
Comm.Parameters["@BirthDay"].Value = BirthDay.Text.ToString();
Comm.Parameters.AddWithValue("@CityCombo", CityCombo.ValueMember);
Comm.ExecuteNonQuery();
Conn.Close();

this error :
Conversion failed when converting the nvarchar value 'd' to data type int.

Please help me
AnswerRe: Error C# : Conversion failed when converting the nvarchar value 'd' to data type int. Pin
Karthik Harve11-Mar-13 22:48
professionalKarthik Harve11-Mar-13 22:48 
AnswerRe: Error C# : Conversion failed when converting the nvarchar value 'd' to data type int. Pin
Abhinav S12-Mar-13 2:31
Abhinav S12-Mar-13 2:31 
AnswerRe: Error C# : Conversion failed when converting the nvarchar value 'd' to data type int. Pin
Bernhard Hiller12-Mar-13 4:55
Bernhard Hiller12-Mar-13 4:55 
QuestionHOW I PROVIDE SECURITY OF MY DLL FILE FROM END USER Pin
seema jadhav11-Mar-13 21:09
seema jadhav11-Mar-13 21:09 
SuggestionRe: HOW I PROVIDE SECURITY OF MY DLL FILE FROM END USER Pin
Richard MacCutchan11-Mar-13 22:51
mveRichard MacCutchan11-Mar-13 22:51 
AnswerRe: HOW I PROVIDE SECURITY OF MY DLL FILE FROM END USER Pin
Pete O'Hanlon11-Mar-13 23:15
mvePete O'Hanlon11-Mar-13 23:15 
AnswerRe: HOW I PROVIDE SECURITY OF MY DLL FILE FROM END USER Pin
Bernhard Hiller12-Mar-13 5:00
Bernhard Hiller12-Mar-13 5:00 
Questionhow i protect my dll from end user Pin
seema jadhav11-Mar-13 21:02
seema jadhav11-Mar-13 21:02 
QuestionChanging C# control reference Pin
Member 979127411-Mar-13 20:00
Member 979127411-Mar-13 20:00 
AnswerRe: Changing C# control reference Pin
Pete O'Hanlon12-Mar-13 8:11
mvePete O'Hanlon12-Mar-13 8:11 
QuestionFile download in Class Library Pin
Member 961703711-Mar-13 18:18
Member 961703711-Mar-13 18:18 
AnswerRe: File download in Class Library Pin
Dave Kreskowiak11-Mar-13 19:05
mveDave Kreskowiak11-Mar-13 19:05 
GeneralRe: File download in Class Library Pin
Member 961703711-Mar-13 19:35
Member 961703711-Mar-13 19:35 
GeneralRe: File download in Class Library Pin
Richard MacCutchan11-Mar-13 22:56
mveRichard MacCutchan11-Mar-13 22:56 
QuestionSimple helper class for DateTime? Pin
Goaty6510911-Mar-13 12:59
Goaty6510911-Mar-13 12:59 
AnswerRe: Simple helper class for DateTime? Pin
Garth J Lancaster11-Mar-13 13:13
professionalGarth J Lancaster11-Mar-13 13:13 
AnswerRe: Simple helper class for DateTime? Pin
Dave Kreskowiak11-Mar-13 13:22
mveDave Kreskowiak11-Mar-13 13:22 

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

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