How can i create Barcode for coupon???

In one of our pages we are using this bit of code to check if something is null and passing in a 0 instead. This works great for this page, but this was done by another person and thye are no longer here.. so i'd like to take that idea and create something similar but return a empty string or blank space, the reason is that i have a page where you make a selection from a gridview and onselect that rows data is passed into some textboxes.. well at the moment, if you select a row and one of the columns is blank, the textbox is being populated anyway with this   so i would like to make sure that if there is nothing, that the textboxes are left blank.. since there is potential for having alot of textboxes, i would rather create a method that can do the checking instead of doing if condition for each parameter. does that make sense? If so any suggestions would be great. and thanks you

        //CONVERTS NULL VALUES TO ZERO
        protected string valid(OleDbDataReader myreader, int stval)
        {
            object val = myreader[stval];
            if (val != DBNull.Value)
                return val.ToString();
            else
                return Convert.ToString(0);
        }
        //END

I've figured out how to create the controls in the format I want, but now I am confused as to how create more than one set of them. I set everything to new and increment the names of each control, but it's only updating the one set. Here is my code:

  intPnlCounter += CInt(ViewState("intPgCount"))
        
        'Table
        'PlaceHolder1.Controls.Add(New LiteralControl(" <table style=""height: 27px""><tr><td colspan=""2""> </td><td colspan=""2"">"))
        PlaceHolder1.Controls.Add(New LiteralControl("<table style=""height: 27px"">"))

        'Component Header
        Dim lblHeader As Label = New Label
        lblHeader.Text = "Additional Component Item: " & intPnlCounter
        lblHeader.ID = "lblHeader" & intPnlCounter
        lblHeader.Font.Bold = True
        lblHeader.Font.Underline = True
        lblHeader.Font.Name = "Trebuchet MS"
        PlaceHolder1.Controls.Add(lblHeader)
        PlaceHolder1.Controls.Add(New LiteralControl("<tr><td colspan=""2""> </td><td colspan=""2"">"))

        'Item Label
        Dim lblItem As Label = New Label
        lblItem.Text = "Item:"
        lblItem.ID = "lblItem" & intPnlCounter
        lblItem.Font.Bold = True
        lblItem.Font.Underline = True
        lblItem.Font.Name = "Trebuchet MS"
        'lblItem.Font.Size = Unit.Percentage(10)
        PlaceHolder1.Controls.Add(lblItem)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'Item Textbox
        Dim txtItem As TextBox = New TextBox
        txtItem.ID = "txtItem" & intPnlCounter
        txtItem.Width = Unit.Pixel(306)
        PlaceHolder1.Controls.Add(txtItem)
        PlaceHolder1.Controls.Add(New LiteralControl("</td><td> </td></tr><tr><td class=""style11"">"))

        'NSN Label
        Dim lblNSN As Label = New Label
        lblNSN.Text = "NSN:"
        lblNSN.ID = "lblNSN" & intPnlCounter
        lblNSN.Font.Bold = True
        lblNSN.Font.Underline = True
        lblNSN.Font.Name = "Trebuchet MS"
        lblNSN.Font.Size = 10
        PlaceHolder1.Controls.Add(lblNSN)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'NSN Textbox
        Dim txtNSN As TextBox = New TextBox
        txtNSN.ID = "txtNSN" & intPnlCounter
        PlaceHolder1.Controls.Add(txtNSN)
        PlaceHolder1.Controls.Add(New LiteralControl("</td><td class=""style12"">"))

        'PartNum Label
        Dim lblPartNum As Label = New Label
        lblPartNum.Text = "Part Number:"
        lblPartNum.ID = "lblPartNum" & intPnlCounter
        lblPartNum.Font.Bold = True
        lblPartNum.Font.Underline = True
        lblPartNum.Font.Name = "Trebuchet MS"
        lblPartNum.Font.Size = 10
        PlaceHolder1.Controls.Add(lblPartNum)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'PartNum Textbox
        Dim txtPartNum As TextBox = New TextBox
        txtPartNum.ID = "txtPartNum" & intPnlCounter
        PlaceHolder1.Controls.Add(txtPartNum)
        PlaceHolder1.Controls.Add(New LiteralControl("</td><td colspan=""2"">"))

        'SerialNum Label
        Dim lblSerialNum As Label = New Label
        lblSerialNum.Text = "Serial Number:"
        lblSerialNum.ID = "lblSerialNum" & intPnlCounter
        lblSerialNum.Font.Bold = True
        lblSerialNum.Font.Underline = True
        lblSerialNum.Font.Name = "Trebuchet MS"
        lblSerialNum.Font.Size = 10
        PlaceHolder1.Controls.Add(lblSerialNum)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'SerialNum Textbox
        Dim txtSerialNum As TextBox = New TextBox
        txtSerialNum.ID = "txtSerialNum" & intPnlCounter
        PlaceHolder1.Controls.Add(txtSerialNum)
        PlaceHolder1.Controls.Add(New LiteralControl("</td><td>"))

        'Hours Label
        Dim lblHours As Label = New Label
        lblHours.Text = "Hours:"
        lblHours.ID = "lblHours" & intPnlCounter
        lblHours.Font.Bold = True
        lblHours.Font.Underline = True
        lblHours.Font.Name = "Trebuchet MS"
        lblHours.Font.Size = 10
        PlaceHolder1.Controls.Add(lblHours)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'Hours Textbox
        Dim txtHours  

                          

