Web Forms

Difference between Thread, ThreadPool & BackgroundWorker c#

2013-05-18T19:07:51.42-04:00

i many time call method with the help of thread like

static void Main( string[] args )
{
Thread t = new Thread( MyFunction );
t.Start();
}

static void MyFunction()
{
//code goes here
}

and some time i use ThreadPool class also like

System.Threading.ThreadPool.QueueUserWorkItem(delegate {
MyFunction();
}, null);

but i do not understand what is the difference between calling any method with the help of thread class or ThreadPool class

so i am looking a good discussion about what is the difference between Thread & ThreadPool class.also need to know when we should use Thread class to call a method and when ThreadPool class to call any method ? if possible discuss also with sample code with sample situation.

another very important question is that if i start multiple thread then my application performance will become low or bad ? if yes then tell me why...?

now also tell me what is BackgroundWorker class and how it is different from Thread & ThreadPool class. how far i heard that BackgroundWorker class also create a separate thread to run any method. so please discuss how it is different from Thread & ThreadPool class and when one should go for BackgroundWorker class.

here is small sample code of BackgroundWorker

private void button1_Click(object sender, EventArgs e)
{
BackgroundWorker bw = new BackgroundWorker();

// this allows our worker to report progress during work
bw.WorkerReportsProgress = true;

// what to do in the background thread
bw.DoWork += new DoWorkEventHandler(
delegate(object o, DoWorkEventArgs args)
{
BackgroundWorker b = o as BackgroundWorker;

// do some simple processing for 10 seconds
for (int i = 1; i <= 10; i++)
{
// report the progress in percent
b.ReportProgress(i * 10);
Thread.Sleep(1000);
}

});

// what to do when progress changed (update the progress bar for example)
bw.ProgressChanged += new ProgressChangedEventHandler(
delegate(object o, ProgressChangedEventArgs args)
{
label1.Text = string.Format("{0}% Completed", args.ProgressPercentage);
});

// what to do when worker completes its task (notify the user)
bw.RunWorkerCompleted += new RunWorkerCompletedEventHandler(
delegate(object o, RunWorkerCompletedEventArgs args)
{
label1.Text = "Finished!";
});

bw.RunWorkerAsync();
}

error - if (typeof(Sys)) == 'undefined'throw new error

2013-05-18T18:51:29.653-04:00

Hello all,

My latest project is in .net frame work 4.0 and its working fine in my development pc. (I am using ajax controls)

I deployed the working code in production server and it cant load 'the home page even and throwing out the following error.

if (typeof(Sys)) == 'undefined'throw new error ASP.NET Ajax client-side framework failed to load.

pls help me to solve this

thanks

nick

invoke a popup page and still have original page

2013-05-18T06:32:39.177-04:00

after the page is submitted and edits/validations are performed in the postback, if there are errors I want to render up a static page with a list of all the errors, something like a js alert, and have the web form still available to make changes in the state it was when submitted. having the pop up page as a the guide where to correct the errors. when I try this it all executes but there is no page that comes up?

have tried a few variations of the page info but never get the popup page

Dim csname1 As String = "PopupScript"
        Dim url As String = "donateack.aspx"
        Dim cstype As Type = Me.GetType()
        'Dim js As String = "<script>window.open('{0}');"
        Dim js As String = "<script>window.open('myPage.aspx','nameOfWindow','tool bar=0,scrollbars=1,location=0,statusbar=1,menubar= 0,resizable=1,width=500,height=550)"
        js = js & "</" & "script>"
        ClientScript.RegisterStartupScript(cstype, "newWindow", js, False)

sending email in c# adding drag and drop file attachments functionality like yahoo mail

2013-05-18T17:35:04.027-04:00

I want to add drag and drop feature as seen in yahoo mail for attaching files in my contact us page purely in asp.net not in mvc.The attched files should have thumbnail preview and optionally deleting button and progress bar.

Me.Title cannot be set

2013-05-17T17:28:36.767-04:00

Trying to set the title on 1 page in an application with dozens of pages using the following code:

