Your database design is not scalable. How do you differentiate between months, or years? Do you only expect this application to be used for one 31 day month, then never again? You should store the date along with the number of hours. CREATE TABLE TimeSheet ( ID INT IDENTITY(1,1) NOT NULL, Date DATETIME NOT NULL, --Or just DATE if using SQL Server 2008 Hours TINYINT NOT NULL ) I know the language. I've read a book. - _Madmatt

I think you must read some tutoials for gridview.Search on google you'll get a lot. Have one below http://msdn.microsoft.com/en-us/library/aa479339.aspx[^] Cheers!! Brij

Thank you for sending the link which helps for getting the basics on windows application. and more over i got solution to my query also. textbox1.Text=command.executescalr().tostring() :)

I don't understand your question then. You know how to use a database, but you don't get that if you want to store the values in your textboxes, you need to write code to store them, and to retrieve the values ? Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

thank you for giving me an idea. i got it :)

There are two DoubleClick events for a cell CellDoubleClick, which you have already used, and CellContentDoubleClick. The DataGridView is very fussy about exactly where you click. If you double-click on the displayed value but are only handling the CellDoubleClick event, nothing happens. Conversely, if you double-click in the cell, but not on the displayed value and you are only handling the CellContentDoubleClick event, nothing happens then either. Set up a handler method for both: private void dataGridView1\_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { MessageBox.Show("Content DoubleClick"); } private void dataGridView1\_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { MessageBox.Show("Cell DoubleClick"); } and experiment with the placement of your double-clicks. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

Is it the bound DataGridView? If yes, then set the Expression property of the Balance column(in the datatable) to sum of credit and debit. If not, then loop through all the rows and set the value in the balance column's cell in the button click event. It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Anjani Poornima wrote: Plz someone post me the code... It is unlikely that you are going to get the entire code here. Have you tried anything? You can handle the CellLeave event of the gridview and set the value in the textbox. Check the column index of the cell and if it is debit/credit and then set the text of textboxes below. It's not necessary to be so stupid, either, but people manage it. - Christian Graus

Handle the CellValidating or CellValidated events of the DataGridView. Look them up on MSDN for examples. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

As an improvement to this, you may want to wrap this javascript into a custom validator and include server side validation also.

Did you struck somewhere ? You said you have added values from the database to dropdownlist. In DropDownList1_SelectedIndexChanged event, you can write code for creating textbox dynamically, bind it with database value and add it to the form. Dim txt As New TextBox() txt.Text = "Sample value from the database" Me.form1.Controls.Add(txt) Make the controls AutoPostBack property as "True". Education is not a way to escape poverty — it is a way of fighting it.

You can use Ajax call to get values for state based on selected country Jyoti

If you know how many cells to be merged then you could use this. But if you dont know how many cells to be merged, for example for an employee, no. of dependents will be differing. So Declare a class global variable and in GridView1_RowDataBound event, try this if (str != e.Row.Cells[2].Text) { str = e.Row.Cells[2].Text; } else { e.Row.Cells[2].Text = ""; } :)

This is my Article. If you have any doubt in Grid related refer this site and vote if you like it. GridView all in one[^] Padmanabhan

for (int i = 0; i < Grid.Rows.Count; i++) { GridViewRow rows = Grid.Rows[i]; bool ischeck = ((Checkbox)rows.FindControl("Checkbox1")).Checked; if (ischeck) { //your update query here } } Padmanabhan modified on Wednesday, May 27, 2009 9:24 AM

Dropdown List containing two property one is "Text" and other is "Value". Now Text field you can use month name and Value field you can use as number value. <asp:DropDownList ID="t" runat="server"> <asp:ListItem Text="Jan" Value="01"></asp:ListItem> </asp:DropDownList> Parwej Ahamad

hi You get query string value like this String str=REquest.querystring("id") Known Is Drop.Unknown Is Ocean

Hi, try this textbox1.text = rdr["fieldname"].tostring(); Hope this one can help. Thanks Hi, Please select Good Question if my answer are fit to your Question.

Asking same question multiple times does not help you get better answer. :) cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net