Multiple values

Question

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?

Om prakash Singh · Answer

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 { 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

Shyja Abraham · Answer

Input array is longer than the number of columns in this table. this error is displayed? what we do?

Om prakash Singh · Answer

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)"

Shyja Abraham · Answer

The name 'ViewState' does not exist in the current context this error is displayed. what will do?

Om prakash Singh · Answer

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(); }

Shyja Abraham · Answer

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

Om prakash Singh · Answer

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

Zoran Horvat · Answer

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