1    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
2        If (Not IsPostBack) Then
3            Me.Title = "This is the page title"
4        End If
5    End Sub

The title is never set, and when I step through the code after line 3 executes Me.Title is equal to an emtpy string!

I have this same code in dozens of pages through the app and it works fine.

Unable to access control from div dynamically

2013-05-17T13:41:02.823-04:00

Hi,

I addedd div server control at the desing time.

<div id="divReqDetails" runat="server">
</div>

And added controls (like dropdownlist) to the div dynamically.

DropDownList ddlCtrl = new DropDownList();
ddlCtrl.ID = "ddlChampion";
divReqDetails.Controls.Add(ddlCtrl);

I could not access dropdownlist from the code behind.

DropDownList ddlChampion1 = (DropDownList)divReqDetails.FindControl("ddlChampion");

Can you please help me? please please ....

Populate dropdown2 based on dropdown1

2013-05-17T14:04:22.987-04:00

Hi,

I am new to asp and trying to populate a dropdownlist2 which is based on the value selected from dropdownlist1.

The problem I am facing is that the primary key for the table linked to dropdownlist1 is an integrity column (which is also the foreign key for table linked to dropdownlist2). Based on this I have tried to create a code (attached). The issue I am facing within the code is related to this part:

if (dt.Rows.Count > 0)

{

ddlsubfunc.DataSource = dt;

ddlsubfunc.DataTextField = "SUB_FUNCTION_NAME";

ddlsubfunc.DataValueField = "SUB_FUNCTION_NAME";

ddlsubfunc.DataBind();

}

Could anybody please know what to change in the above code ?

private void BuilsubfuncList()
        {
            DataTable dt = new DataTable();
            var func_ID = "";
            Label lblsubfuncid = DvsubfuncDetails.FindControl("lblsubfuncid") as Label;
            if (lblsubfuncid != null)
            {
                func_ID = lblsubfuncid.Text;
            }
            using (SqlConnection connection = new SqlConnection(GetConnectionString()))
            {
                string sql = "select Distinct SUB_FUNCTION_NAME from SUB_FUNCTION sf inner join [function] f on sf.function_ID = f.Function_ID where sf.function_ID=@func_ID";
                using (SqlCommand cmd = new SqlCommand(sql, connection))
                {
                    cmd.Parameters.AddWithValue("@func_ID", func_ID);
                    SqlDataAdapter ad = new SqlDataAdapter(cmd);
                    ad.Fill(dt);
                }
            }
            if (dt.Rows.Count > 0)
            {
                ddlsubfunc.DataSource = dt;
                ddlsubfunc.DataTextField =  "SUB_FUNCTION_NAME";
                ddlsubfunc.DataValueField = "SUB_FUNCTION_NAME";
                ddlsubfunc.DataBind();
            }
        }

Is there any way to convert all images saved in session To PDF and download that PDF

2013-05-18T11:03:20.29-04:00

Is there any way to convert all images saved in session To PDF and download that PDF

When client login in website he randomly selects somes images from website which are saved in session ,Is dere any way to convert all images selected by client as PDF n den client click on button its download all images selected as PDF.

Plz suggest

How to use Unicode in ASP.NET web application??

2013-05-17T16:33:50.243-04:00

Hi all,

I am making ASP.NET web application which uses language other than english, that is Hindi(kruti Dev) For ex:-Hindi(Kruti Dev)=रोहित and its unicode conversion=%u0930%u094B%u0939%u093F%u0924 , i want to use this unicode in my entire application, so that it shows only रोहित(from example above) So please can anyone tell me what are settings required in ASP.NET application for unicode ,Also please tell me should i store data as Unicode in database table or as my language[Hindi(Kruti Dev) ].??Please help me

Thanks in advance

Rohit J

Execute a stored procedure after change text in textbox

2013-05-18T12:08:04.643-04:00

Is it possible to change a text in text box calling the stored procedure (update textbox)?

Website Content in local language

2013-05-18T07:37:44.27-04:00

hello

How can i develop a website in local language.

I could write the content but when it displayed in browsers some characters are displayed wrong and space

