Can anybody give me the code of c#.net in which i can send the different icons (i.e. smiley,cry,etc..) Thanks in Advance. Dipan Patel

Dipan Patel.

HI.. u can write the property like visible=False in html window for this. then it will be hide and u can also access the column.. just try this...

Dipan Patel.

i want to send sms in india and whole world.. so i want code for it in .net using vb.net thanx in advance. Dipan Patel.

i want it in vb.net or send me javascript for it becoz i cant find it... Dipan Patel.

how to display the live time in web form. i want to display time continuously.. so help me for code.... Dipan Patel.

hi how r u> asp.net site Dipan Patel.

sir i write the conn.close() in " if dr.read then ...after the dr(0). so not worry about the connection close.. and writing the executescalar in this.. it also gives the same error... i take also only one column name.... Dipan Patel.

-- this is code for connect.vb Imports System.Data.SqlClient Public Class connect Dim str As String Dim conn As New SqlConnection Public ds As DataSet Dim cmd As SqlCommand Public Sub setconnection() str = ConfigurationSettings.AppSettings("connstr") conn.ConnectionString = str End Sub Public Function adpter(ByVal pstr As String) As SqlDataReader Dim s As SqlDataReader conn.Open() cmd = New SqlCommand(pstr, conn) 'cmd.CommandTimeout = 15 s = cmd.ExecuteReader() Return s End Function end class ----- In my "fees.aspx" form Imports System.Data.SqlClient Public Class RegularFees Inherits System.Web.UI.Page Dim Conn As New connect Private Sub SAVE_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SAVE.Click Dim dr As SqlDataReader Dim query as String query = "Select * from ENQUIRY where enquiryformno=2" dr = Conn.adpter(query) If dr.Read Then txtPayment.text=dr(0) End If End Sub End class -------- so u better try it... Dipan Patel.

hello sir, i already this function in 20 webforms... and works successfully... but in one form it not worked.. so there is not way to say that this code is wrong... Dipan Patel.

I tried before it... if any other solution then tell me Dipan Patel.

see Colin Angus Mackay, i wrote the code like --- dim Conn as New connect ' the file named connect.vb dim dr as sqldatareader dim query as string query="select * from enquiry" ' Error occur in below sentence dr=Conn.adpter(query) ' it call adpter(string) if dr.Read then end if --- The code written in adpter() Public Function adpter(ByVal pstr As String) As SqlDataReader dim s as sqlDataReader dim conn as new sqlconnection dim cmd as sqlcommand conn.open() cmd=New sqlcommand(pstr,conn) s=cmd.executereader() return s end function --- This function works properly 100% with other web forms.. but in this form i got the error... so help me.. Dipan Patel.

please write in more detail... Dipan Patel.

The solution is : U created the New User named "AFFORDABLE02" but u dont give the permission.. so give permission. So if u work on sqlserver then click on "AFFORDABLE02" user then click on "Permission" button and select the tables for select,delete,insert,update... your work is done... Now Enjoy... :) Dipan Patel.

Good Question. I just face this problem and find the solution. So i glad to help to anybody. see , when u create the requirefieldvalidatio at design time... set the property of it "EANBLED=FALSE" so when u want to enable it then write the code for it like "requirefieldvalidator1.Enabled=True" and when u want to disable it then set the property "False" i will give one more example there is two button. like " save " and "cancle" so u want "cancle" button cant fire the requirefieldvalidator then set the property of "cancle" like "causevalidation=False" it will work 100% so enjoy.. :) Dipan Patel.

it is because of default page. the code write in web.config when not any page like "default.aspx" then it will give error. so u should create page like default.aspx or redirect the page by writting response.write("anyfile.aspx") Dipan Patel.

you write query like:" UPDATE X SET field=77" so as per your query, Table Name : X Field Name : field so u must understand that "field" must be field name of table X. and datatype with any numeric. try this. Dipan Patel.

error is : Timeout expired. The Timeout period elapsed prior to completion of the operation or the server is not responding.. This error comes when i used the datareader and passed the query . Dipan Patel.