You should change the keypreview property to true of form. if it is set to false.

tabControl1.SelectedIndex = 0; textBox.Focus();

-> You can easily set the TabIndex property of Textbox to 0 for focusing. -> At Form OnLoad event, set textbox.focus().

In which type of application, you can use such type of implementation?

- Yes, I am using a single database. - No, Connection is open before the query execution and closes after query execution. Thanks

Thanks for reply, I have already done thats a way which you are suggested. It works perfectally in normal situation but when I login same user in two different system at same time, then the problem occurs. Both the system executes query at same time and retrives the same result from database. Thats the area where problem occurs.

Hi All, In MS SQL 2000, How can I check any row of database has updated or not through update query. My basic problem is that, same user has logged on two different system when they login at same time. I want to restrict the second user for login with same name. Regards

You can see this thread. This is the solution of your problem. http://msdn.microsoft.com/en-us/library/zx4t0t48.aspx[^]

You can pass these values via al[0] and al[1].

Hi all, This is the code, where the problem occurs. SqlDataAdapter da = new SqlDataAdapter("UPDATE CompanyInfo SET CompName='abc' where CompID='" + CompID.Text.Trim() + "'", con); DataSet ds = new DataSet(); da.Fill(ds); int gh = da.Update(ds, "CompanyInfo"); da.Update(ds, "CompanyInfo")- fires an exception ("Update unable to find TableMapping['CompanyInfo'] or DataTable 'CompanyInfo'."). Please suggest the idea. Thanks and Regards

modified on Saturday, January 31, 2009 3:23 AM

This is my code, where the problem occurs. SqlDataAdapter da = new SqlDataAdapter("UPDATE CompanyInfo SET CompName='abc' where CompID='" + CompID.Text.Trim() + "'", con); DataSet ds = new DataSet(); da.Fill(ds); int gh = da.Update(ds, "CompanyInfo"); Exception fires on that code is ("Update unable to find TableMapping['CompanyInfo'] or DataTable 'CompanyInfo'."). Please suggest for the wrong code. Thanks and Regards

Thanks for your reply but I can not understand how to use this. I am using given refrence link but it fires an exception (Update unable to find TableMapping['Table'] or DataTable 'Table'.).

Thanks for your reply but it can't work or I can not understand how to use this. Please describe with a little example. It fires an exception (Update unable to find TableMapping['Table'] or DataTable 'Table'.).

Hi all, I am trying to update a row through update query using SqlDataAdapter and DataSet. How can I know, this update query has made any changes in any row or not? Thanks and Regards.

Hello, How to set background image of button or make it transparent in asp.net? Is it possible? Thanks

modified on Monday, December 22, 2008 12:43 AM

Thank you very much. This works.

Could you please explain? What is the problem in this create procedure QueryString. "CREATE PROCEDURE test.dbo.Operator @MasterField varchar(300) AS SELECT SubOperatorField FROM SubOperatorInfo WHERE MasterField=@MasterField AND departField IS NOT NULL AND SubOperatorField=somevalue"; this querystring fires an exception i.e.:- 'CREATE PROCEDURE' does not allow specifying the database name as a prefix to the object name. Must declare the variable '@MasterField'.

Then, what i do? Can i take backup of that and the giving it for restore.

Hi Navaneeth, Because of requirement, I need to create tables and stored procedures at runtime. This is created at runtime because it is managed on clients system or database server during installation of application. Thanks for reply.

Hello, How to create stored procedure dynamically in c#.net. Because some of my requirements needs such a situation. Please help with some example code. Thanks and Regards