displayed as a square. How can i solve this issue. Shall I need to use any dll files .

One general example you can see in

http://www.manoramaonline.com

They use something like this

http://www.manoramaonline.com/cgi-bin/MMOnline.dll/portal/ep/home.do?tabId=0

What may be this MMOnline.dll ? any guess? Is it for language support

For this website there is no issue in the content as I mentioned above

This site also deliver the content perfectly

http://www.mathrubhumi.com

Please help

Make Title of the Report above table gridview which is exported to PDF

2013-05-18T10:37:41.053-04:00

Dear All,

I am a beginner, in making the PDF Report.

How do I add a title report in PDF Report, on a table as the report title.

I do Export Gridview to PDF, using a script like this:

Protected Sub btnExport_Click(sender As Object, e As System.EventArgs)
       
        Dim columnsCount As Integer = gv1.HeaderRow.Cells.Count
        Dim pdfTable As New PdfPTable(columnsCount)
        
        
        For Each gridViewHeaderCell As TableCell In gv1.HeaderRow.Cells
            ' Create the Font Object for PDF document
            Dim font As New Font
            ' Set the font color to GridView header row font color
            ' font.Color = New iTextSharp.text.Color(gv1.HeaderStyle.ForeColor)
            
            ' Create the PDF cell, specifying the text and font
            Dim pdfCell As New PdfPCell(New Phrase(gridViewHeaderCell.Text, font))
            
            ' Set the PDF cell backgroundcolor to GridView header row BackgroundColor color
            'pdfCell.BackgroundColor = New BaseColor(GridView1.HeaderStyle.BackColor)
            ' Add the cell to PDF table
            pdfTable.AddCell(pdfCell)
            
        Next
        
        For Each gridViewRow As GridViewRow In gv1.Rows
            If gridViewRow.RowType = DataControlRowType.DataRow Then
                ' Loop thru each cell in GrdiView data row
                For Each gridViewCell As TableCell In gridViewRow.Cells
                    Dim font As New Font()
                    'font.Color = New BaseColor(GridView1.RowStyle.ForeColor)

                    Dim pdfCell As New PdfPCell(New Phrase(gridViewCell.Text, font))

                    ' pdfCell.BackgroundColor = New BaseColor(GridView1.RowStyle.BackColor)

                    pdfTable.AddCell(pdfCell)
                Next
            End If
        Next
        
        ' Create the PDF document specifying page size and margins
        'Dim pdfDocument As New Document(PageSize.A4, 10.0F, 10.0F, 10.0F, 10.0F)
        Dim pdfDocument As New Document(New Rectangle(288.0F, 144.0F), 10, 10, 50, 10)
        
        
        
        
            
        pdfDocument.SetPageSize(iTextSharp.text.PageSize.A4.Rotate())
        
        PdfWriter.GetInstance(pdfDocument, Response.OutputStream)

        pdfDocument.Open()
        pdfDocument.Add(pdfTable)
        pdfDocument.Close
        Response.ContentType = "application/pdf"
        Response.AppendHeader("content-disposition", "attachment;filename=Member.pdf")
        Response.Write(pdfDocument)
        Response.Flush()
        Response.[End]()
    End Sub

Thank you.

How do I show a message after successful insert and also after insert fails?

2012-07-25T14:59:45.823-04:00

I would like to display a message to the user after successful insert into the database. Could someone please help? I have seen many ways to do it but I am still stuck.

Here is my insert code in aspx:

<asp:sqldatasource id="SqlDataSource2" runat="server"
connectionstring="<%$ ConnectionStrings:aid1133ConnectionString3 %>"

insertcommand="INSERT INTO dbo.aspnet_UsersInRoles(UserId, RoleId)
VALUES (@UserId, @RoleId)"
selectcommand="SELECT dbo.aspnet_Roles.RoleName, dbo.aspnet_Users.LastName,
dbo.aspnet_Users.FirstName FROM dbo.aspnet_Roles INNER JOIN dbo.aspnet_Applications
ON dbo.aspnet_Roles.ApplicationId = dbo.aspnet_Applications.ApplicationId
INNER JOIN dbo.aspnet_Users ON dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId
AND dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId
AND dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId
AND dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId
AND dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId
AND dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId">

