Replace save database query variable with value using C# and VB.Net in ASP.Net

Question

hi my scenario like belowthe PLN is static value I am reading before call queryI stored the query like this SELECT NAME FROM CONTACTS WHERE CODE  PLN   and I set to PLN variable in login screen so if login usersa than PLNALY after login I call to string query from DATABASE and watching by sql profiler the sql profiler show to me  SELECT NAME FROM CONTACTS WHERE CODE  PLN     instead of SELECT NAME FROM CONTACTS WHERE CODEALYHow can I do

dharmendr · Accepted Answer

Hi  alya14Refer below sampleHTMLltaspButton Text34Save34 runat34server34 OnClick34Save34 gtltbr gtltaspLabel ID34lblQuery34 runat34server34 gtNamespacesCusing SystemConfigurationusing SystemDataSqlClientVBNetImports SystemDataSqlClientCodeCprotected void Saveobject sender EventArgs e    var query  34SELECT Query FROM StoreQuery34    GetNamequery    lblQueryText  GetNamequeryReplace343434 3434Replace3434 3434Replace34PLN34 34aly34private string GetNamestring query    string name  3434    string conString  ConfigurationManagerConnectionStrings34constr34ConnectionString    using SqlConnection con  new SqlConnectionconString            using SqlCommand cmd  new SqlCommandquery con                    conOpen            name  cmdExecuteScalarToString            conClose                return nameVBNe

alya14 · Answer

I solved this issue using parameters like bellowI stored like this WHERE CODEP1and callcmdparametersaddwithvalueP1PLNThanks for your time

Replace save database query variable with value using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us