Correct SQL statement
Change this line:
DBCmd = New Data.SqlClient.SqlCommand("DELETE FROM family WHERE firstname = '" & TextBox2.Text & "' AND ID = '(ListBox1.SelectedValue.ToString)'", DBConn)
To
DBCmd = New Data.SqlClient.SqlCommand("DELETE FROM family WHERE firstname = '" &...
View 'Management' of Enterprise Manager. On selecting 'Jobs', look under Status column in right side pan.This shows current status of any scheduled job.
Try using T-SQL 'CONVERT' functions. 'CONVERT' function has three arguments. First argument specifies varchar(10) data type for returned value. Second argument is field/value to operated. Last argument defines 'MM/DD/YYYY' date formatting for returned value.
Your sql is re-written...
Radhakrishnan,
Dynamically adding/changing web reference is bit complex. See this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch10.asp
I hope this will help solve your problem.
Large data communication over Network or internet or intranet has been issue in most of the organizations. Some big organizations regularly improve their network infrastructure but not all of businesses willing to do so.
Whereas more efforts on improving internet speed is seen common and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.