<insertparameters>
<asp:parameter name="UserId" />
<asp:parameter name="RoleId" />

</insertparameters>

email an application form with image

2013-05-16T11:25:12.79-04:00

hi everyone,

i have an application form in which there is a fileupload for uploading image... it will show in image control.. i want to send the whole contents including image as email like an exam hall ticket...

here is my codes,

aspx code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" EnableEventValidation="false" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>onlineform</title>
<style type="text/css">
.style1
{
width: 100%;
}
.style2
{
width: 219px;
}
.style3
{
width: 346px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

<table class="style1">
<tr>
<td class="style2">
 </td>
<td class="style3">
 </td>
<td>
<asp:Image ID="coverimg" runat="server" Width="142px" />
</td>
</tr>
<tr>
<td class="style2">
Name</td>
<td class="style3">
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td>
<td>
 </td>
</tr>
<tr>
<td class="style2">
Age</td>
<td class="style3">
<asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
</td>
<td>
 </td>
</tr>
<tr>
<td class="style2">
Address</td>
<td class="style3">
<asp:TextBox ID="txtAddress" runat="server" TextMode="MultiLine"></asp:TextBox>
</td>
<td>
 </td>
</tr>
<tr>
<td class="style2">
Image</td>
<td class="style3">
<asp:FileUpload ID="fupload" runat="server" />
<asp:Button ID="btnUpload" runat="server" onclick="btnUpload_Click"
Text="Upload" />
</td>
<td>
 </td>
</tr>
<tr>
<td class="style2">
 </td>
<td class="style3">
<asp:Button ID="btnSubmit" runat="server" Text="Send" />
</td>
<td>
 </td>
</tr>
</table>

</div>
</form>
</body>
</html>

c# code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (fupload.HasFile)
{

string ext = System.IO.Path.GetExtension(fupload.FileName);
if (ext == ".jpeg" || ext == ".jpg" || ext == ".jif" || ext == ".png")
{
string path = txtName.Text + ext;
fupload.SaveAs(MapPath(path));
coverimg.ImageUrl = path;

}
}
}
}

thanks in advance

Any way to completely hide LisBox vertical scroll bar

2013-05-17T14:24:06.29-04:00

Hi,

I've been following advice on hiding a ListBox vertical scroll bar.

I have found same advice in lots places and URL below gives good example of it.

http://stackoverflow.com/questions/468980/asp-net-how-to-hide-listbox-control-vertical-scrollbar

My problem is that though the advice seems to work to stop the actual scroll bar appearing, it does not stop the grey bar at the right of the ListBox, which the scroll bar sits in, appearing. This is still there even though the scroll bar is not.

Does anyone know how to get rid of this grey bar also?

Thank you.

the problem is with time the error of not selecting 6 hrs from now time does not work the user cud select any error no error is shown

2013-05-18T07:40:12.613-04:00

<asp:Panel runat="server" ID="panel2">
<table>
<tr>
<td colspan="4" bgcolor="#FFFFCC" class="tx1" align="center" style="height: 20px">» Special Request Form</td>
</tr>

<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="Trip Scheme"></asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" AppendDataBoundItems="true"
DataSourceID="SqlDataSource1" DataTextField="tripscheme"
DataValueField="stdcharge" onselectedindexchanged="DropDownList2_SelectedIndexChanged"
><asp:ListItem Selected="True" Text="- Select Trip -"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"
SelectCommand="SELECT [tripscheme],[stdcharge] FROM [tripscheme]"></asp:SqlDataSource>
</td>

<td>
<asp:Label ID="Label4" runat="server" Text="Pick Up Date"></asp:Label>
</td>
<td><asp:TextBox ID="datepicker" runat="server" ></asp:TextBox>
</td>

<asp:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="datepicker" OnClientDateSelectionChanged="checkDate">
</asp:CalendarExtender>
</tr>
<tr>
<td>

