I have a website I am working on and I am using the following code quite often to access the database:
[Code]....
I have a few buttons on one page that use something similar like this in the code behind. I have heard to look into ADO.NET but I was wondering if there was a quicker way then creating model and business layers etc.
How do you make SMO release it's connections?
I have this code:
[Code]....
For every call I make to this index method a connection is spun up - and is not released again.
So after 20 calls to the page, I have 20 of the connections awaiting command. This eventually ends up with an exception, when I cannot make new connections, because the connection pool is full.
What do I need to avoid this happening? I cannot seem to find a method on the SMO Server object like Dispose, close or similar.
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
i am using simple form in that i put 3 upload option when i click the upload button the 3 files are stored in to unique directory. but when i refresh the page once again again it store the file once again to the directory . how to fix this problemin asp.net C#
View 5 RepliesI have the following Page_Load function...
protected void Page_Load(object sender, EventArgs e)
{
XmlDataSource1.Data = GetXmlFromFile(Request.QueryString["file"]);
XmlDataSource1.DataBind();
Repeater1.DataBind();
}
The page in which this Page_Load resides is called by a parent page. Each time this Page_Load gets called the value of "file" in the query string will be different. So each time I will be receiving the XML contents from a different file which are inserted into the XmlDataSource and then bound against by the Repeater. Getting the XML data from the file works great but when I bind against the repeater that only works the first time through Page_Load. Each time after that when this code is executed the same results from the first XML file are displayed in the repeater.
What am I missing here. How can I get the XML data to be bound against the repeater on each page load instead of just the first one?
I have a webservice (ASP.NET) deployed on a webfarm. A client application consumes it on daily basis. The problem is that some of its calls are duplicated (with difference of milliseconds). For example I have a function Foo(string a,string b). The client app calls this webmethod as Foo('test1','test2') once but my log shows that it is being called twice or sometimes 3 or 4 times randomly. Is this anything wrong with the webfarm or the code? Note that the webmethod has simple straighfarward insert and update statements.
View 1 RepliesI have a few update panels on a page and when Timer ticks they each make a call to the database. With their being 8 panels it was taking some time to refresh the page, so I decided to use asyncronous calls to the database. Here is a sample call:
//Create an instance of the DataAccess class
dataAccess = new
DataAccess(); [code]...
Prior to using the callback method it all worked fine (though it did take a while to first load the page). Now, even though the methods are called, the labels are not being updated.I have added Async="true"to the page directive but that doesn't help.Does anyone know a way to make the information show on the page when the EndGetDataSet method is invoked?(DataAccess is a small class I created to enable creation of DataSets and it takes a Hashtable containing SQlParameters as an argument).
This question may have been asked before, but I'm looking for a different answer than what I've seen.
Our website is in ASP.NET and we use the model-view-presenter pattern to get business logic out of the markup codebehind.
Is there an accepted pattern for web services for getting business logic out of the codebehind? It seems like putting the logic in a 'presenter' is misleading since the calls don't really present anything to the user, and may not even send back data to the client.
i have the code for asynchronous call to the database. i execute the sql command into the begin method that will executed onto the separate thread. now i want to execute the another database call asynchronously so that this also execute onto the separate thread. code for one database cal is here....
private SqlConnection con, con1;
private SqlCommand cmd, cmd1;
private SqlDataReader dr, dr1;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
AddOnPreRenderCompleteAsync(new BeginEventHandler(Begin),
new EndEventHandler(End)
);
}
}
/////////////BEGIN METHOD
IAsyncResult Begin(object sender, EventArgs e,AsyncCallback cb, object state)
{
string connect = "Data Source=.\SQLEXPRESS;Asynchronous Processing=true;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
con = new SqlConnection(connect);
con.Open();
cmd = new SqlCommand("SELECT FirstName,LastName,Age,Company,Profile FROM Person",con);
return cmd.BeginExecuteReader(cb, state);
}
//////END METHOD
void End(IAsyncResult ar)
{
dr = cmd.EndExecuteReader(ar);
Label2.Text = System.Threading.Thread.CurrentThread.GetHashCode().ToString();
GridView1.DataSource = dr;
GridView1.DataBind();
}
I have a gridview with delete buttons for each record (I've used AccessDataSource). I have loaded the data in and have many duplicate records.
I just want to use the delete button delete each duplicate record while remains many duplicate records. For example:
I used the following query to load in duplicate records:
SELECT * FROM TableA WHERE ([ControlA] IN (SELECT [ControlA] FROM TableA GROUP BY [ControlA] HAVING (COUNT [ControlA]) > 1)))
ID ControlA PIN# FaceValue Date
delete 76637 128232 1234 5 6/4/2006
delete 72722 128232 1234 5 6/4/2006
delete 76638 234567 2345 10 7/3/2006
delete 72723 234567 2345 10 7/3/2006
What is the query to delete single duplicate record instead of deleting all duplicate records?
I am learning asp.net web development. I have create a table with the column "username". But i don't know how to prevent the Duplicate "username".
View 5 RepliesIs there anyone know the reason why that there duplicate data in the database most of the time the information is same like name,description.but the unique id is different and the date time is got different millisecond.I confirmed that there r no loop condition on the code.
View 8 RepliesI know MVC controllers are quite good at serving JSON formatted AJAX requests, but is there any built-in ASP.NET functionality I can use for these type calls from a plain old web forms site
View 3 RepliesWe are buling a hosted ecommerce shopping cart solution and I would like to use asp.net's built-in membership provider. We dont really want to have a seperate database for each domain, we want to share the same database across mupltiple domains for different customers. Each domain is a seperate store.
My problem is that since it's a shared hosted solution people coming from different domains might use the same user name and it would show as if already existed. Is there an addional field I can use to store the domain name so basicly would be unique by username and domain name. We don't want to share information between stores.
Table1:
ID FROM TO
12 TXS NY
12 LS NY
This is my table ... I am retriving the values of "FROM" and "TO" based on the id .. Separate Dropdownlist for FROM & TO . While Displaying , in "TO" Dropdownlist NY value is repeated twice .. How to remove the duplicate value? need vb coding frnz ...
I am working on a project in .NET (C#), connected with a database. And I am entering values in database through 'text-box' control, for a part of the project. What I want is to check if the user entering value already exsists in the database and if so, shows error during that time only.
I have searched for any familiar post here, that could solve my query, but didn't get any.
my EXACT objective(if not cleared earlier):-
when the user enter the value in
textbox, automatically an event to
check any duplicate records in
database should occur. And if found,
displays an error message
I have a gridview control with delete asp:ImageButton for each row of the grid. What I would like is for a jquery dialog to pop up when a user clicks the delete button to ask if they are sure they want to delete it.
So far I have the dialog coming up just fine, Ive got buttons on that dialog and I can make the buttons call server side methods but its getting the dialog to know the ID of the row that the user has selected and then passing that to the server side code. The button in the page row is currently just an 'a' tag with the id 'dialog_link'. The jquery on the page looks like this:
$("button").button();
$("#DeleteButton").click(function () {
$.ajax({
[code]...
The dialog itself is just a set of 'div' tags. Ive thought of lots of different ways of doing this (parameter passing, session variable etc...) but cant figure out how to get any of them working.Any ideas are most welcome
I need to check for duplicate records before inserting them into the SQL database.Thus I have the following codes:
For count = 0 To GridView1.Rows.Count
If (GridView1.Rows(count).DataItem("Student Name").Equals(dtDataTable.Rows(count).Item("Student ID"))) Then
lblMsg.Text = "Records Existed"
End If
but there are error message. "Object variable or With block variable not set."
I want to create duplicate table, in oracle I am using "create table dup3 as (select distinct * from dup2) " this sql query but when I run this query in SqlServer then error is coming.
View 5 Repliesuse of auto complete object and after upload my website on the server my grid view show duplicate row in thats pages!every thing in my database ok and my program works good on other places.
View 1 RepliesI have table with 'usercard' name , and a related tables :
- Computer
- Laptop
- Fax
- UPS
Now , Every Employee has one or more than one from these devices , When I used INNER JOIN in my select query , I didn't get what I need
the result show a one user in 4 rows,(user have all devices)
I'm building this small control. It should detect client resolution and set height and width values within two separated HtmlInputHidden controls. But tester property is not getting values froms this control.
[ToolboxData("<{0}:UIControlResolution runat=server></{0}:UIControlResolution>")]
public class UIControlResolution : Control
{
HtmlInputHidden _txtwidth = new HtmlInputHidden();
HtmlInputHidden _txtheight = new HtmlInputHidden();
[Code]....
I'm using SQL Server 2005 in a project, and i need to duplicate a record from a table and all it's relationships.
View 9 RepliesI have 2 tables Order and Order_Detailrder_dtl_id is the primary key Order_id is the foreign key that referrence Order_Id in Order Table
View 4 Repliesas i am new to ASP.NETi have a database for employee appraisal for a company. in that table
employeeid,
appraisalid(primary key),
objective,
[code]...