How to highlight your code?

You can highlight (with funny colors) your code by www.formatmycode.com

How to connect to SQL Server from ASP?

How to connect to SQL Server (MSSQL) from ASP.NET (C#)?
How to connect to SQL Server from ASP.NET (C#)?
How to connect to SQL Server from ASP.NET?

// Main Code

1 string connectionString = "Data Source=DatabaseSERVER\SQLEXPRESS;Initial
Catalog=DatabaseName;Persist Security
Info=True;User ID=yourUserName;Password=yourPassword"

2 
3 db myDatabaseObject = new db(connectionString);
4 
5 DataSet myDataSet = new DataSet();
6 
7 myDatabaseObject.GetDbData("SELECT * FROM TableName", myDataSet);

// Create a class named db including code below

 1 using System;
 2 using System.Data;
 3 using System.Configuration;
 4 using System.Web;
 5 using System.Web.Security;
 6 using System.Web.UI;
 7 using System.Web.UI.HtmlControls;
 8 using System.Web.UI.WebControls;
 9 using System.Web.UI.WebControls.WebParts;
10 using System.Data.SqlClient;
11 using System.Collections;
12 
13 /// <summary>
14 /// Database class includes database operation methods.
15 /// </summary>
16 public class db
17 {
18     SqlConnection connection = null;
19     string query = "";
20     bool dbResult = false;
21     DataSet dataSet = null;
22     string[] tables = { "Table1", "Table2", "Table3", "Table4" };
23     enum dbTables: int
24     {
25         Table1,
26         Table2,
27         Table3,
28         Table4
29     }
30 
31 
32     public db(string connectionString)
33     {
34         connection = new SqlConnection(connectionString);
35         connection.Open();
36     }
37 
38     public SqlConnection Connection
39     {
40         get
41         {
42             return connection;
43         }
44         set
45         {
46             connection = value;
47         }
48     }
49 
50     public void CloseDbConnection()
51     {
52         connection.Close();
53     }
54 
55     public bool GetDbData(string query, ref DataSet ds)
56     {
57         try
58         {
59             SqlCommand cmd = new SqlCommand();
60             cmd.CommandTimeout = 0;
61             cmd.Connection = connection;
62             cmd.CommandText = query;
63             cmd.CommandType = CommandType.Text;
64             using (SqlDataAdapter da = new SqlDataAdapter(cmd))
65             {
66                 ds = new DataSet();
67                 da.Fill(ds);
68                 cmd.Parameters.Clear();
69             }
70             return true;
71         }
72         catch
73         {
74             return false;
75         }
76     }
77 
78     public bool WriteDbData(string query)
79     {
80             try
81             {
82                 SqlCommand addCatCommand = new SqlCommand();
83                 addCatCommand.Connection = connection;
84                 addCatCommand.CommandText = query;
85                 addCatCommand.ExecuteNonQuery();
86                 return true;
87             }
88             catch
89             {
90                 return false;
91             }
92     }
93 }

How to show message box in ASP?

How to show message box in ASP.NET (C#)?
How to show message box in ASP C#?

// C# code

1 Response.Write(<script>alert('Hello')</script>);

How to start process from ASP?

How to start process from ASP.NET (C#)?
How to start process from ASP.NET?
How to start process from ASP?

//C# code

1 Process pr = new Process();
2 pr.StartInfo.FileName = "notepad.exe";
3 pr.Start();

How to use cursors at SQL Server?

How to use cursors at MSSQL?

 1 DECLARE @dummy VARCHAR(50)
 2 DECLARE @myOutput VARCHAR(50)
 3 
 4 DECLARE db_cursor CURSOR FOR
 5 SELECT fieldName
 6 FROM tableName
 7 
 8 OPEN db_cursor
 9 FETCH NEXT FROM db_cursor INTO @dummy
10 
11 WHILE @@FETCH_STATUS = 0
12 BEGIN
13 SET @myOutput = @dummy
14 PRINT @myOutput
15 FETCH NEXT FROM db_cursor INTO @dummy
16 END
17 
18 CLOSE db_cursor
19 DEALLOCATE db_cursor