<asp:Label ID="Label9" runat="server" Text="PickUp time"></asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server">

<asp:ListItem>12:00:00 AM</asp:ListItem>
<asp:ListItem>1:00:00 AM</asp:ListItem>
<asp:ListItem>2:00:00 AM</asp:ListItem>
<asp:ListItem>3:00:00 AM</asp:ListItem>
<asp:ListItem>4:00:00 AM</asp:ListItem>
<asp:ListItem>5:00:00 AM</asp:ListItem>
<asp:ListItem>6:00:00 AM</asp:ListItem>
<asp:ListItem>7:00:00 AM</asp:ListItem>
<asp:ListItem>8:00:00 AM</asp:ListItem>
<asp:ListItem>9:00:00 AM</asp:ListItem>
<asp:ListItem>10:00:00 AM</asp:ListItem>
<asp:ListItem>11:00:00 AM</asp:ListItem>
<asp:ListItem>12:00:00 PM</asp:ListItem>
<asp:ListItem>13:00:00 PM</asp:ListItem>
<asp:ListItem>14:00:00 PM</asp:ListItem>
<asp:ListItem>15:00:00 PM</asp:ListItem>
<asp:ListItem>16:00:00 PM</asp:ListItem>
<asp:ListItem>17:00:00 PM</asp:ListItem>
<asp:ListItem>18:00:00 PM</asp:ListItem>
<asp:ListItem>19:00:00 PM</asp:ListItem>
<asp:ListItem>20:00:00 PM</asp:ListItem>
<asp:ListItem>21:00:00 PM</asp:ListItem>
<asp:ListItem>22:00:00 PM</asp:ListItem>
<asp:ListItem>23:00:00 PM</asp:ListItem>

</asp:DropDownList>

</td>

<asp:CustomValidator ID="CustomValidator1" runat="server" ErrorMessage="Time selected should be 6 hrs greater from now time" ControlToValidate="DropDownList1" OnServerValidate="check"></asp:CustomValidator>

<td>
<asp:Label ID="Label3" runat="server" Text=" Car Type:"></asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="true"

onselectedindexchanged="DropDownList3_SelectedIndexChanged">
<asp:ListItem>select</asp:ListItem>
<asp:ListItem Value="A.C">A.C</asp:ListItem>
<asp:ListItem Value="Non A.C">Non A.C</asp:ListItem>
</asp:DropDownList>

</td>
<td>

<asp:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender1" runat="server" TargetControlID="txtfrom" WatermarkText="enter from address">
</asp:TextBoxWatermarkExtender>
</td>

</tr>
<tr>
<td>
<asp:Label ID="Label5" runat="server" Text="Car Category:"></asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList4" runat="server" AutoPostBack="true"
onselectedindexchanged="DropDownList4_SelectedIndexChanged" >

</asp:DropDownList>

</td>

<td>
<asp:Label ID="Label7" runat="server" Text="From:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtfrom" runat="server" TextMode="SingleLine"></asp:TextBox>

</td>
<td>
<asp:FilteredTextBoxExtender ID="FilteredTextBoxExtender4" runat="server" TargetControlID="txtfrom" FilterType="Numbers, UppercaseLetters, LowercaseLetters">
</asp:FilteredTextBoxExtender>

<asp:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender3" runat="server" TargetControlID="txtfrom" WatermarkText="enter from address">
</asp:TextBoxWatermarkExtender>
</td>

</tr>
<tr>
<td>
<asp:Label ID="Label8" runat="server" Text="To:"></asp:Label>
</td>
<td><asp:TextBox ID="txtto" runat="server" TextMode="SingleLine" ></asp:TextBox>

</td>

<asp:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender4" runat="server" TargetControlID="txtto" WatermarkText="enter dest. address">
</asp:TextBoxWatermarkExtender>

<td>
<asp:Label ID="Label10" runat="server" Text="Notes"></asp:Label>
</td>
<td><asp:TextBox ID="txtnots" runat="server" TextMode="SingleLine"></asp:TextBox>

