How to change dataset column name in ASP.NET C#?

by Evgelen 22. March 2010 23:07

ds.Tables[0].Columns[0].ColumnName = "ColumnName";

Tags: , , ,

ASP.NET | C#

How to create SQL Database Schema for Microsoft membership provider?

by Evgelen 22. March 2010 06:18

In order to create SQL Database Schema for Microsoft membership provider you need to Open Visual Studio Command Prompt and type aspnet_regsql command (as you can see below)

 

Tags: , ,

ASP.NET | SQL | SQL 2005 | SQL 2008

ASP.NET, C# - Convert string to array - Array to DataSet

by Evgelen 13. February 2010 18:17
                const string stringName = "keyword1, keyword2, keyword3";
                string[] arrayName = stringName.Split(',');

                var ds = new DataSet();
                var dt = new DataTable("Table_Name");
                ds.Tables.Add(dt);

                var dc = new DataColumn("Column_Name");
                dt.Columns.Add(dc);

                for (var i = 0; i <= arrayName.Length - 1; i++)
                {
                    var dr = dt.NewRow();
                    dr["Column_Name"] = keyw[i];
                    dt.Rows.Add(dr);
                }

                controlName.DataSource = ds;
                controlName.DataBind();

Tags: , , , , ,

ASP.NET | C# | DataSet | Array

How to see SQL instances installed on the server?

by Evgelen 21. January 2010 20:22

  1. Click "Start" and "Run" or Windows Key + R
  2. Type cmd
  3. Then Go to the root folder of C:\ drive
  4. Type osql -L
  5. The system return the names of all instances installed on your server

Tags: , , ,

SQL | Windows XP | Windows 7

Error: Debugging Failed Because Integrated Windows Authentication Is Not Enabled

by Evgelen 14. January 2010 22:00

Error: Debugging Failed Because Integrated Windows Authentication Is Not Enabled

Authentication of the user requesting debugging could not be done due to an authentication error when attempting to step into a Web application or XML Web service. One cause of this error is that integrated Windows authentication is not enabled. To enable it, perform the following steps. If you have enabled integrated Windows authentication and this error still appears, then it is possible that this error is caused because Digest Authentication for Windows Domain Servers is enabled. In this situation you should consult with your network administrator. To enable integrated Windows authentication

  1. Log onto the Web server using an administrator account.
  2. On the Start menu, click Administrative Tools Control Panel.
  3. In the Administrative Tools window, double-click Internet Information Services.
  4. In the Internet Information Services window, open the Web server node. A Web Sites folder opens beneath the server name.
  5. You can configure authentication for all Web sites or for individual Web sites. To configure authentication for all Web sites, right-click the Web Sites folder and click Properties on the shortcut menu. To configure authentication for an individual Web site, open the Web Sites folder, right-click the individual Web site, and on the shortcut menu, click Properties.
  6. In the Properties dialog box, click the Directory Security tab.
  7. In the Anonymous access and authentication control section, click the Edit button.
  8. In the Authentication Methods dialog box, under Authenticated access, select Integrated Windows authentication.
  9. Click OK to close the Authentication Methods dialog box.
  10. Click OK to close the Properties dialog box.
  11. Close the Internet Information Services window.

Tags: , ,

ASP.NET | C# | JavaScript | SQL | Error

Tag cloud