Insert data from more than one table of user interface into one table of sqlserver

hiiiii
how are you.
hope you will be fine
i have a question regarding sqlserver
i am working in asp.net and i am using sqlserver for databse
.................
i have user interface of registration form in which i have more than one tables . and i want insert data into one table of sqlserver .
i used insert string and it is fine.........
if i execute project i am getting error string

"String or binary data would be truncated. The statement has been terminated.
"
can you help me to solve this problem.........

The reason of this problem is that - you have created a column with small size and you are trying to insert a string of larger size. Some thing like this -

Create table employee ( id int , name varchar(10))
go

If I insert a row like this -

Insert into employee values ( 1 , 'xyzabcmnopq')
go

This would create an error -

Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.


I think you must have figured out the root of the problem. Reply if this doesn't help you.


- Som Dutt
http://somdutt.blogspot.com

I am having a similar issue. I have verified that my C# code sets the field lengths and datatypes properly (the field sizes are identical to the field sizes in my database). I have also set the MaxLength value of each web form field properly, but I still get the "String or binary data would be truncated" error. My code is below. Help!!!

SqlCommand myCmd = new SqlCommand("CO_AssetSave", myConn);
if( myConn.State == ConnectionState.Closed ) myConn.Open();
myCmd.CommandType = CommandType.StoredProcedure;
SqlParameter pSerial = new SqlParameter("@Serial", SqlDbType.VarChar, 50);
pSerial.Value = txtSerial.Text.Trim();
myCmd.Parameters.Add(pSerial);
SqlParameter pName = new SqlParameter("@Name", SqlDbType.VarChar, 50);
pName.Value = txtName.Text.Trim();
myCmd.Parameters.Add(pName);
SqlParameter pAddress = new SqlParameter("@Address", SqlDbType.VarChar, 50);
pAddress.Value = txtAddress.Text.Trim();
myCmd.Parameters.Add(pAddress);
SqlParameter pSuite = new SqlParameter("@Suite", SqlDbType.VarChar, 20);
pSuite.Value = txtSuite.Text.Trim();
myCmd.Parameters.Add(pSuite);
SqlParameter pCity = new SqlParameter("@City", SqlDbType.VarChar, 25);
pCity.Value = txtCity.Text.Trim();
myCmd.Parameters.Add(pCity);
SqlParameter pState = new SqlParameter("@State", SqlDbType.VarChar, 2);
pState.Value = txtState.Text.Trim();
myCmd.Parameters.Add(pState);
SqlParameter pZip = new SqlParameter("@Zip", SqlDbType.VarChar, 10);
pZip.Value = txtZip.Text.Trim();
myCmd.Parameters.Add(pZip);
SqlParameter pAreaCode = new SqlParameter("@AreaCode", SqlDbType.VarChar, 3);
pAreaCode.Value = txtAreaCode.Text.Trim();
myCmd.Parameters.Add(pAreaCode);
SqlParameter pPhone = new SqlParameter("@Phone", SqlDbType.VarChar, 8);
pPhone.Value = txtPhone.Text.Trim();
myCmd.Parameters.Add(pPhone);
SqlParameter pExtension = new SqlParameter("@Extension", SqlDbType.VarChar, 5);
pExtension.Value = txtExtension.Text.Trim();
myCmd.Parameters.Add(pExtension);
SqlParameter pEnvironment = new SqlParameter("@Environment", SqlDbType.VarChar, 25);
pEnvironment.Value = txtEnvironment.Text.Trim();
myCmd.Parameters.Add(pEnvironment);
SqlParameter pTitle = new SqlParameter("@Title", SqlDbType.VarChar, 25);
pTitle.Value = txtTitle.Text.Trim();
myCmd.Parameters.Add(pTitle);
SqlParameter pBuild = new SqlParameter("@Build", SqlDbType.VarChar, 50);
pBuild.Value = txtBuild.Text.Trim();
myCmd.Parameters.Add(pBuild);
SqlParameter pTraining = new SqlParameter("@Training_Device", SqlDbType.Int, 4);
if (chkTraining.Checked == true) pTraining.Value = 1;
else pTraining.Value = 0;
myCmd.Parameters.Add(pTraining);
SqlParameter pComments = new SqlParameter("@Comments", SqlDbType.VarChar, 300);
pComments.Value = txtComments.Text.Trim();
myCmd.Parameters.Add(pComments);
SqlParameter pUser = new SqlParameter("@Tech_Name", SqlDbType.VarChar, 50);
pUser.Value = Session["Tech_Name"].ToString();
myCmd.Parameters.Add(pUser);
myCmd.ExecuteNonQuery();
if( myConn.State == ConnectionState.Open ) myConn.Close();