</td>

</fieldset>
<table>
<tr><td>
<asp:Button ID="Button1" runat="server" Text="Submit Form"
onclick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="Reset" OnClientClick="this.form.reset();return false;"/>
<asp:ConfirmButtonExtender ID="ConfirmButtonExtender1" runat="server" TargetControlID="Button1" ConfirmText="are you sure to submit details??" OnClientCancel="CancelClick">
</asp:ConfirmButtonExtender></td>
</tr>

c# code:

protected void Button1_Click(object sender, EventArgs e)
{
string sql = @"Data Source=SAJITH-PC\SQLEXPRESS;Initial Catalog=myfile1;Integrated Security=True";
string name = txtname.Text;
string dept = txtdept.Text;
string cost = txtcostcode.Text;

string mob = txtmob.Text;
string hodname = txthodname.Text;
string hodmail = txthmail.Text;
string date = datepicker.Text;
string from = txtfrom.Text;
string to = txtto.Text;
string not = txtnots.Text;
string status = TextBox1.Text;
string rate = txtrate.Text;

if (Convert.ToInt32(txtp.Text) % 2 == 0)
{

SqlConnection con = new SqlConnection(sql);
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.Connection = con;
com.CommandText = "Insert into [main] (username,dept,costcode,mobileno,hodusername,hodemail,pickupdate,pickuptime,fromdest,todest,notes,cartype,carcategory,tripscheme,status,rate)" + "values (@username,@dept,@costcode,@mobileno,@hodusername,@hodemail,@pickupdate,@pickuptime,@fromdest,@todest,@notes,@cartype,@carcategory,@tripscheme,@status,@rate)";
com.Parameters.Clear();

com.Parameters.AddWithValue("@username", name);
com.Parameters.AddWithValue("@dept", dept);
com.Parameters.AddWithValue("@costcode", cost);
com.Parameters.AddWithValue("@mobileno", mob);

com.Parameters.AddWithValue("@hodusername", hodname);
com.Parameters.AddWithValue("@hodemail", hodmail);
com.Parameters.AddWithValue("@pickupdate", date);
com.Parameters.AddWithValue("@pickuptime", DropDownList1.SelectedValue);

com.Parameters.AddWithValue("@fromdest", from);
com.Parameters.AddWithValue("@todest", to);
com.Parameters.AddWithValue("@notes", not);
com.Parameters.AddWithValue("@cartype", DropDownList3.SelectedValue);
com.Parameters.AddWithValue("@carcategory",DropDownList4.SelectedValue);
com.Parameters.AddWithValue("@tripscheme",DropDownList2.SelectedValue);
com.Parameters.AddWithValue("@status",status);
com.Parameters.AddWithValue("@rate",rate);

try
{
con.Open();
com.ExecuteNonQuery();
}
catch (SQLException ex)
{ // Log your error
lblstatus.Text = "An error occured" + ex.Message;
throw ex;
}
finally
{
if (con != null)
{
con.Close();
}
}
}

else {

SqlConnection con = new SqlConnection(sql);
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.Connection = con;
com.CommandText = "Insert into [approve] (username,mobileno,dept,costcode,date,time,fromdest,todest,notes,cartype,carcategory,tripscheme,status)" + "values (@username,@mobileno,@dept,@costcode,@date,@time,@fromdest,@todest,@notes,@cartype,@carcategory,@tripscheme,@status)";
com.Parameters.Clear();

com.Parameters.AddWithValue("@username", name);
com.Parameters.AddWithValue("@dept", dept);
com.Parameters.AddWithValue("@costcode", cost);
com.Parameters.AddWithValue("@mobileno", mob);

com.Parameters.AddWithValue("@date", date);
com.Parameters.AddWithValue("@time", DropDownList1.SelectedValue);

com.Parameters.AddWithValue("@fromdest", from);
com.Parameters.AddWithValue("@todest", to);
com.Parameters.AddWithValue("@notes",not);
com.Parameters.AddWithValue("@cartype", DropDownList3.SelectedValue);
com.Parameters.AddWithValue("@carcategory", DropDownList4.SelectedValue);
com.Parameters.AddWithValue("@tripscheme", DropDownList2.SelectedValue);
com.Parameters.AddWithValue("@status",status);
con.Open();
com.ExecuteNonQuery();
con.Close();

}

Response.Redirect("~/USER/appreq.aspx");
}

