create a method similar to this

Posted: Dec/14/2010 By: nikhil Points:15 Category: .NET - ASP.Net Views:107 Vote Up (0) Vote Down (0)

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

View Complete Post

Comments:

Be the first to comment this post.

Post Comment

Please login to post your comment

More Related Resources

Create Navigation in asp.net web application

Create Navigation in asp.net web application. Create Navigation in asp.net

Create more than 1 set of controls in runtime.

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

How can i create Barcode for coupon???

Hi all,

I am creating a web site that provide coupon for it's registered member. I want to set up barcoad for each coupon that the member printed. How can i create barcode and Print them in a html page that is used as my coupon page.

Is anybody can give me solution for that???? Please help me, its argent.

Bye

With regards

Sadequzzaman Monoj

Bangladesh

Using VB, how do I use the For i = 1 to 10 to create a dynamic double variable

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

Trying to create a data set that I can reuse

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.

webservice method not hitted for autocomplete

hi all,

i tried to implement autocomplete option for a textbox and it's not working.

i setted a breakpoint on webservice method but it seems it's not reached when start typing on textbox

any ideas?

some code:

WebService:

using System;
using System.Linq;
using System.Web.Script.Services;
using System.Web.Services;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
[System.Web.Script.Services.ScriptService]
public class WebService1 : System.Web.Services.WebService
{
    [ScriptMethod]
    [WebMethod]
    public string[] getname(string prefixText)
    {
        //Test Code
        return Enumerable.Range(Convert.ToInt32(prefixText), 10).Select(a => a.ToString()).ToArray();
    }
}

Markup:

<%@ Register Assembly="AjaxControlToolkit" TagPrefix="cc1" Namespace="AjaxControlToolkit" %>

<asp:ScriptManager ID="ScriptManager1" runat="server">
    <Services>
        <asp:ServiceReference Path="~/WebService1.asmx" />
    </Services>
</asp:ScriptManager>
<asp:TextBox ID="TextBox5" runat

JQuery Autocomplete Call WCF Service Method

I am trying to use the below code to call a wcf service method for Autocomplete functionality in a TextBox. I have written the following query:

$(document).ready(function () {
            $("#<%= txtCompany.ClientID %>").autocomplete(http://localhost/PieScore/PieScore.Application.Services/EmployeeService.svc/GetTestCompanyList, {
                dataType: 'json',
                parse: function (data) {
                    var items = data.d;
                    var parsed = [];
                    for (var i = 0; i < items.length; i++)
                        parsed[i] = {
                            data: [items[i]],
                            value: items[i],
                            result: [items[i]]
                        };
                    return parsed;
                }
            });
        });

The same query works if I pass a Java Script array variable instead of the wcf service method.

Can someone please help me understand what I am doing wrong in this...

The wcf service method contract is :

[OperationContract]
[WebInvoke(Method = "GET", BodyStyle = WebMessageBodyStyle.WrappedRequest, ResponseFormat = WebMessageFormat.Json)]
string[] GetTestCompanyList(string prefixText, int count);

"Failed to create AppDomain"

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.

Failed to create AppDomain

Can I change the default "ASP.NET Web Application" that appears every time I create a new project?

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?

Webmatrix.Data.Database.Query() method return type

I'm using the Webmatrix.Data.Database.Query method to return a result set in the following form

var myResult = db.Query("Select * from mytable");

How do you cast myResult to get the count of records returned? I'd like to do something like

myResult.Count