TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
sachi vasishta
NA
252
0
How to write queriestring inside the xml file and how to replace the value of a string in the querystring
Nov 22 2011 8:03 AM
Hi All,
I have a function call in file1.aspx.cs where I am passing two string values as below.
string strQuery = GlobalQuery.GetQuery(seccondSelection, prefixText);
and inside the GlobalQuery class I have the following code for the static function GetQuery.
public static string GetQuery(string strType, string strLikeChar)
{
strAT = "sample 1";
strMK = "sample 2";
strSN = "sample 3";
string strReturn = string.Empty;
string strDynamic = string.Empty;
strDynamic = "Dynamic";
if ((strLikeChar != "") && (strType != "Aircraft")) strDynamic = strType + "_" + strDynamic;
else strDynamic = strType;
dynamicString = strLikeChar.ToUpper(); //first change
switch (strDynamic)
{
case "Aircraft_Dynamic":
strReturn =
"SELECT h.FUNCTION_NO, Eng_Function_API.Get_Description(FUNCTION_NO) Func_desc "
+ " FROM test_table h "
+ "FROM test_table h WHERE h.PRODUCT_NO = '" +
strAT
+ "'"
+ " AND h.MODEL_NO = '" +
strMK
+ "'"
+ " UPPER(Eng_Function_API.Get_Description(FUNCTION_NO)) LIKE '" + dynamicString + "%'"
+ " and h.parent_function_no is null ";
break;
case "Aircraft":
strReturn =
"SELECT h.FUNCTION_NO,Eng_Function_API.Get_Description(FUNCTION_NO) Func_desc "
+ "FROM test_table h WHERE h.PRODUCT_NO = '" +
strAT
+ "'"
+ " AND h.MODEL_NO = '" +
strMK
+ "'"
+ " and h.parent_function_no is null ";
break;
// have 2 more case values which will retrieve different set of data.
}
}
Now I want know how to write the query part (highlited in red) in XMlL file and how to replace string values inside the query in XML file(highlited in blue)..
I also want to know how to get that querystring from the XML file
string strQuery = GlobalQuery.GetQuery(seccondSelection, prefixText); // GlobalQuery.GetQuery(seccondSelection, prefixText); should be replaced by the XML file which should contain the query part.
Thanks, Sachi
Reply
Answers (
6
)
is there any way to show the other page in ajax model page
Count online person rely ip address and update online person automatic ??