protected void check(object sender, ServerValidateEventArgs args)
{

DateTime t1 = Convert.ToDateTime(DropDownList1.SelectedValue);
DateTime t2 = Convert.ToDateTime(DateTime.Now.AddHours(6));
int result = DateTime.Compare(t1, t2);
if (result < 0)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}

protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{

if (DropDownList3.SelectedValue== "A.C")
{
bindlist();

}

if (DropDownList3.SelectedValue== "Non A.C")
{
bindanotherlist();
}

}

private void bindlist()
{

string sql = @"Data Source=SAJITH-PC\SQLEXPRESS;Initial Catalog=myfile1;Integrated Security=True";
SqlConnection con = new SqlConnection(sql);
SqlCommand cmd = new SqlCommand("select vehicle,charge from vehicle" ,con);
SqlDataAdapter sa = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sa.Fill(ds);
DropDownList4.DataSource = ds.Tables[0].DefaultView;
DropDownList4.DataTextField = "vehicle";
DropDownList4.DataValueField = "charge";

DropDownList4.DataBind();
DropDownList4.Items.Insert(0, new ListItem("--Select--"));

}

private void bindanotherlist()
{
string sql = @"Data Source=SAJITH-PC\SQLEXPRESS;Initial Catalog=myfile1;Integrated Security=True";
SqlConnection con = new SqlConnection(sql);
SqlCommand cmd = new SqlCommand("select vehicle,charge from nonac", con);
SqlDataAdapter sa = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sa.Fill(ds);
DropDownList4.DataSource = ds.Tables[0].DefaultView;
DropDownList4.DataBind();
DropDownList4.DataTextField = "vehicle";

DropDownList4.DataValueField = "charge";

DropDownList4.Items.Insert(0, new ListItem("--Select--"));

}

protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
txtrate1.Text = DropDownList2.SelectedValue;
}

protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e)
{
int total = Convert.ToInt32(txtrate1.Text) + Convert.ToInt32(DropDownList4.SelectedValue);
txtrate.Text = total.ToString();
}

Erroe:Object reference not set to an instance of an object.

2013-05-18T09:10:37.503-04:00

<asp:UpdatePanel ID="UpdatePanel1" UpdateMode="Conditional" runat="server" >
                        <ContentTemplate>
                           
                            <asp:RadioButtonList ID="RadioButtonList1" runat="server" align="left"
                                RepeatDirection="Horizontal" AutoPostBack="True"
                                onselectedindexchanged="RadioButtonList1_SelectedIndexChanged">
                                <asp:ListItem Selected="True" Value="0">ABCD</asp:ListItem>
                                <asp:ListItem Value="1">123</asp:ListItem>
                            </asp:RadioButtonList>
                            
                        </ContentTemplate>
                        </asp:UpdatePanel>
                          <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional">
                          <ContentTemplate>
                              <asp:Table ID="Table1" runat="server">
                              <asp:TableRow>
                                <asp:TableCell>
                                     <table id="tblclient" runat="server" >
                                  <tr>
                                    <td>
                                        <asp:Label ID="lblclient" runat="server" Text="from ABCD"></asp:Label>
                                    </td>
                                  </tr>
                                </table>
                                </asp:TableCell>
                              </asp:TableRow>
                              <asp:TableRow>
                               <asp:TableCell>
                                  <table id="tblEmployee" runat="server"  >
                                  <tr>
                                    <td>
                                     <asp:Label ID="lblEmp" runat="server" Text="from 123"></asp:Label>
                                    </td>
                                  </tr>
                                </table>
                               </asp:TableCell>
                              </asp:TableRow>
                            </asp:Table>
                          
                             
                             
                         </ContentTemplate>
                         <Triggers>
                          <asp:AsyncPostBackTrigger ControlID="RadioButtonList1" EventName="SelectedIndexChanged" />
                         </Triggers>
                         </asp:UpdatePanel>

