i'm developing a website to my office, i have a question related data loadinf performance related.
dataadapter.Fill() or dataTable.Load(Datareader) give the best performance in asp.net ??
I have no problem when paging my FormView, the dropdownlist does not read the next record and keep the value of the first loaded record? All other textbox control behave normally and move from record to record excepted the ddl??Here the code.
Public Sub DoData()
Dim myConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString)
Dim myCommand As SqlCommand = New SqlCommand("SelectSupplier", myConn)
myCommand.CommandText = "SelectSupplier"
[Code]....
what are differences between datareader and dataadapter?
View 2 RepliesUsing C#, Visual Studio 2010
I have 8 drop downlists created in .aspx page.
I try to programmatically fill the 8 using a single datatable. Each dropdownlist has its own column in the datatable and is supposed to display only the column that corresponds to it. It does display the column it is supposed to however it also displays a number of empty slots equal to all the other columns combined.Here is the code can someone tell me why I get the empty slots?
[Code]....
I am not clear when do I want to use a webservice over a sqlDataAdapter for dataRetrieval. I want to populate a repeater control which I have been doing from a dataTable that I fill from a sqlDataAdapter. Is there criteria when I would want to use a webservice to fill my dataTable?
View 3 RepliesI there I have recently created an ASP website wich uses .net 4 and SQL db but soem some reason even displaying 20 records in a gridview is slow... So after some reading I converted the website to a Web Application Project so its compile prior to publish.. But yet again this is a bit slow. pages loading time is not of a bit issue...
View 8 Repliesi 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 RepliesdataTable with dataReader not working
[Code]....
I'm fairly new to ASP.NET and am working through a tutorial that demonstrates the use of DataAdapter, DataTable, and DataRow classes. The tutorial focuses on binding returned DataTables to GridView objects - I'm having trouble understanding what to do to extract one row for display. I've found I can do the following:
ProductsTableAdapter productsAdapter = new ProductsTableAdapter();
Northwind.ProductsTable productsTable = productsAdapter.GetSingleByProductID(searchID)
Northwind.ProductsRow productRow = (Northwind.ProductsRow)productsTable.Rows[0];
A ProductsTable should be able to return its own ProductRows w/o resorting to a cast, no? Can't find how to do it otherwise. I'm thinking how to go about creating a form where the user will only ever be working on one record at a time. Wouldn't it make sense for the DAL to return a ProductsRow instead of a ProductsTable?
How do I load a datareader in a defult.aspx page using while using a database connection that is defined in the web.config file?
View 3 RepliesHow can I load (copy) the data that is present in the GridView into the DataTable? I am planning on loading the DataTable from GridView and update a row from the datatable and load the newly formed data with the GridView.
Note : Here I am not using datasource.
using linqs how to fill datatable using linq to sql in asp.net
i have one storedprocedure to select data from table
and one s.p for insert the data and one for update the data
how i use these s.p to insert and update the data using linq. to sql
I am gettin error in this code
[Code]....
In am using following code for paging purpose in asp.net to reduce the load of reading all the records from the database.
SqlDataAdapter.Fill(StartRecord,MaxRecords, DataTable);
I want to know whether this code Get all data from data base and filter the records in application or just fetch the needed records only.
see i want to fill datatable using datareader.
i have created object like this
SqlDataReader dr=cmd.ExecuteReader();
if(dr.HasRows)
{
}
Okay so my situation at work is that I've written about 200 or so lines of additional functionality into an aspx page's code-behind that is currently not to be implemented. It is in a subroutine that handles an event that currently has zero chance of occurring.
Because this code is not being used, I've gotten curious. Should I comment out the subroutine that has zero chance of firing? Would it do anything to enhance the performance of the page or anything like that if I did indeed comment it out? Or could/should I just leave it as is?
I have a custom validator which validates three text boxes. my code is,
[Code]....
I fill in all the three textboxes.it still gives me the error message to fill in all the boxes and does not submit the page even when all the three boxes are filled.
I have almost got this all working but one thing. What i am doing is SELECTING a number of details from a table which is for job vacancies. I am then displaying the job_name, a short description about the job and finally the location's the job is available in..If you look on this page:http://kidsunlimited.co.uk/vacancies_test.aspx
You will see a list of Vacancies shown BY job name. The problem occurs when the job is available in more than once location. Take a look at the Cook vacancy. It should be reading as Cook, then the description and then location which in this case there are 2.But instead it mixes them up and displays one location before the description and one after..This is the code i have :
[Code]....
The problem is on this line i think:
[Code]....
1. As per my knowledge we use dataadapters/dataset when we want to deal with the huge amount of column/data. Is there anyway that if I want to update one or two columns in a table without using dataadapter/dataset?
2. There is a way that without clicking a button we can get the data using objectdatasource, I mean to say that there is no vb.net data in the code behind then how to debug if there is not data in vb.net in code behind.
i'm tring to read data from a sql DB, where is email == mystring - then display its name here is the code:
string mystring;
mystring = "email@email.com";//"Welcome " + System.Convert.ToString(Session["user"]);
generalTableTableAdapters.kurtula_generalTableAdapter generals = new
generalTableTableAdapters.kurtula_generalTableAdapter();
generalTable.kurtula_generalDataTable genaraltab = generals.Getgeneral();
foreach (DataRow row in genaraltab.Rows)
{
if (Convert.ToString(row["email"])== user)
{
Label1.Text = System.Convert.ToString(row["name"]);
}
}
as you can see I'm a table adapter but is giving me the following error: i realy dont know what this error means - though i did a simular action using access DB (and it did work), where i had to user the following: using System.Data.OleDb; now because im using SQL DB im using: using System.Data.SqlClient; //sql server
I am trying to use a SqlDataAdapter to fill a DataTable, which I use as a data source to a DataGrid. The query is fine, at least when I run it manually in SSMSE. When I do the fill operation, the table gets the right columns, but no rows. The most frustrating part of this is that the code is identical (with a different query) on a different page. I cannot post the query, but my initialization code looks like this:
SqlCommand areaDAC = new SqlCommand (areaQuery, connection);
areaDAC.Parameters.Add (new SqlParameter ("@param", System.Data.SqlDbType.NVarChar, 50));
m_areaDataAdapter = new SqlDataAdapter (areaDAC);
Then to use it:
m_areaDataAdapter.SelectCommand.Parameters["@param"].Value = "Filter Val";
DataTable table = new DataTable ();
m_areaDataAdapter.Fill (table);
At this point, table has the right number of columns and no rows. I know the parameters are being added correctly, I know that data exists for the given query.
Update (as provided by Nik in a comment):
[Code]....
I have a dataset with a table adapter that has several queries. I want to execute on of the queries and fill a data table but am having trouble with this operation. Am I invoking my table adapter incorrectly? See line 56.
[Code]....
If I am passed a datatable and I cant change the column structure..is there anyway to set an existing column to a Primary key so I can easily Find() the row I am looking for?
View 1 RepliesI often Observed that pages developed in simple asp is being load most speedy then pages developed in asp.net ,
View 5 Replieshow to improve the performance of dynamically load user control
View 1 RepliesI am trying to run a linq query but I need the result as a datatable as I am using that to store records from different queries in the same viewstate object.The 2 versions below compile, but return an empty set. The exact error is "Value cannot be null.Parameter name: source". (and yes I have checked there is data):
MyDatabaseDataContext db = new MyDatabaseDataContext(conn);
IEnumerable<DataRow> queryProjects =
(from DataRow p in db.STREAM_PROJECTs.AsEnumerable()
[code]...