Web Forms :: DataSet.Fill Takes Along Time To Throw Exception When Connectionstring Wrong

Jan 18, 2010

when my website allow user many connectionstring by text to connect database anh retrieve data. But when user define very may wrong connectionstring. So Method in DAL dataset.Fill() takes a longtime to throw exception.So mywebsite will be die.

I want to method dataset.Fill() throws exception immediately when a connectionstring wrong. How can i do that?

View 2 Replies

Similar Messages:

How To Fill DataSet By Store Procedure And Fill DataGrid From That DataSet

Jul 4, 2010

I am VB.Net Windows Application Developer Now i am going an ASP.Net Application. So, the Problem is that in Windows Application i Code this Project like given Below Actually i am Using SQL Server as DataBase and Store Procedure as Query.Becuase i had tried to control the ASP.Net Data Grid with Loop and i Failed to Control it with this method

Private Sub btn_Ok_Click(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles btn_Ok.Click
Fill_dataset("Sel_MovNames", "Tbl_MovNames", Convert.toint32(cmb_MovID.SelectedValue))

View 2 Replies

How To Throw And Catch Exception Handling

Oct 12, 2010

iam inserting record in three tables in a database, iam using begin trans , commit transaction and rollback,

i want to use throw method, if any value insert wrong, pls correct me, i want to throw the error and

its go to rollback

running = false;
int updaterec = DBmgr.ExecuteNonQuery(CommandType.Text, "update ASArrivedcontainer set billgen ='Y' where billgen ='y' and acontinerid in ("+SelValues+")");
if (updaterec > 0)
running = true;
DataSet BillContainerDetails = BillingDetails();
byte[] ContainerDetails = GenerateBill(DBmgr, sContainerIds, rcno,isGeneralRCNo, FetchContainerDetails, ModifyId,ref BillContainerDetails);
//string otherchargesId = obj.retriveSingleRecord("select top(1) ModifyId from ASOtherCharges");
DBmgr.AddParameters(0, "@InvoiceNo", "1","IN");
DBmgr.AddParameters(1, "@BillDate", DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss tt"), "IN");
DBmgr.AddParameters(2, "@CustomerId", "1", "IN");
DBmgr.AddParameters(3, "@TotalAmount", "10000", "IN");
DBmgr.AddParameters(4, "@OtherChargesId", ModifyId, "IN");
DBmgr.AddParameters(5, "@ContainerDetails", ContainerDetails, "IN");
String BillNo = DBmgr.ExecuteScalar (CommandType.Text, "Insert into BillMaster(InvoiveNo,BillDate,CustomerId,TotalAmount,OtherChargesId,ContainerDetails) values (@InvoiceNo,@BillDate,@CustomerId,@TotalAmount,@OtherChargesId,@ContainerDetails)
Select @@Identity ").ToString();
if (!String.IsNullOrEmpty(BillNo))
running = true;
for (int i = 0; i < BillContainerDetails.Tables[0].Rows.Count; i++)
BillContainerDetails.Tables[0].Rows[i]["BillNo"] = BillNo;
DBmgr.AddParameters(0, "@Billno", BillContainerDetails.Tables[0].Rows[i].ItemArray[1].ToString(), "IN");
DBmgr.AddParameters(1, "@rcno", BillContainerDetails.Tables[0].Rows[i].ItemArray[2].ToString(), "IN");
DBmgr.AddParameters(2, "@acontinerid", BillContainerDetails.Tables[0].Rows[i].ItemArray[3].ToString(), "IN");
DBmgr.AddParameters(3, "@bflag", BillContainerDetails.Tables[0].Rows[i].ItemArray[4].ToString(), "IN");
//string value = BillContainerDetails.Tables[0].Rows[i].ItemArray[0].ToString(); ;
// string strsql = "insert into billcontinerdetail(billno,rcno,acontinerid,bflag) values(@billno,@rcno,@acontinerid,@bflag)";
String count = DBmgr.ExecuteScalar(CommandType.Text, "insert into billcontinerdetail(billno,rcno,acontinerid,bflag) values(@billno,@rcno,@acontinerid,@bflag)Select @@Identity").ToString();
if (count > 1)
running = true;
//running = true ;
for (int j = 0; j < BillContainerDetails.Tables[1].Rows.Count; j++)
DBmgr.AddParameters(0, "@billcontkey", BillContainerDetails.Tables[1].Rows[j].ItemArray[1].ToString(), "IN");
DBmgr.AddParameters(1, "@ratetypcode", BillContainerDetails.Tables[1].Rows[j].ItemArray[2].ToString(), "IN");
DBmgr.AddParameters(2, "@days", BillContainerDetails.Tables[1].Rows[j].ItemArray[3].ToString(), "IN");
DBmgr.AddParameters(3, "@amount", BillContainerDetails.Tables[1].Rows[j].ItemArray[4].ToString(), "IN");
DBmgr.AddParameters(4, "@level", BillContainerDetails.Tables[1].Rows[j].ItemArray[5].ToString(), "IN");
DBmgr.AddParameters(5, "@sflag", BillContainerDetails.Tables[1].Rows[j].ItemArray[6].ToString(), "IN");
// string strsql = "insert into billratedetail(billcontkey,ratetypcode,days,amount,level,sflag)values(@billcontkey,@ratetypcode,@days,@amount,@level,@sflag)";
String count = DBmgr.ExecuteScalar(CommandType.Text, "insert into billratedetail(billcontkey,ratetypcode,days,amount,level,sflag)values(@billcontkey,@ratetypcode,@days,@amount,@level,@sflag)Select @@identity ").ToString()

View 2 Replies

Set Dynamic Controls So It Doesn't Throw Exception

Jun 28, 2010

I have problem with Dynamic Controls in my Wizard Steps. In one of my Steps, I create a set of text boxes and checkboxes based on values from an XML document. Now, I initialise my dynamic controls using the OnInit method of the page, but at this stage there is no xml document until that step is reached, and of course I get null exception. How do I set my dynamic controls so it doesn't throw an null exception and be able to load any xml document when that step is reached?

View 1 Replies

Web Forms :: Webpage Takes Long Time To Load For The First Time?

Apr 30, 2010

I am working on a ASP.NET 2.0 application. It is hosted on IIS 6 on Windows 2003 server.

Few pages have jpeg images (around 50 images and 50 KB each). It takes long time to load the page for the first time. But when i open the same page for the second or third time it is faster.

why does a web page take long time to load for the first time?

Is it cached somewhere when it loads for the first time? Do we have any control over it?

View 5 Replies

Forms Data Controls :: Throw The Exception Back To Page_Load Error: ArgumentNullException Was Unhandled By User Code

Nov 19, 2010

I'm trying to throw the exception back to Page_Load but the throw statement causes error: ArgumentNullException was unhandled by user code. How can that be fixed? Also, I can't see Label1.Text displayed on the page after the ArgumentNullException occurs because the page is not re-load. If there is no exception, it's fine to not reload the page. How can I see the Label1.Text displayed?

protected void Page_Load(object sender, EventArgs e)
...do something here...
catch (ArgumentNullException ae)
Label1.Text = ae.Message;
Label1.Style.Add("visibility", "visible");
catch (Exception ex)
...do something here...
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)............................

View 3 Replies

Global.Asax - When Click On Datagrid Throw Exception

Nov 4, 2010

I m having a datagrid and for client side events I m using Javascript. I have few other buttons in the same page.

when I click on datagrid and select, it is working fine. After that, if I click on any other button in the Page, It is directly going to global.asax and throwing exception.

If I click directly on other buttons, they are working fine. Once I click on Datagrid and try to click on other buttons, it is throwing that exception.

View 2 Replies

How To Throw Exception If Session Is Written To In ReadOnly Mode

Sep 3, 2010

I would like to find a way to raise an exception if the Session is written to when in readonly mode. When EnableSessionState is set to "ReadOnly", values can still be put in Session, but the next request they will not be there. This seems somewhat dangerous.

One option is to create a helper class which we alway use to access session. However, this still leaves room for a developer to inadvertently use session directly, and fall into the "readonly" trap. Is there a way to create a CustomSessionStateDataStore that sits on top of the existing session code? I could not see an obvious way, and you can't inherit from System.Web.SessionState.SessionStateStoreData directly.

View 2 Replies

DataSource Controls :: EntityDataSource Throw Exception When Update With Self-Reference?

Nov 3, 2010

For a Table A defined in the DB like this:

A :{ id, selfId, name,} where selfId is a foreign key refered to Table A itself.

I generated the Entity automatically like this:

A :{ string id; A self; string name,} when i update the entity in gridview Edit/Update CommandField

i got the exception:

Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error:


Stack Trace:


I guess maybe this is caused by:

A is to be updated, and when the EntityDataSource construct the new A, the reference "self" is invalid at that moment. I do not want to modify my DB structure and do not want to lose the self reference, The event EntityDataSource_Updating is not triggered while the exception hit. so i can not access my entity at any time. Maybe the worst idea is deal the whole Update Procedure myself. However, is there any better workaround?

View 3 Replies

DataSource Controls :: Setting A Typed DataSet (xsd) Connectionstring Dynamically?

May 25, 2010

I'm trying to set up a simple content management system for two different sites, which are both stored on the same server (my own, not hosting, if it matters:)).

Both sites are basically the same, built upon a similar (but seperate) xsd (Typed DataSet) file, and read data from different databases using the tableadapters in the xsds.

Obviously, i have the same xsd setup in my management system application that need to hook up to the relevant database (after user authentication) and use the tableadapters to access the data and allow the forms in the management system to modify the data.

When i had a single site, the connection string was stored in the web.config file and after logging in to the management system, all forms could access the database.

Now i have two site and i need to setup the connection string in the xsd dynamically after user validation based on the relevant site to edit.

My question is, how do i set the xsd's connection string dynamically (after user logs in, the function returns the specific connectionstring and stores it in a Session variable)

View 3 Replies

Web Forms :: After Getting The Records It Takes Too Much Time To Display In The The Page?

Mar 1, 2010

i have 4 dropdownlist controls in a page. each have more than 6000 records. when retrive the records from DB there is no issue and taking very less time. after getting the records it takes too much time to display in the the page. here no problem with db retriving.. i guess problem is with page weightage. how can i solve this problem..

View 3 Replies

Web Forms :: Steps To Be Taken If The Page Takes Time To Load?

Feb 12, 2010

if I hit the .aspx page on the browser and if the page takes time to load say may be 25-30 seconds then what are the steps to be taken to make sure that the page loads quickly. In other words what could be the reason for this slow loading.

View 3 Replies

Web Forms :: Takes Time To Load Data In Dictionary

Jan 13, 2010

I have 10 000 000 words, I need to use


to search for specific word. It is very quick in finding the word, but when loading that amount of data to my dictionary it takes a while. Could you say what is the efficient way deal with such data? This is not homework or work related, but it is my personal project.

View 2 Replies

Web Forms :: SQL DataReader Takes Lot Of Time To Load Data

Nov 29, 2012

i am having the problem that i am using datareader to get contents in my asp.net page.But the page takes a lot of time to load.How to decrease the loading time of the apage and increase the performance of my page.

View 1 Replies

Unable To Throw Custom Error Handler From Within An Exception / "UnableToOpenDatabaseException Was Unhandled"

Jul 25, 2010

Why can't I throw a custom exception from within an Exception? In code below, I get error msg "UnableToOpenDatabaseException was unhandled" even though I have catch statement for it. What am I doing wrong? and how to fix it?


View 3 Replies

Web Forms :: ImageButton Hover Takes Time To Load Image?

Jan 10, 2011

I've dynamically made an ImageButton, the problem is when I hover the Image, it takes a few seconds to load the hover image (imgHover.png in my code)..

Is there a way to preload the images or something?

heres my code:


View 2 Replies

AJAX :: Throw Exception Message "Authentication Failed" When Call Webservice Form Javascript

Aug 16, 2010

I was created webservice which has a Method:


Then, in my aspx page, i call that method in javascript, but i get a Exception message is "Authentication Failed", code below:


How to resolve this problem?

View 3 Replies

Web Forms :: Improve Performance - Takes Long Time To Save Data

Mar 8, 2010

I have selected around hundred data and then bind to the repeater each times it take a long time to save data after clicking the save button. How can i improve the performance?

View 6 Replies

Web Forms :: Displaying Loading GIF Image Whenever Page Takes Time To Load

Apr 27, 2016

Displaying loading gif image whenever my page takes time to load but not for particular single control. i had seen this. URL...but it working for button , can i check it for my whole page  and all controls whenever it takes times to load.

View 1 Replies

Forms Data Controls :: Fill Gridview With Dataset And Query For A Logged In User?

Jan 4, 2011

I'm new with programming. I have a GridView that have the specific user data. When the user log in I retrieve the data for that specific user. All I need is; How do I make the gridview get the data of the logged user using a datatable that has a query. Just bind it with the datatable.This is some code that other programmer made, I continue his work.


View 3 Replies

Why Does Custom HttpResponse Throw Exception On HttpResponse.End()

Jul 27, 2010

I'm writing some code in which I need to use my own HttpResponse object to capture the output from a method on another object that takes an HttpResponse as a parameter. The problem is, this other object (which I cannot modify) calls HttpResponse.End(), which causes an "Object reference not set to an instance of an object" exception to be thrown. What can I do about this?

Dim myStringbuilder As New StringBuilder
Dim myStringWriter As New IO.StringWriter(myStringbuilder)
Dim myResponse As New Web.HttpResponse(myStringWriter)

someObject.doStuffWithHttpResponse(myResponse) ' calls myResponse.End() and crashes

Here's some more complete information about the error, thrown from the following code in a console application:

Dim myStringbuilder As New StringBuilder
Dim myStringWriter As New IO.StringWriter(myStringbuilder)
Dim myResponse As New Web.HttpResponse(myStringWriter)
Catch ex As Exception
End Try

Here's the text of the exception:

System.NullReferenceException: Object reference not set to an instance of an object.
at System.Web.HttpResponse.End()
at ConsoleApplication1.Module1.Main() in C:Documents and Settingsjoe.userLocal SettingsApplication DataTemporary ProjectsConsoleApplication1Module1.vb:line 10

View 2 Replies

State Management :: Data Being Saved To Wrong Table In Wrong Instance Of Sqlserver Of Wrong Database?

Aug 1, 2010

I have a weird thing happening. I have two identical databases installed on one virtual machine but under two different instances of SQLServer. For some reason, periodically when saving from one it will save to the other instead. Using debug, I have verified that the connection string is correct and when the item saves, it still saves to the wrong database.I use session variable, and am of the belief that it might have something to do with it...and t hat when I go from one to the other it is still getting the connection string form the other for some reason.To make sure that it isn't a problem, I make sure that I completely close out one database before opening the other in a new IE window.I assume that when I completely close out an internet explorer window that it abandons all session states. Is that true?

View 7 Replies

ADO.NET :: How To Fill Dataset Using LINQ

Aug 20, 2010

I trying to fill dataset using LINQ for past 2 days, I could not able to make it.

This is my query.


How can i fill the dataset,make use of above query.

View 2 Replies

C# - How To Fill Textbox From Dataset

Nov 28, 2010

i run this and i want to fill textbox txtFname with data - but it dont do nothing

using (Conn = new SqlConnection(Conect))
SQL = "SELECT * FROM MEN where id = '" + txtBAR.Text.Trim() + "'";
dsView = new DataSet();
adp = new SqlDataAdapter(SQL, Conn);
adp.Fill(dsView, "MEN");
txtFname.Text = dsView.Tables[0].Rows[3][0].ToString();

how to do it ?

View 2 Replies

Databases :: MySqlDataAdapter Fill Data Exception - C#?

Dec 30, 2010

I am using ASP.NET 4 (Visual Web Developer 2010 Express with MVC), however I think I should ask here as this will be a general MySQL 5 data access problem. I have other MySQL data access to other table with NO problem but this one.:

Here's my test SQL statement in a method:

public DataSet GetAll()
return ExecuteDataSet( "SELECT co.BookingID, co.BookingNo ,co.ClientID, co.AgencyID " +
"FROM clientorder co " +
"ORDER BY co.BookingNo");
protected DataSet ExecuteDataSet(string query)


View 9 Replies

Copyrights 2005-15 www.BigResource.com, All rights reserved