Multiple values

Shyja Abraham

Hai,

In my form, one textbox and a datagridview,

When we enter the values into the textbox with comas ,the corresponding values displayed into the datagridview from the databse.i want to enter minimum 5 values in to the textbox. plz help?

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Om prakash Singh15y ago
Use code like this..........
SqlConnection conn = null;
        try
        {
            string connString = ConfigurationManager.ConnectionStrings["NorthwindConn"].ConnectionString;
            conn = new SqlConnection(connString);
            string query = "SELECT * FROM Customers";
            SqlCommand cmd = new SqlCommand(query, conn);
            conn.Open();
            SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            DataTable dtSchema = dr.GetSchemaTable();
            DataTable dt = new DataTable();
            // You can also use an ArrayList instead of List<>
            List<DataColumn> listCols = new List<DataColumn>();

            if (dtSchema != null)
            {
                foreach (DataRow drow in dtSchema.Rows)
                {
                    string columnName = System.Convert.ToString(drow["ColumnName"]);
                    DataColumn column = new DataColumn(columnName, (Type)(drow["DataType"]));
                    column.Unique = (bool)drow["IsUnique"];
                    column.AllowDBNull = (bool)drow["AllowDBNull"];
                    column.AutoIncrement = (bool)drow["IsAutoIncrement"];
                    listCols.Add(column);
                    dt.Columns.Add(column);
                }
            }

            // Read rows from DataReader and populate the DataTable
            while (dr.Read())
            {
                DataRow dataRow = dt.NewRow();
                for (int i = 0; i < listCols.Count; i++)
                {
                    dataRow[((DataColumn)listCols[i])] = dr[i];
                }
                dt.Rows.Add(dataRow);
            }
            GridView2.DataSource = dt;
            GridView2.DataBind();
        }
        catch (SqlException ex)
        {
            // handle error
        }
        catch (Exception ex)
        {
            // handle error
        }
        finally
        {
            conn.Close();
        }

    }
The GetSchemaTable() returns a DataTable describing the column metadata of the IDataReader
0
Shyja Abraham15y ago
Input array is longer than the number of columns in this table. this error is displayed? what we do?
0
Om prakash Singh15y ago
I think you are working on windows application. If so then there is no need of using viewstate.

Iterate through all the rows fetch through cmd.execute reader and add the rows in dt12.
"dt12.Rows.Add(dr)"
0
Shyja Abraham15y ago
The name 'ViewState' does not exist in the current context this error is displayed. what will do?
0
Om prakash Singh15y ago
Try This.
DataTable dt21 = new DataTable();
private void textBox6_TextChanged(object sender, EventArgs e)
{
dt21=(DataTable)ViewState["Dt"];
string s = Convert.ToString(textBox6.Text);
string[] values = s.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int x = values.Length;
for(i=0;i{
string sql=//your query
dr=cmd.ExecuteReader();
dt21.Rows.Add(dr)
}
ViewState["Dt"]=dt21;
yourGrid.DataSource=dt21
yourGrid.DataBind();
}
0
Shyja Abraham15y ago
DataTable dt21 = new DataTable();

private void textBox6_TextChanged(object sender, EventArgs e)

     {

string s = Convert.ToString(textBox6.Text);

                string[] values = s.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

                int x = values.Length;

                for(i=0;i

                {

                    cmd.CommandText = "select doid,doloc,itemcode,itemname,partno,unit,doqty,dorate,dodiscount,dovalue from item i inner join do d on i.itemid=d.itemid where dono='" + values[i] + "'and invoiced='0'";

                    dr = cmd.ExecuteReader();

                    dt21.Load(dr);





                                   }

                dogiridview.DataSource = dt21;

                dr.Close();

}

i use this code ,but it is not work properly
0
Om prakash Singh15y ago
Ontextchange event split the string with comma and check the length of array is <=5 .create a new datatable and for each element in array fire the query,add the value in datatable. In last bind the grid with this datatable
0
Zoran Horvat15y ago
Can you please be more specific in your question?

If the question is how to retrieve comma-separated values from the text box, then it would be like this:

string s = "a,b,c,d";
string[] values = s.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

This will create an array containing four distinct strings: "a", "b", "c" and "d".

Zoran
0