I will tell clearly my doubt here.When selecting the check box,i've to visible 2 text boxes.For that i need the code.Can any of you give me the code.

Babu

hi all, greetings.I'm using a check box in my application.when checked two text boxes should be visible and the entered details in that text boxes should get saved in database.can anyone give me the source for this.

Babu

Hi All, Greetings.I've to create a class file.Here i've added the coding what i've written.But its showing the error.Can any one tell me is this class correct and how to call in my .cs file. public int AddEmployee(string employeeID,string employeeName,string Designation,string Machinetowork,string dateofbirth,string address,string city,string state,string zip,string phoneNo,string MobileNo,string email) { SqlConnection conn = new SqlConnection(conStr); SqlCommand cmd = new SqlCommand("insert into Employee Values(@EmployeeID,@EmployeeName,@Designation,@MachineToWork,@DateOfBirth,@Address,@City,@State,@Zip,@PhoneNumber,@MobileNumber,@Email)",conn); cmd.Parameters.Add("@EmployeeID",employeeID); cmd.Parameters.Add("@EmployeeName",employeeName); cmd.Parameters.Add("@Designation",Designation); cmd.Parameters.Add("@MachineToWork",Machinetowork); cmd.Parameters.Add("@DateOfBirth",dateofbirth); cmd.Parameters.Add("@Address",address); cmd.Parameters.Add("@City",city); cmd.Parameters.Add("@State",state); cmd.Parameters.Add("@Zip",zip); cmd.Parameters.Add("@PhoneNumber",phoneNo); cmd.Parameters.Add("@MobileNumber",MobileNo); cmd.Parameters.Add("@Email",email); int err=1; conn.Open(); { cmd.ExecuteNonQuery(); } conn.Close(); return err; }

Babu

actually it has to be added for everyday work setting.how it will be possible.can you tell me clearly.

Babu

Hi all, Greetings.I have a doubt.in my application i need to add the intervel time for working hours calculation. for example the work ends at 9 pm.if i add a new work it has to be added with time 9 am.so the 12 hours in between the work has to be add.Can any one help me to solve this problem. thanks in advance

Babu

Hi All, Greetings...i have a doubt...i've to separate date and time in sql table..its displaying both date and time...can any one tell me the query for that... Thanks in Advance

Babu

Hi All, greetings.In my appilcation i need to take two different data that is EmployeeName from Employee Table and ClientName from Client Table.How i can write it in a single SQL Query. Can any one one give me the query please. Thanks in Advance.

Babu

Hi all, greetings.In my application i've to bound data with a dropdown list with our any data source control.That by coding i've to bound.Here i'm using C#.Can anyone tell me the coding for the binding of data with DDL. Thanks in Advance

Babu

Hi all, Greetings...I'm using range validator for date validation.In that i've channged the Type as 'Date'...but the Maximum Range of the Date is no accessing...can any one tell me how to rectify this...

Babu

Hi All, Greetings.In one of my application i'm using 2 text boxes for displaying date and time respectively.i'm using the following code. DateTime dat = DateTime.Now; txtBookDate.Text = dat.Date.ToString(); txtBookTime.Text = dat.TimeOfDay.ToString(); But the DATE TEXT BOX displying the o/p as 07/12/2006 12:00:00 AM.But i need to display only the date.Can any one help me to correst it.I've tried with some keywords.So reply me ASAP. Reagrds Babu

Babu

hi all, greetings.I have a doubt regarding the creation and execution of stored procedures.Can any one tell me how to create a stored procedure in MS Access database and how to execute it? Thanks in advance. Babu

Hi ALl, Geetings...can anyone help me regarding the Object Data Source control used in asp.net 2.0 Babu

Hi All, Greetings.Can any one tell me clear about what is session and what is the difference between session and cookies? Thanks in advance Babu

SELECT [CustCode], [Name], [Addr], [Area] FROM [Customer] WHERE (([CustCode] = @CustCode) OR ([Area] = @Area)) i'm using the above code in a sqldatasource,which i've connected with a gridview.the above query is executing while testing in the tool(sqldatasource).but at the time of running application it is not working.i've to disply details in the gridview when clicking a button. can anyone help me to get the solution. Babu

SELECT [CustCode], [Name], [Addr], [OrdType], [Area], [Lob] FROM [Customer] WHERE (([CustCode] = @CustCode) OR ([Country] = @Country)) i was using dis query for another table access.but its not working. Babu

hi, i've applied this query for another table too.that is for customers.even for that it was not working. can you give me the sql statement using OR Condition.will it work. Actually in sqldatasource there is no need to write coding manually.just in configuration mode we can create with the option "Where" button. Babu

select [StudentID],[Name],[Percentage] from tblstudent WHERE (StudentID = @StudentID AND Name=@Name AND Percentage=@Percentage) this was the statement in the sqldatasource tool. Babu

Hi all, i'm using a datagrid with a sqldatasource.in that i'm using where clause with 2 parameters student ID and name.but the select statement is not working when there is both ID and name is present.But its working and display the data with the ID only.Can any one give me the solutions for this? Babu

Hi all, greetings.can any one give me the coding for searcha customer details in a web page by giving any of the details of a customer like customer id,or city,or country, like that.since i'm new new to C# kindly any one tell me the coding for the mentioned above in C#. Babu

:)Hi all, Greetings.i need a help in sqldatasource configuration in asp.net. i'm using multiple drop down list in a project.for that i've to bound data from three different tables in a database using a single sqldatasource.how can i do this.looking for faster reply. Thanks & Regards Babu