ASP.NET AJAX SQL JQUERY

Reset SQL Identity Seed Using Identity Increment

Apr21
2011 Leave a Comment Written by Conners

Reset SQL Identity Seed Using Identity Increment Back To 1 within Identity Specification

To reset the Identity Seed in MS SQL do the following within Microsoft SQL Server Management Studio:

1) Right Click the database that contains your table identity to reset

2) Click New Query

3) Within the query window enter the following line

DBCC CHECKIDENT(TableToReseed,RESEED,0)

4) Right click the query window

5) Click Execute

That’s all there is to it. I normally use this after testing to reset the database for live production.

Posted in MS SQL - Tagged , , , , , , , ,

The specified DSN contains an architecture mismatch between the Driver and Application

Apr12
2011 Leave a Comment Written by Conners


The specified DSN contains an architecture mismatch between the Driver and Application

I was transferring our company websites from IIS6 to IIS7 servers today and came up against this DSN mismatch problem.

(From IIS7)

System.Data.Odbc.OdbcException: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

To cut a long story short, the IIS7 website was looking for a 64 bit DSN version of the requested driver. The required 64 bit driver was Pervasive ODBC (of which we only had a 32 bit driver!)

My company was not going to pay to upgrade from a 32 bit to 64 bit driver. Therefore, simply setting up a 64 bit dsn was a non starter.

I had to make the website in IIS7 a 32 bit application to read the working 32 bit Pervasive ODBC driver already installed!

How to correct the problem (all in IIS7):

1) Create a new application pool

2) Name it 32BitWeb

3) Use the .NET Framework v2.0.50727

4) Pipeline Mode Classic

5) Enable 32-Bit Applications TRUE

6) Identity Network Service

7) Load User Profile False

8) Attach your website to Application Pool 32BitWeb

MOST IMPORTANTLY

9) Go into Handler Mappings and open up (Inherited) AboMapperCustom-5548907

10) Change the Executable address from:

C:\Windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll

to

C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

11) Click ‘Yes’ to Edit Wildcard Script Map

That’s all there is to it. I simply told the website handler mappings to use 32bit drivers instead of 64bit.

Posted in IIS7, Internet Information Services - Tagged , , , , , ,

How to find an existing control within a masterpage or webpage in asp.net

Apr04
2011 Leave a Comment Written by Conners

One of the first challenges I ever encountered with asp.net was the ability to find an existing control within a webpage, For example, how would I find a label, text box, panel etc.

Default.aspx

 <html xmlns=”http://www.w3.org/1999/xhtml” >
  <head runat=”server”>
      <title>Find Label Control</title>
  </head>
 <body>
      <form id=”form1″ runat=”server”>
       <div>
 
       <asp:Label ID=”lblTest” runat=”server” Text=”Before” /><br /><br />
   
       <asp:Button ID=”btnTest” runat=”server” Text=”Test” onclick=”btnTest_Click” />
   
       </div>
      </form>
 </body>
 </html>

Code Behind

 protected void btnTest_Click(object sender, EventArgs e)
 {
      lblTest.Text = “After”;
 }

This works perfect, but what if we wanted to find a label in the masterpage?

The answer is as follows…

Site.Master

 <html xmlns=”http://www.w3.org/1999/xhtml” >
 <head runat=”server”>
      <title>Find Label Control Recursively</title>
       <asp:ContentPlaceHolder ID=”head” runat=”server”>
       </asp:ContentPlaceHolder>
 </head>
 <body>
      <form id=”form1″ runat=”server”>
      <div>
   
      <asp:Label ID=”test2″ runat=”server” Text=”Morning” />
   
          <asp:ContentPlaceHolder ID=”ContentPlaceHolder1″ runat=”server”>
       
          </asp:ContentPlaceHolder>
      </div>
      </form>
 </body>
 </html>

WebForm1.aspx.cs
 protected void Page_Load(object sender, EventArgs e)
        {
            /* Will Get Error if using masterpage
            Label myLabel = (Label)FindControl(“test2″);
            myLabel.Text = “Evening”;
             */

     // This will work!
            Label myLabel2 = (Label)FindControlRecursive(“test2″);
            myLabel2.Text = “Evening”;
        }

        protected virtual Control FindControlRecursive(string id)
        {
            return FindControlRecursive(id, this);
        }

        protected virtual Control FindControlRecursive(string id, Control parent)
        {

            // If parent is the control we’re looking for, return it

            if (string.Compare(parent.ID, id, true) == 0)

                return parent;

            // Search through children

            foreach (Control child in parent.Controls)
            {

                Control match = FindControlRecursive(id, child);

                if (match != null)

                    return match;

            }

            // If we reach here then no control with id was found

            return null;
        }

On running the webpage WebForm1.aspx, the label id ‘test2′ text within the masterpage will show as ‘Evening’.

It’s as simple as that! You can find any control using the FindControlRecursive method above including text boxes, labels, panels etc.

ADVANCED

If you wish to reuse the coding in several pages and don’t want to repeat the code, then enter the code in your custom BasePage class within the App_Data Folder.

WebForm2.aspx.cs

    public partial class WebForm2 : BasePage
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Label l = (Label)FindControlRecursive(“test2″);
            l.Text = “I love asp.net!”;
        }
    }

BasePage.cs (within App_Data folder)

using System.Web.UI; // don’t forget to add this namespace!

    public class BasePage : System.Web.UI.Page
    {
       
        protected virtual Control FindControlRecursive(string id)
        {
            return FindControlRecursive(id, this);
        }
       
        protected virtual Control FindControlRecursive(string id, Control parent)
        {
            // If parent is the control we’re looking for, return it

            if (string.Compare(parent.ID, id, true) == 0)

                return parent;

            // Search through children

            foreach (Control child in parent.Controls)
            {

                Control match = FindControlRecursive(id, child);

                if (match != null)

                    return match;

            }

            // If we reach here then no control with id was found

            return null;
        }
    }

Thats all there is to it! If you need any further help on this topic, please leave a comment or email me direct thorugh this site.

Posted in ASP.NET C# - Tagged , , ,