aish

you can use data reader for this, [code] command = new SqlCommand("SELECT * FROM Member",sqlConnection ); command.CommandType = CommandType.StoredProcedure; try { sqlConnection.Open(); reader=command.ExecuteReader(); while (reader.Read()) { [COLOR=DarkGreen]//if it is a text box [/COLOR] txtbox_user.Text=reader.IsDBNull(reader.GetOrdinal("MemberUserName"))? null: reader["MemberUserName"].ToString(); [COLOR=DarkGreen]//if it is a dropdown put defalut value 0 or 1, what ever value …

using the javascript how can I get web server time and date? :eek:

I have a asp.net c# web form, when the page load I want to display client computer date and time.I used DateTime.Now.Date() for this. it works well in the localhost, but after I deployed in the web server it displays web server date and time.how can I display client's computer …

you can do it like this. [LIST=1] [*]read email using streamreader,capture information and pass to next page. [/LIST]

I fill dropdown lists values from the database then I wants to hard code first value and last value. I already hard code first value it's like this. cboName.Items.Insert(0,new ListItem("----Select----","0")); how can I hard code last value of the dropdown list, I want to add last value as a ----Other----. …

In my asp.net c# web app. I have 10 text feilds. I want to avoid duplicate same value in this text feilds. how I can do this using javascripts. :cry:

I'm working on asp.net c# web app. in my form I have Text Area and button. when I click the button I want to remove selected text from the text area (not all text only selected text.) how can I do this? can I use javascript for that if so …

I used this code for validate text box when user paste values to the text box. [code] //Browser Detection var strUserAgent = navigator.userAgent.toLowerCase(); var isIE = strUserAgent.indexOf("msie") > -1; var isNS6 = strUserAgent.indexOf("netscape6") > -1; var isNS4 = !isIE && !isNS6 && parseFloat(navigator.appVersion) < 5; function Paste(objEvent) { var objInput; …

I'm working with sql servre database I have two tables in the same database. thse are my tables, [code] CREATE TABLE [dbo].[Applicant] ( [UserID] [int] IDENTITY (1, 1) NOT NULL , [UserName] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails2] [varchar] (50) COLLATE Latin1_General_CI_AS …

Hi, I have a database table which has a Field called birthday.I want to write SQL script which automatically search database every day and if someones birthday equal today then display a reminder(alert).how can I do this? can anyone help me? Thanks, aish. :o

I have asp.net C# web application I want to search jobvacancy details using jobrole. if user did not select any value I want to select all the details including null values. this Jobvacancy table has JobRole feild and it allow to insert null values, this is my stored procedure [Code] …

I want to insert datetime into the database.I want to insert date as a dd/MMMM/yyyy format SqlDateTime x; if((TextBox1.Text).Length==0) { x=SqlDateTime.Null; } else { x=DateTime.Parse(TextBox1.Text); } command=sqlConnection.CreateCommand(); command.CommandText="insert into Table2 values('"+x+"')"; sqlConnection.Open(); command.ExecuteNonQuery(); Response.Write("Save"); when I add this type of dates ex.25/02/2005 it occur error, how can I solve this.

I have asp.net C# web app. it has country dropdownlist.when the page load I want to select current users country. how can I do this? :rolleyes:

How can I add one hour to current time using javascript? :twisted:

useing this code I avoid to paste invalid chracters to textboxes. function PasteAlphaNumeric(objEvent) { var strPasteData = window.clipboardData.getData("Text"); var objInput = objEvent.srcElement; if (strPasteData.search("[^A-Za-z0-9]")!=-1) { alert("The character you attempted to paste is not allowed for this field."); objInput.focus(); return false; } } I want to allow to paste white space …