Filling Datatable Using Datareader?
Nov 3, 2010see i want to fill datatable using datareader.
i have created object like this
SqlDataReader dr=cmd.ExecuteReader();
if(dr.HasRows)
{
}
see i want to fill datatable using datareader.
i have created object like this
SqlDataReader dr=cmd.ExecuteReader();
if(dr.HasRows)
{
}
I have a problem with how to fill an array list from a data reader
string queryDTL = " SELECT * FROM tbl1 ";
connection.Connect();
cmd = new OracleCommand(queryDTL, connection.getConnection());
dr_DTL = qcmd2.ExecuteReader();
ArrayList RecordsInfo = new ArrayList();
while (dr_DTL.Read())
{
RecordsInfo = dr_DTL["number"].ToString();
}
The problem is the datareader contain alot of info other than the number but I don't know how to put them in their correct position.
what i have is the following code.
[code]...
I am trying to fetch a column value from a datasource when some value is selected from a dropdownlist on its change event.
[Code]....
Here I want to fetch any other column's value that is not binded to a ddlCityName from sqldatasource.
I have four columns in datasource i.e. name, id, address, phno.
I want to fetch an address of a person who selects some value from ddl.
dataTable with dataReader not working
[Code]....
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]....
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 ??
System.Data.SqlClient is not filling DataTable named "Person" Go to [URL] Webpage message reads: Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'Person'. Source Error:
[Code]....
Source File: d:hostingcforedDefault.aspx.vb Line: 41 Stack Trace:
[Code]....
I'm having a method that exports content from the database to excel files. The method taks as paramaters a DataReader param and a int param - the number of rows. For the number of rows i'm using a dataset, wich i fill using the same query as for the datareader. So I'm executing it twice... Is there a way I can avoid that? get the number of rows from the datareader?
View 1 RepliesI am getting an error that an open DataReader associated with this Command, when I'm not using datareader(though probably executereader() is the same thing) how would I close this if I don't have a datareader present?
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand("spSelectAllTypes",conn);
cmd.CommandType = CommandType.StoredProcedure;
[code]...
I just want to be able to databind a bunch of dropdownlist in one open connection. (before I had multiple open and closes for each control)
'DataTable' is an ambiguous reference between 'System.Data.DataTable' and 'Microsoft.Office.Interop.Word.DataTable'
View 3 RepliesI was reading: [URL]
But I have give a compilation error:
CS0246: The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?
i have the dataset with one table.Table contains three column like 'Name','Location','Pin'.I would like to move the data from another table based on schema.
View 2 RepliesIf 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 Repliesim trying to copying specific record from one datatable to another datatable i used below code
public System.Data.DataTable selectspecificdatarow(System.Data.DataTable dtg, int count, int startindex)
{
System.Data.DataTable dtn = dtg.Clone();
for (int i =startindex; i < count; i++)
[Code]....
its taking too long time in cloneing is there any better way to do this task which is Time effecent
how to join two datatable datas into one datatable to show in one gridview
i.e in 1 datatable i have username and pwd and in another datatable i have that user details. how to show all these in one datatable to get those values display in gridview(asp.net)
how do i fill a dropdown list from code behind using LINQ to SQL.
View 7 RepliesI have three Divs on the page and they are absolute positioned. Lets call them leftDiv,middleDiv,rightDiv and middleDiv width is 900px which is okay but the left and right divs should fill the remaining the left and right parts respectively no matter what screen size is.
The reason why I use absolute positioning is because it is the only way to use height:100% to fill the page.
So how can I fill the remaining parts?
Of course these divs separate page into three pieces according to their names imply.
I have the following code which does what it's supposed to do:
objSQLCommand = New SqlCommand("select * from table1", objSQLConnection)
objSQLCommand.Connection.Open()
objSQLDataReader = objSQLCommand.ExecuteReader()[code]....
But I need to loop through the objSQLDataReader 1 more time. How would I do that?
I'm creating a group of surveys that query Salesforce ([URL] CRM) to generate survey questions dynamically.
The survey layouts are determined by a record type that gets passed in the QueryString. The page queries Salesforce and aggregates the questions/fields it should be using. Then it creates questions and adds them to a panel.
When I open one survey, things look great, and they work as designed. But on opening a separate survey, of a different type, the questions from the first survey are still in the questions panel, as if they are cached somewhere.
To see what I mean, open "Survey 1". Then open "Survey 2" in a new tab. Now re-open "Survey 1", but this time do it in a new tab. Compare the first "Survey 1" to the second "Survey 1", and you'll see that the second "Survey 1" has the questions from "Survey 2" added into it.
Is there something - or a way that - I should be clearing variables, public variables, sessions, or page/panel caches on every page load?
I define the array where the fields/questions are aggregated like this:
ASP Code:
public partial class _Default : System.Web.UI.Page
{
private static ArrayList field_names_use = new ArrayList { };
I have to pull 150K records from DB. I am using da.Fill(ds,"Query") and its throwing system.outofmemoryexception.
Dim daGrid As New SqlDataAdapter(sqlcmd_q)
daGrid.Fill(dsGrid, "Query")
daGrid.Dispose()
I need this datatable only. I cannot use XML. because I need assign this to MSChartControl to display ScotterPlot.
We have a client with a SBS 2003 server, very standard setup.
The ms.netframeworkv2.0.50727 emporary asp.net files oot folder is filling up with 590kb folders at the rate of around 6 per min.!
They seem to point at a sage CRM package (installed on the server) but Sage say its a problem with IIS and not them!
i have html.dropdownlist in my form and i need to fill that with static data.
for example a list of months.
how can i fill dropdownlist.
I am using oracle as back end. In database there is a table with 5000 records and 160 columns. i want to display all these records in gridview(in asp.net, c#). But it takes more than 10 minutes to fill the dataset.
View 4 RepliesI have 3 tables:
SUPPLIER
Id (PK)
Name
City (FK)
State (FK)
CITY
Id (PK)
Name
State (FK)
STATE
Shortname (PK)
Name
1) I'd like to fill 1 dropdownlist with the STATE.Name and the other dropdownlist with the CITY.Name based on the STATE chosen, show up the cities, and after the city is chosen, the SUPPLIERS are shown.
2) Is it ok to make a foreign key field for State inside the City table ?
3) Is it better to create new fields STATE and CITY inside SUPPLIER ?