EmpID

= "INSERT INTO RS_Security VALUES (@EmpID, @Sec_Level)"

ASP.NET Forums mah-skeet 2010

How can I bind data to a textbox control? for ex: on my table i do have Employe table with colum's: EmpID (as primary key), EmpName and EmpAddress. example records on my tables

ASP.NET Forums nergan 2010

So once I finally figured out how to use sql profiler, I ran the page and here's what profiler shows me: mah-skeet: exec sp_executesql N'UPDATE RS_Security SET Sec_Level = @Sec_Level WHERE EmpID =

ASP.NET Forums mah-skeet 2010

Profiler trace still gives me: exec sp_executesql N'UPDATE RS_Security SET Sec_Level = @Sec_Level WHERE EmpID =

ASP.NET Forums mah-skeet 2010

UPDATE RS_Security SET Sec_Level = 2 WHERE EmpID = 5558 in SQL Server Management Studio, it runs fine ... no problems.

ASP.NET Forums mah-skeet 2010

But to get the Department Details for the Department the Employee is in, I had to get the Department Name for the Employee from a second table from which I could only get data if I provided the EmpID for the Employee - which I could only get from a third table using EmpName:

ASP.NET Forums 2009

Enter the first row (Note that EmpID of 1 has already been populated for you by the autonumber).

MSDN Blogs 2009

When I run this query through the table adapter and give it values (I leave EmpID blank), it will successfully insert a row into the database.

ASP.NET Forums 2009

As select EmpID, EmpName, Email, ProductID, ProductName, ProductDesc, ImageID, ImageURL from EmployeeTable emp left outer join ProductTable pt on emp. empid = pt. empid left outer join ProductImageTable pit on pt. productid = pit.

ASP.NET Forums 2009

= "UPDATE RS_Security SET Sec_Level = @Sec_Level WHERE EmpID = @original_EmpID" mah-skeet

ASP.NET Forums mah-skeet 2010