Parse numbers in singe textbox for query
- by Joshua Slocum
I’ve built a webform in Visual Web Developer Express 2008 to help me with my work. I use a webform to run query requests that are emailed to me. The inputs are in this format
12312 12312
12312 12312
12312 12312
12312 12312
I enter the first number in a textbox and the second number in another textbox and click a button that runs a query and returns the results in a gridview(single row).
string strConn, strSQL;
strConn = AppConfig.Connection
strSQL = 'select fields from table where FirstNum=:FirstNum and SecondNum=:SecondNum';
using (OracleConnection cn = new OracleConnection(strConn))
{
OracleCommand cmd = new OracleCommand(strSQL, cn);
cmd.Parameters.AddWithValue(":FirstNum", txtFirstNum.Text);
cmd.Parameters.AddWithValue(":SeconNum",
txtSecondNum.Text);
cn.Open();
using (OracleDataReader rdr = cmd.ExecuteReader())
{
dgResults.DataSource = rdr;
dgResults.DataBind();
}
cn.Close();
}
I had an idea to help me speed up my work. I’d like to be able to past both numbers in a single textbox
( like this 12312 12312 )
and have the code parse out the nubmers for the query. Or even better would be to past all of them in a multiline textbox like this
12312 12312
12312 12312
12312 12312
12312 12312
And have them all parsed and the query run for each line and the results all output to one gridview. I’m just not sure how to approach this. Any suggestions would be appreciated.
Thank you.