C#

protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        System.Web.UI.HtmlControls.HtmlTable tblABCD = (System.Web.UI.HtmlControls.HtmlTable)FindControl("tblABCD");
        System.Web.UI.HtmlControls.HtmlTable tbl123 = (System.Web.UI.HtmlControls.HtmlTable)FindControl("tbl123");
       
        int index = Convert.ToInt32(RadioButtonList1.SelectedIndex);
        if (value == 0)
        {
            tblABCD.Visible = true;
            tbl123.Visible = false;
            UpdatePanel1.Update();
            UpdatePanel2.Update();
        }
        else
        {
            tblABCD.Visible = false;
            tbl123.Visible = true;
            UpdatePanel1.Update();
            UpdatePanel2.Update();
        }
       
    }
}

Hear am getting an runtime exception in line tblABCD.visible=false; telling Object reference not set to an instance of an object.

please help me out for solving this problem

incorrect syntax at "=" error shown at da.Fill(dt,"hod");

2013-05-18T08:23:41.707-04:00

protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] != null)
{
Label6.Text = Session["hodusername"].ToString();
}

GetData();
moredata();

}

public void GetData()
{

string connstring = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myfile.mdf;Integrated Security=True;User Instance=True";
SqlConnection con = new SqlConnection(connstring);

SqlDataAdapter sa = new SqlDataAdapter("select hodusername,hodemail,dept,design,mobile from hod WHERE hodusername=' " + Label6.Text.ToString() + " ' ", con);

SqlDataAdapter da = new SqlDataAdapter(connstring, con);
DataSet dt = new DataSet();
da.Fill(dt,"hod");

if (dt.Tables[0].Rows.Count > 0)
{

txtname.Text = dt.Tables[0].Rows[0]["hodusername"].ToString();
txtemail.Text = dt.Tables[0].Rows[0]["hodemail"].ToString();
txtdept.Text = dt.Tables[0].Rows[0]["dept"].ToString();
txtgrade.Text = dt.Tables[0].Rows[0]["design"].ToString();

txtmob.Text = dt.Tables[0].Rows[0]["mobile"].ToString();
}

}
public void moredata()
{

string connstring = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myfile.mdf;Integrated Security=True;User Instance=True";
SqlConnection con = new SqlConnection(connstring);

SqlDataAdapter sa = new SqlDataAdapter("select * from desgn where design='" + Session["design"] + "'", con);

SqlDataAdapter da = new SqlDataAdapter(connstring, con);
DataSet dt = new DataSet();
da.Fill(dt, "desgn");

if (dt.Tables[0].Rows.Count > 0)
{

txtextno.Text = dt.Tables[0].Rows[0]["designcode"].ToString();

txtcostcode.Text = dt.Tables[0].Rows[0]["costcode"].ToString();

Grid View Paging Filter - Error paging

2013-05-17T15:05:34.487-04:00

I have a gridview with textboxes above it for users to input text and search/filter the results returned to the gridview. If I search for something invalid like <Script></script>, then I receive an error when paging on the grid view. I did not know the paging hyperlinks (i.e. 1, 2, 3, etc) caused the page to validate.

Is there anyway to stop the grid view paging action from submitting the form information, aka the filter data?

only upload mp3 file in asp.net using validation Expression

2013-05-18T07:43:56.77-04:00

Hi,

I am using RegularExpressionValidator to check the audio file format before save. Here is the code for RegularExpressionValidator=

/^(([a-zA-Z]:)|(\\{2}\w+)\$?)(\\(\w[\w].*))+(.mp3|.MP3|.mpeg|.MPEG|.m3u|.M3U )$/

But it is not working. Please suggest me where is the error.

Here is my Audio file Path=D:\SongCollection\Hindi\DIL\DAM DAMA DAM.MP3

when I click on save button, it will give the error( means regular expression error)