Amit Rai
Last Activity: Oct 3 '10, 05:04 AM
Joined: Aug 1 '10
Location:
-
how to use dropdownlist in gridview in asp.net with c#
please give me the full code (.aspx and .cs)files by using ms sql server 2005. this example does not used sqldatasouce method. -
stored procedure to search from a table with several condition
suppose there are 3 textboxes and 1 search button.If we click on search button without filling any textfield, then
it display all data from the table.when we fill any field, then search according to the number of fields being filled.
here is the sp
create proc sp_search
@name varchar(10), @city varchar(10),@ad r varchar(10),que ry varchar(100)
as
begin
@query="select *from employee where... -
connection life
In my .net program, whenever the Query executes the connection is closed automatically.
how to make it always alive. -
how to get data from two table
let us suppose there are two tables namely 'employee' and 'department'. In employee table columns are emp_id PK and emp_name.In department table columns are dep_id as FK(emp_id),sala ry,month; here one id contain multiple months salary.
Now,
we have to find out the name,salary of the TOP 3 employee whose salary is maximum in his all months salary. -
Error Must declare the scalar variable "@Dn".? in SQL Server 2005
...Code:/* Create a table */ Create table Department (vDepartmentName char(25),vDepartmentHead char(25)) /* Create two variables that would store the values returned by the fetch statement */ DECLARE @DepartmentName char(25) DECLARE @DepartmentHead char(25) /* Define the cursor that can be used to access the records of the table,row by row */ DECLARE curDepartment cursor for SELECT
No activity results to display