if (len==4)
{
DA = new OleDbDataAdapter("SELECT * FROM web_file where left(c_code,4)="+c_codes+";", MyConn);
string sqls="SELECT * FROM web_file where left(c_code,4)="+c_codes+";";
}
else
{
DA = new OleDbDataAdapter("SELECT * FROM web_file where c_code="+c_codes+";", MyConn);
string sqls="SELECT * FROM web_file where c_code="+c_codes+";";
}
Response.Write (sqls);
Response.End();
{
DA = new OleDbDataAdapter("SELECT * FROM web_file where left(c_code,4)="+c_codes+";", MyConn);
string sqls="SELECT * FROM web_file where left(c_code,4)="+c_codes+";";
}
else
{
DA = new OleDbDataAdapter("SELECT * FROM web_file where c_code="+c_codes+";", MyConn);
string sqls="SELECT * FROM web_file where c_code="+c_codes+";";
}
Response.Write (sqls);
Response.End();
if (len==4)
{
sqls = "SELECT * FROM web_file where left(c_code,4)='"+c_codes+"'";
}
DA = new OleDbDataAdapter(sqls, MyConn);
Response.Write(sqls);
Response.End();