SQL Query String
-
Can u pls tell me, wether following SQL string format is correct or not. textWord.text,comboCat.text are string variables of C#. indexInCategoryTable and SubCategoryNo are integer variables. "select * from Words where word = N'"+textWord.Text+"' and CategoryTableName = '"+comboCat.Text+"' and IndexInCategoryTable = 'indexInCategoryTable' and SubCategoryNo = 'SubCategoryNo'";
-
Can u pls tell me, wether following SQL string format is correct or not. textWord.text,comboCat.text are string variables of C#. indexInCategoryTable and SubCategoryNo are integer variables. "select * from Words where word = N'"+textWord.Text+"' and CategoryTableName = '"+comboCat.Text+"' and IndexInCategoryTable = 'indexInCategoryTable' and SubCategoryNo = 'SubCategoryNo'";
No it is not, because your string values you are concatenating into the sql string but your integer values are not. Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
-
No it is not, because your string values you are concatenating into the sql string but your integer values are not. Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
Can U Pls modify the above Query to make it correct.