Inserting Records

[kannaworld]

Hai all

I wrote a common piece of code for inserting the records in a table using c#, i stored the control names in a Database table with the type of control, and the table field name will be same as control name so i retrived the values and build the string like
str1= "insert tablename colmn1,colmn2 values (cntrlname1.txt,cntrlname2.txt)"

cn.Open();
cmd.Connection = cn;
cmd.CommandText = str1.ToString();
cmd.ExecuteNonQuery();
cn.Close();

The above code inserts directly(cntrlname1.txt,cntrlname2.txt) instead of cntrlname1.txt,cntrlname2.txt values, but if i copy the str1 value and put

cmd.CommandText="insert tablename colmn1,colmn2 values (cntrlname1.txt,cntrlname2.txt)"

it correctly inserts the value of cntrlname1.txt,cntrlname2.txt

Please provide me some solution

[kenobewan]

Welcome the site. By converting str1 to string you are converting the .text to string rather than allowing it to represent the value as a property.

[kannaworld]

Welcome the site. By converting str1 to string you are converting the .text to string rather than allowing it to represent the value as a property.

cn.Open();
            cmd=new SqlCommand("Select Ctrl_Name,Ctrl_Type from VCC_FieldMaster",cn);
            dr=cmd.ExecuteReader();
            while(dr.Read())
            {
                fld += dr[0].ToString() + ",";
                fld1 +="'\"+ ";                                    
                fld1 += dr[0].ToString();
                val += dr[1].ToString()+ ",";
 
                if (dr[1].ToString()=="TT") //TT represent Textbox
                   {                    
                    fld1 += ".Text" + " +\"'" + ",";        
 
                }    
                else if (dr[1].ToString()=="DD") //DD represents Dropdown box
                {
                    fld1 += ".SelectedIndex" + " +\"'" + ",";
                }
            }
            cn.Close();
            fld1 = fld1.Remove(fld1.Length-1,1);
            fld = fld.Remove(fld.Length-1,1);
            qq ="Insert into VCC_Sample(Nam,EmpNo) values";
            qq+="(";
            qq +=  fld1 ;
            qq+=")";
            Response.Write(qq);
            cn.Open();
            cmd.Connection = cn;
            cmd.CommandText = qq;
            cmd.ExecuteNonQuery();
            cn.Close();

this is my coding although i avoided .Tostring() it does the same!!!

[kenobewan]

You have the same problem - try:

qq ="Insert into VCC_Sample(Nam,EmpNo) values";
qq+="(";
qq += "'" & fld1 & "'";
qq+=")";

[kannaworld]

You have the same problem - try:

qq ="Insert into VCC_Sample(Nam,EmpNo) values";
qq+="(";
qq += "'" & fld1 & "'";
qq+=")";

This is the buid error i get on using that

Operator '&' cannot be applied to operands of type 'string' and 'string'

[kenobewan]

Try + and some debugging.