I have some global variables declared and want to access them in subrorutines using the For statement. 

For example, I want to use the following to place values in the global variables , i.e, dblcell1, dblcell2, dblcell3, etc. 

Dim m As Integer
			For m = 3 To 11
				If e.Row.Cells(m).Text <> " " Then
					dblCell & m = e.row.cells(m).text)

				End If
			Next

I know that I can't use the "dblCell & M".  It is just to show the objective. It is where I get an error.

Thanks
 

Hard to describe be here goes.

Currently I have this in the aspx page

<% = new BuildFormField() { FieldName = "FirstName" }%>

And the simplified object

Class BuildFormField(){

   return GetFieldAttributes("FirstName") //calls a linq query based on the field name to get all the attributes of the field ie size/class and builds the html string.

}

The problem is, I will have many of these and it queries the database every time. What I would like to do is build a general dataset once and query that result set for each field.

I can't figure out where I should setup the initial query. Obviously don't want to put it in the aspx page or the controller and I can't figure out how to create a class that would only get called once that I could use again inside the BuildFormField Class.

Hope that makes sense. Yea, a bit unusual of a way to create form fields, but there is good reasons.

Thanks ahead of time.

Hello,

When I click on execution of asp.net application, when loading of page on browser, I get following exception error message:

"Failed to create AppDomain"

despite search results via google on this following steps dealing with renaming of security.config or doing  caspol -reset didn't work:

http://forums.asp.net/t/1304604.aspx

http://mtaulty.com/CommunityServer/blogs/mike_taultys_blog/archive/2005/03/16/5345.aspx

Is there any other idea how to fix this? I can't help this, I've googled enough.

I previously had Visual Studio 2008 installed. Now I have Visual Studio 2010 besides Visual Web Developer express 2010 installed. Can this be problem? I don't know at all what to do.

Thank for your answers.

I'm using VS2010 and I'm trying to follow along with these videos: http://www.asp.net/general/videos and the guy in the video is using Visual Web Developer Express and when he creates a new website it's all nice and simple with a bare bones Default webpage and that's cool. Well, me in my Visual Studio 2010 when I create a new project I get this elaborate "My ASP.NET Application" page with an About page and a Login page and CSS and Jquery and it's just too, too much. Now, of course I could just create an empty ASP.NET application, but that goes too far the other way; I have to start from scratch and add the default page myself and try to reproduce exactly what the code in the video looks like and I can't really see the screen that well. Is there any way I could change my default template to what the gentleman in the video uses?

I have a table

