Lang-ASP.net using C# and Sql server 2005
i m trying to use the sql datareader to fetch a single row at a time i wanna know can we use it to fetch a single row at a time or not if yes i m unable to figure out what i m doing wrong here bcus its not returning any data
[Code]....
of course data is present in my table bcuz when i m using dataset i m able to the return the single row throuugh dataset
how to display multiple records in a label from database through coding?
View 1 RepliesI'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)
I have a stored procedure that returns 3 tables within the single recordset it returns. If I set a SqlDataSource to get data from this procedure, it works, but it only returns the first table. I want to have a GridView display the data from the 2nd or 3rd table using a SqlDataSource, but I can't figure out how to specify a particular table.
While there are some posts discussing this out there, I can't get a definitive answer about whether or not this is even possible (?). In a worst-case scenario, I can create another SP that only returns the 3rd table - but that creates a little maintenance headache that I would prefer to avoid.
For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
I have huge excel files that I have to open from web browser. It takes several minutes to load huge file. Is it possible to open a single worksheet (single tab) at a time from excel file that contains many worksheets? I have to do this using C# / asp.net MVC
View 5 RepliesI am trying something apart of my boundries, is there any way to disable a single intem in dropdownlist or stop the ddl change event for a single item.
View 2 Repliesif I have this URL:
[URL]
How can I fetch the first two information from it into my aspx page? for example I want to read the first two timings.. Should I use xmlReader or what?
1)usign execute scalar i will get 1st col and 1st row value.
2)using dataset i will get whole table.. if my stored proc has 2 queries then i will get 2 tables within same dataset.. i can reference therese using ds.tables(0).rows(value).
3)suppose i use a datareader then i will get multiple-rows. i want to know how to get these each separate rows coloumn values into variables. below is the reader aspx.vb
reader = cmd.ExecuteReader();
while (reader.Read()) {
4)what is it mean by data reader is forward only method of getting data.
5)why do we do readeritem.tostring()
6) can you tell me the basic how is this reader,ds,scalar works.i mean i know to use but donot know basics esspecially the dataadpapter.why do we fill it when using dataset.
I want to fetch data from separate tables in sqlserver and display them together in GridView, Is that possible?
View 3 RepliesI have a Grid in which I am showing some records in each row. Here's how it is:
Now, my problem is that when I press the view button, I want to fetch the ID from the first column in a session variable so that I can display the same ID on the next page.
For the ItemTemplate of EditButton, I am using this code:
<ItemTemplate>
<asp:LinkButton ID="EditBtn" CssClass="btn green" CommandName="edit" ToolTip="Edit" Text="Edit" runat="server" />
</ItemTemplate>
1.) Reading all the contents of a page against a url.
2.) Convert all these contents into a pdf file.
what's the best and most likely way to fetch data from database...
View 5 RepliesIm facing problem in one of the reports while passing multivalue parameter from ssrs to SP.
please note that in cases suppose there are single word in multivalue paramtere then its works corretly,in that scenario i have made one function see below:-
[Code]....
and did changes in sp as follow :-
[Code]....
im using ssrs2005.
MySqlCommand cmd4 = new MySqlCommand("select emp_name from employee_details where emp_category='" + cat[j] + "' and no_ofcassigned=(select MIN(no_ofcassigned) from employee_details)", AL.con);
MySqlDataReader reader2 = cmd4.ExecuteReader();
string emp=null;
while (reader2.Read())
{
emp = reader2[0].ToString();
}
reader2.Close();
i am using the above code to fetch the employee name from the datatable according to the minimum value in the column 'no_ofcassigned' in specific category but here if i have more than 3 employees with the same no_ofcassigned is there then the query is not
Following error is thrown from the live application every now and then
[Code]....
now able to able to replicate the issue on test server. what could be the reason of the above error?
My application writes custom attributes to input controls using Helper classes. And also we are loading the UserControl dynamically so we need to use FormCollection to get the posted values. Is there a way that we can access attribute values from FormCollection object.
Example:
<input type="text" name="textBox1" value="harsha" customAttr1 = "MyValue" />
My question is how can i access the value of customAttr1 from the above eg from inside the controller.
Data can be fetched into an application through web service can it be possible to update data in web service from our application ..
View 2 RepliesI'm having issues getting the selecteditems and value after Databinding a dropdown list. I have a button event with dropdownlist2.Selecteditem.text, but will always get the "-- Select --" as the SelectedItem.text ?
[Code]....
how to call the same page for fetching data using jquery
In the below mentioned ajax function, I would like the url to be the same page.
When the ajax call succeeds i want the image to be displayed in an img tag.
how to fetch items from an ItemArray? What I've got so far:
int h = tableDataSet.Tables["test_table"].Rows.Count;
for (int y = 1; y <= h; y++)
{
DataRow tr = tableDataSet.Tables["test_table"].Rows[y];
[Code]....
I keep on getting the following error: Input String was not in a corect format.
I am trying to use the autocomplete extender but it won't fetch the data. Why is it not working?
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" ServiceMethod="SearchEmployeesByName"
MinimumPrefixLength="2" CompletionInterval="100" EnableCaching="false" CompletionSetCount="10"
TargetControlID="txtContactsSearch" runat="server">
</cc1:AutoCompleteExtender>
public partial class Controls_EmployeeByName : System.Web.UI.UserControl
[Code] ....
I need to do parallel processing in my coding because i have 4 sql to fetch data from database which each take me 3-4 minutes.All the tables involved are raw table and that is no way i can reduce the time for the sql.I need to find a way out to reduce the data fetching time.The only thing i canfigure out is to have this 4 sql execute at the same time by doing parallel processing.
View 4 RepliesI have a problem at the time of updating the datagrid. I want that at the time of update data is shown in form instead of datagrid.
[code]....
