How to search a textbox entered number digit by digit

Question

0.00/5 (No votes)

See more:

VS2010

I want to search a textbox entered number digit by digit from back like using array and then show that results in gridview.

Like number is 6173456...
now on button click it should first search the whole no i.e 6173456,then...
if found ok...show it in gridview...otherwise find first five no's 617345....and like wise so on....

What I have tried:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Net;
using System.Net.Sockets;
using System.Data.Odbc;
using System.Net.Mail;
using System.Text;
using System.IO;
using System.Drawing;
using System.Collections.Generic;
using System.Linq;

public partial class _Default : System.Web.UI.Page
{
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{

}

private void bind()
{
int[] array = new int[50];
char[] sep = { '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' };

String[] numbers = TextBox1.Text.Split(sep);
//char[] sample = TextBox1.Text.ToCharArray();
//int i = Convert.ToInt32(TextBox1.Text);
// int[] i = Convert.ToInt32(TextBox1.Text).ToCharArray();
for (int i = 0; i < 7; i++)
{
//array[i] = int.Parse(sample[i].ToString());
//array[i] = Int32.Parse(numbers[i]);
array = array = TextBox1.Text.Split().Select(h => Int32.Parse(h)).ToArray();
//DataSet ds = new DataSet();
OdbcConnection con = new OdbcConnection(ConfigurationManager.ConnectionStrings["connect1"].ConnectionString);
OdbcCommand cmd = new OdbcCommand("select prefix as Prefix , destination as Destination, rates as Rates from allrates where prefix = '" + array[i] + "'", con);
con.Open();
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
da.Fill(ds);
con.Close();

if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();

}

}

}

protected void Button1_Click(object sender, EventArgs e)
{
bind();
}
}

Posted 11-Aug-16 23:11pm

mridulkoul123

Updated 11-Aug-16 23:29pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2016-08-11T23:29:00

Solution 1

For starters, don't do it like that. Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.

One way to look at this is to use a substring, because Split removes the matching characters, so you will get an array of empty strings rather than anything shorter.

C#

public static string[] GetShorterNumbers(string numbers)
    {
    int len = numbers.Length;
    string[] result = new string[len];
    for (int i = 0; i < len; i++)
        {
        result[i] = numbers.Substring(0, len - i);
        }
    return result;
    }

Then you have a choice how to do this: either issue SQL commands for each string in turn until you get a match, or use an OR clause to do them all at once, and take the longest result.

Posted 11-Aug-16 23:29pm

OriginalGriff

Comments

mridulkoul123 12-Aug-16 6:34am

Thanks a ton...you saved me....but sorry for inconvenience ,its just that i am not able to fetch the result in gridview. May be i am sick today...

what i am trying to say is when insert a number like '614' in textbox and if this number is not in database then series containing '61' should show in gridview and if 61 is not there then '6' series numbers should show in gridview...

what i tried so far...

int len = TextBox1.Text.Length;
string[] result = new string[len];
for (int i = 0; i < len; i++)
{
result[i] = TextBox1.Text.Substring(0, len - i);
OdbcConnection con = new OdbcConnection(ConfigurationManager.ConnectionStrings["connect1"].ConnectionString);
OdbcCommand cmd = new OdbcCommand("select prefix as Prefix , destination as Destination, rates as Rates from allrates where prefix = '" + result[i] + "'", con);
con.Open();
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
da.Fill(ds);
con.Close();

if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();

}

OriginalGriff 12-Aug-16 6:42am

So what you need to do is add a break when you find the first non-set set returned by your DataAdapter.

And don't concatenate strings! Always use a parameterized query, or your user can do exactly what he likes with your database, including delete it...

mridulkoul123 12-Aug-16 6:47am

can you elaborate it bit with example from above....again sorry for the inconvenience ...

OriginalGriff 12-Aug-16 6:48am

You are kidding, right?
:sigh:
Add the line:

break;

after the line

GridView1.DataBind();

mridulkoul123 12-Aug-16 6:55am

Are you saying something like this:

int len = TextBox1.Text.Length;
string[] result = new string[len];
for (int i = 0; i < len; i++)
{
result[i] = TextBox1.Text.Substring(0, len - i);
OdbcConnection con = new OdbcConnection(ConfigurationManager.ConnectionStrings["connect1"].ConnectionString);
OdbcCommand cmd = new OdbcCommand("select prefix as Prefix , destination as Destination, rates as Rates from allrates where prefix = '" + result[i] + "'", con);
con.Open();
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
da.Fill(ds);
con.Close();

if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;

break;

GridView1.DataBind();
}

}

OriginalGriff 12-Aug-16 7:03am

Read what I said: "**after** the line"
And use a parameterised query!

mridulkoul123 12-Aug-16 7:11am

I did like this:

int len = TextBox1.Text.Length;
string[] result = new string[len];
for (int i = 0; i < len; i++)
{
result[i] = TextBox1.Text.Substring(0, len - i);
OdbcConnection con = new OdbcConnection(ConfigurationManager.ConnectionStrings["connect1"].ConnectionString);
OdbcCommand cmd = new OdbcCommand("select prefix as Prefix , destination as Destination, rates as Rates from allrates where prefix = '" + result[i] + "'", con);
con.Open();
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
da.Fill(ds);
con.Close();

if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
break;
}

}

didn't work

OriginalGriff 12-Aug-16 7:19am

And what does the debugger say is happening?

mridulkoul123 12-Aug-16 7:29am

its just nothing shows on the page after button click and i used breakpoint here

if (ds.Tables[0].Rows.Count > 0) // THIS IS COMING FALSE HERE..SO NOT GETTING INSIDE IF LOOP...
{
GridView1.DataSource = ds;

GridView1.DataBind();
break;
}

OriginalGriff 12-Aug-16 7:31am

So...you need to look at your data. Does any of it match what you are entering?

mridulkoul123 12-Aug-16 7:35am

YES...i am entering '6134572' in textbox and in database i have '6134571', '6134570', '6134569' and so on...
so it should show series having '613457'...but it didn't

OriginalGriff 12-Aug-16 7:57am

Well no, it won't. You are asking it for exact matches:
... WHERE prefix = '613457'
... WHERE prefix = '61345'
...
If you want a "starts with" comparison you have to ask for one using LIKE:
... WHERE prefix LIKE '613457%'
... WHERE prefix LIKE '61345%'
...

mridulkoul123 12-Aug-16 7:56am

are u there @OriginalGriff

mridulkoul123 16-Aug-16 3:09am

Thanks @OriginalGriff ... it worked ...thanks a lot...it means lot to me..i know you are master of your field ...but if anyhow you need me in future ...do let me know ...i am ready to help you in anyway possible...

OriginalGriff 16-Aug-16 3:30am

You're welcome!
And thank you, I'll remember your offer!