CREATE TABLE [dbo].[Employee_Refrences](
 [Ref_Id] [int] NOT NULL,
 [Name] [varchar](50) NOT NULL,
 [Company_Name] [varchar](50) NULL,
 [Designation] [varchar](50) NOT NULL,
 [Eamil_Id] [varchar](50) NOT NULL,
 [Remark] [varchar](max) NULL,
 CONSTRAINT [PK_Emp_Refrences] PRIMARY KEY CLUSTERED
(
 [Ref_Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

I want create a stored procedure for insert values for Name,Company_Name,Designation,Eamil_Id,Remark then Ref_Id should automically get the value if insert in remain feilds like Name,Company_Name,Designation,Eamil_Id,Remark with out changing table structure

1. A Text box between the date <Name_of_Employee></Name_of_Employee>

2.A.DropDownList  between the date

<Designation_Departments>
        <Designation_Department>Data_Operator</Designation_Department>
      </Designation_Departments>

3.

4. A Grid Between The Date

<Leave_Details>
      <Leave_Records>
        <Leave_Record>
          <Type>CL</Type>
          <Can_Aval>2</Can_Aval>
          <Availed>1</Availed>

          <Balances>8</Balances>
        </Leave_Record>
        <Leave_Record>
          <Type>SL</Type>
          <Can_Aval>7</Can_Aval>
          <Availed>5</Availed>
          <Balances>3</Balances>

        </Leave_Record>
        <Leave_Record>
          <Type>EL</Type>
          <Can_Aval>5</Can_Aval>
          <Availed>2</Availed>
          <Balances>3</Balances>
        </Leave_Record>

      </Leave_Records>

4 a option button between the data

<Designation_Departments2>
        <Designation_Department3>Data_Operator</Designation_Department3>

<Designation_Department2>Data_Operator</Designation_Department2>
      </Designation_Departments2>

<Data>
  <Data>
    <Leave_Application>
      <To_The>
        <Date>2010-11-16</Date>
      </To_The>
      <Name>
        <Name_of_Employee>Ravindra Sharma</Name_of_Employee>

        <Mobile>09711088834</Mobile>
        <Email>sharma.ravi577@gmail.com</Email>
      </Name>
      <Designation_Departments>
        <Designation_Department>Data_Operator</Designation_Department>
      </Designation_Departments>
      <Leave>

        <Leave_Requird>2</Leave_Requird>
        <From>2010-11-17</From>
        <To>2010-11-19</To>
      </Leave>
      <Total_Days>
        <Total_Day>2</Total_Day>
      </Total_Days>

    </Leave_Application>
    <Leave_Details>
      <Leave_Records>
        <Leave_Record>
          <Type>CL</Type>
          <Can_Aval>2</Can_Aval>
          <Availed>1</Availed>

          <Balances>8</Balances>
        </Leave_Record>
        <Leave_Record>
          <Type>SL</Type>
          <Can_Aval>7</Can_Aval>
          <Availed>5</Availed>
          <Balances>3</Balances>

        </Leave_Record>
        <Leave_Record>
          <Type>EL</Type>
          <Can_Aval>5</Can_Aval>
          <Availed>2</Availed>
          <Balances>3</Balances>
        </Leave_Record>

      </Leave_Records>
      <Reason>
        <Reason_For_Leave>Due to some personal reason</Reason_For_Leave>
      </Reason>
      <Signatures>
        <Signature_of_Employee>Ravindra Sharma</Signature_of_Employee>
        <Date>2010-11-16</Date>

      </Signatures>
      <Add_Remarks>
        <Remark>asdf ;l 

                          

Hi,

i have the following code:

        string myConnectionString = "Data Source=xxx.xxx.com; database=example; uid=example; pwd=xxxx; connection timeout = 10";
        SqlConnection myConnection = new SqlConnection(myConnectionString);
        myConnection.Open();
            string myInsertQuery = "SELECT * FROM aspnet_Users";        
            SqlCommand myCommand = new SqlCommand(myInsertQuery, myConnection);
            //myCommand.ExecuteNonQuery();
            GridView1.DataSource = myCommand.ExecuteReader();
            GridView1.DataBind();
        myCommand.Connection.Close();

Example of class Connection.cs:

public void Connect()
    {
        string myConnectionString = "Data Source=xxx.xxx.com; database=example; uid=example; pwd=xxxx; connection timeout = 10";
SqlConnection myConnection = new SqlConnection(myConnectionString);
 myConnection.Open();
    }

I was trying to implement as above.
How can i call this class from the code behind of my page, and call the methods Open and Close connection ?
How do i instantiate the object ?