CS0103: The name 'greencom' does not exist in the current context
-
sqlds1.InsertCommandType = SqlDataSourceCommandType.Text;
sqlds1.InsertCommand = "insert into Network (States,LGA,Glo,MTN,Airtel,Etisalat,Multilinks,Starcomms,Visafone,Zoom_mobile,Remarks)values(@countryList,@stateList,@greencom,@mtngsm,@airtel,@etisalat,@multilinks,@starcomms,@visafone,@zoomm,@remarks)";
sqlds1.InsertParameters.Add("countryList", countryList.Text);
sqlds1.InsertParameters.Add("stateList", stateList.Text);
sqlds1.InsertParameters.Add("greencom", greencom.Text);
sqlds1.InsertParameters.Add("mtngsm", mtngsm.Text);
sqlds1.InsertParameters.Add("airtel", aritel.Text);
sqlds1.InsertParameters.Add("etisalat", etisalat.Text);
sqlds1.InsertParameters.Add("multilinks", multilinks.Text);
sqlds1.InsertParameters.Add("starcomms", starcomms.Text);
sqlds1.InsertParameters.Add("visafone", visafone.Text);
sqlds1.InsertParameters.Add("zoomm", zoomm.Text);
sqlds1.InsertParameters.Add("remarks", remarks.Text);
sqlds1.Insert();Above is my snippets but its giving me compile Err. CS0103: The name 'greencom' does not exist in the current context
-
sqlds1.InsertCommandType = SqlDataSourceCommandType.Text;
sqlds1.InsertCommand = "insert into Network (States,LGA,Glo,MTN,Airtel,Etisalat,Multilinks,Starcomms,Visafone,Zoom_mobile,Remarks)values(@countryList,@stateList,@greencom,@mtngsm,@airtel,@etisalat,@multilinks,@starcomms,@visafone,@zoomm,@remarks)";
sqlds1.InsertParameters.Add("countryList", countryList.Text);
sqlds1.InsertParameters.Add("stateList", stateList.Text);
sqlds1.InsertParameters.Add("greencom", greencom.Text);
sqlds1.InsertParameters.Add("mtngsm", mtngsm.Text);
sqlds1.InsertParameters.Add("airtel", aritel.Text);
sqlds1.InsertParameters.Add("etisalat", etisalat.Text);
sqlds1.InsertParameters.Add("multilinks", multilinks.Text);
sqlds1.InsertParameters.Add("starcomms", starcomms.Text);
sqlds1.InsertParameters.Add("visafone", visafone.Text);
sqlds1.InsertParameters.Add("zoomm", zoomm.Text);
sqlds1.InsertParameters.Add("remarks", remarks.Text);
sqlds1.Insert();Above is my snippets but its giving me compile Err. CS0103: The name 'greencom' does not exist in the current context
-
sqlds1.InsertCommandType = SqlDataSourceCommandType.Text;
sqlds1.InsertCommand = "insert into Network (States,LGA,Glo,MTN,Airtel,Etisalat,Multilinks,Starcomms,Visafone,Zoom_mobile,Remarks)values(@countryList,@stateList,@greencom,@mtngsm,@airtel,@etisalat,@multilinks,@starcomms,@visafone,@zoomm,@remarks)";
sqlds1.InsertParameters.Add("countryList", countryList.Text);
sqlds1.InsertParameters.Add("stateList", stateList.Text);
sqlds1.InsertParameters.Add("greencom", greencom.Text);
sqlds1.InsertParameters.Add("mtngsm", mtngsm.Text);
sqlds1.InsertParameters.Add("airtel", aritel.Text);
sqlds1.InsertParameters.Add("etisalat", etisalat.Text);
sqlds1.InsertParameters.Add("multilinks", multilinks.Text);
sqlds1.InsertParameters.Add("starcomms", starcomms.Text);
sqlds1.InsertParameters.Add("visafone", visafone.Text);
sqlds1.InsertParameters.Add("zoomm", zoomm.Text);
sqlds1.InsertParameters.Add("remarks", remarks.Text);
sqlds1.Insert();Above is my snippets but its giving me compile Err. CS0103: The name 'greencom' does not exist in the current context
"insert into Network (States,LGA,Glo,MTN,Airtel,Etisalat,Multilinks,Starcomms,Visafone,Zoom_mobile,Remarks)values this sql not't greencom filed, eg:: sqlds1.InsertCommandType = SqlDataSourceCommandType.Text; sqlds1.InsertCommand = "insert into Network (States,LGA,Glo,MTN,Airtel,Etisalat,Multilinks,Starcomms,Visafone,greencom,Zoom_mobile,Remarks)values(@countryList,@stateList,@greencom,@mtngsm,@airtel,@etisalat,@multilinks,@starcomms,@visafone,@zoomm,@remarks)"; sqlds1.InsertParameters.Add("countryList", countryList.Text); sqlds1.InsertParameters.Add("stateList", stateList.Text); sqlds1.InsertParameters.Add("greencom", greencom.Text); sqlds1.InsertParameters.Add("mtngsm", mtngsm.Text); sqlds1.InsertParameters.Add("airtel", aritel.Text); sqlds1.InsertParameters.Add("etisalat", etisalat.Text); sqlds1.InsertParameters.Add("multilinks", multilinks.Text); sqlds1.InsertParameters.Add("starcomms", starcomms.Text); sqlds1.InsertParameters.Add("visafone", visafone.Text); sqlds1.InsertParameters.Add("zoomm", zoomm.Text); sqlds1.InsertParameters.Add("remarks", remarks.Text); sqlds1.Insert();