Taking input

maher's Avatar, Join Date: Sep 2010
Light Poster
HEY im trying to take input from textbox and then i want to run a query in query in want to search that value
suppose my textbox name is txtInput.text
n query which i want to run


Code:
string connectionString = "Data Source =USER-PC\\SQLEXPRESS1;Initial Catalog=inFlowInventory; Integrated Security=SSPI";
            using (SqlConnection testConnection = new SqlConnection(connectionString))
            {
                SqlCommand testCommand =
                    new SqlCommand("SELECT customer FROM Customer where customer =txtInput.Text", testConnection);
                
                testConnection.Open();
                SqlDataReader sqlDr =testCommand.ExecuteReader(CommandBehavior.CloseConnection);
                if (sqlDr.HasRows)
                {
                    foreach (DbDataRecord rec in sqlDr)
                    {
                        dbRecordHolder.Add(rec);
                       
                    }
                }
                CustomerNameGrid.DataSource = dbRecordHolder;
              }

Last edited by shabbir; 24Sep2010 at 16:29.. Reason: Code blocks
maher's Avatar, Join Date: Sep 2010
Light Poster
lol
wat happn no1 knw dat?? :P
dotNet Zombie's Avatar, Join Date: Aug 2010
Go4Expert Member
Quote:
Originally Posted by maher View Post
lol
wat happn no1 knw dat?? :P
LOL actually the .Net Zombie was busy with work.
Try setting up Parameters like this..
Code:
 SqlCommand testCommand =new SqlCommand("SELECT customer FROM Customer where customer =@testCust", testConnection);

testCommand.Parameters.AddWithValue("@testCust",txtInput.Text);
maher's Avatar, Join Date: Sep 2010
Light Poster
Can u tel me 1 more thng i want to use Datagrid view as a Input of data n use of some qurey
supose table column are item, descrptn, price, quantity
i want to add 1 more Column which wil do da calculation lyke Total column which wrk iz to calculate da value in Run Tyme price*quantity as Total
how can i perform that during insert query tyme
dotNet Zombie's Avatar, Join Date: Aug 2010
Go4Expert Member
Code:
gridView.Rows[rowIndex].Cells["Calc"].Value=Convert.ToInt32(gridView.Rows[rowIndex].Cells["Price"].Value)*Convert.ToInt32(gridView.Rows[rowIndex].Cells["Quantity"].Value);
to make the calculation on the grid itself, the rowIndex is the variable i made up to represent the selectedIndex of the row. (CurrentRow.Index)

then during query time you can add gridView.Rows[rowIndex].Cells["Calc"].Value as a parameters.

or you can

Code:
int Price=Convert.ToInt32(gridView.Rows[rowIndex].Cells["Price"].Value)
int Quality=Convert.ToInt32(gridView.Rows[rowIndex].Cells["Quantity"].Value);
and add the parameter like this

Code:
SQLCommand insertCommand=new SqlCommand("INSERT INTO tblTable(Total) VALUES(@Total)",sqlConn);
insertCommand.Paramaters.AddWithValue("@Total",Price*Quality);
maher's Avatar, Join Date: Sep 2010
Light Poster
sorry em nt dat much expert can u do it easily or gve me complete codding if u can
maher's Avatar, Join Date: Sep 2010
Light Poster
thr is error showing in rowIndex
dotNet Zombie's Avatar, Join Date: Aug 2010
Go4Expert Member
rowIndex is a local variable which stores the GridView Controls property CurrentRow.Index.


*sorry for taking a while to respond, have been busy*
shabbir like this
maher's Avatar, Join Date: Sep 2010
Light Poster
thnx but can u merge awl thg
n can u do it awl combine wid example
dotNet Zombie's Avatar, Join Date: Aug 2010
Go4Expert Member
Code:
int rowIndex=gridView.CurrentRow.Index;
int Price=Convert.ToInt32(gridView.Rows[rowIndex].Cells["Price"].Value)
int Quality=Convert.ToInt32(gridView.Rows[rowIndex].Cells["Quantity"].Value);

SQLCommand insertCommand=new SqlCommand("INSERT INTO tblTable(Total) VALUES(@Total)",sqlConn);
insertCommand.Paramaters.AddWithValue("@Total",Price*Quality);

insertCommand.Conn.Open();
insertCommand.ExecuteNonReader();
insertCommand.Conn.Close();
maher, shabbir likes this