Asp.net - Dataset Column Always Returns -1?
Aug 20, 2010
I have a SQL stored proc that returns a dataset to ASP.NET v3.5 dataset. One of the columns in the dataset is called Attend and is a nullable bit column in the SQL table. The SELECT for that column is this:
CASE WHEN Attend IS NULL THEN -1 ELSE Attend END AS Attend
When I execute the SP in Query Analyzer the row values are returned as they should be - the value for Attend is -1 is some rows, 0 in others, and 1 in others. However, when I debug the C# code and examine the dataset, the Attend column always contains -1.
If I SELECT any other columns or constant values for Attend the results are always correct. It is only the above SELECT of the bit field that is behaving strangely. I suspect it has something to do with the type being bit that is causing this. So to test this I instead selected "CONVERT(int, Attend)" but the behavior is the same.
I have tried using ExecuteDataset to retrieve the data and I have also created a .NET Dataset schema with TableAdapter and DataTable.
View 2 Replies
Similar Messages:
Feb 11, 2010
What I'm trying to achieve is to track any change made on a form. I thought DataSet.HasChanges and DataSet.GetChanges would be a good way to accomplish this. However, in the code below DataSet.HasChanges always returns false.
EmployeeDs represents a strongly typed DataSet.how to get changes from the updated row into the new dataSet?
[Code]....
View 2 Replies
Jun 25, 2012
I have a function which returns dataset after execution of sql statements
If the dataset retruns rows than he data shld be dislayed in reporting services
Else display no rows avaliable
But currently even if there are no rows as per the given condition, the earlier data gets displayed
View 1 Replies
Jul 1, 2010
I added a new table to my type dataset. When the code tries to execute the new row on that table I get the error message.
(if you can't see the error. "MissingMethodException was caught" "Method not found: 'MyTableDataTable MyNamespace.get_SSCase().")
I've tried the wizard and also click and drag the table from solution explorer to the xsd file. The other tables work, just this one table won't work. What should I check?
View 1 Replies
Aug 27, 2010
private void FillDetails(string pId, out string Name, out string Address)
[code]....
I have method called Filldetails(),This method uses stored procedure to retrieve information for product name and address based on productid passed from productdetails table.I am working on globalization project.We have this product information for US country but there is no product information for germany country.So dataset is empty for germany.As result I am getting error object reference not set to an instance of the object.
View 3 Replies
Jun 29, 2010
I have two extremely long queries that I am running on multiple tables, using an INNER JOIN. The only difference between these two queries is that they take different input values for one of the WHERE clauses, which they get from two separate DropDownLists. The results of these queries are identical, save for the time1/time2 columns.string query1 = "select Name = t1.name, time1=(SELECT hours FROM table3 WHERE street=list1.selectedvalue), t2.address from [table1] t1 INNER JOIN [table2] t2 ON t1.param = t2.param ORDER BY Name"
View 1 Replies
Feb 2, 2010
i have dataset having one table have 5 columns fill data from database.
When i run application datatable contains more than 50 rows, I would like to update value of datatable after getting data from databse. My requirements are This table have few cells having Null value, I would like to replace null with "-" ? One column is System.datetime datatype, where i would like to remove time. I would only like to have date?
Here i am thinking that i apply one loop of rows present in datatable and update cells accordingly. But i am searching any direct update method?
View 3 Replies
Aug 14, 2010
I want to read complete column from the dataset using select command or whatever without looping the rows of the table.Because in table i got 35000 records i only want to read a one complete column from the top to the end using dataset.
Eg: select column_name from table.
lly, dataset.tables[0].select["Column='Product'"]
I have tried with this but throwing exception.
View 4 Replies
Sep 8, 2010
i have the following column "ID" in dataset: myDataSet.Tables("Table"), is it possible to read the columnd ID and get max id what is in the dataset.
View 6 Replies
Dec 10, 2010
I have a column in a dataset which shows the time as 9:16
On my UI, I have Hour dropdown and a Minute dropdown. I want to split the time such that 9 is bound to the Hour dropdown and 16 to minute.
View 4 Replies
Aug 20, 2010
I follow the tutorial and create DAL with Dataset. I created a Table Adapter with many column, but when i Call a simple Get for 2 column only. The system display 2 column and the rest column with empty data.
example: Table with 40 column define in Dataset in DAL. I have GetMember from Dataset with 40 column, some request only 1 column (with 39 empty), some request 22 column (with 18 empty column). Will this affact the performance?
View 2 Replies
Jan 5, 2010
I want to retrieve identity column value after running Insert or Update (using Access DB in C#). How can I do it?
i use a Typed dataset to fill and update...
View 4 Replies
Dec 14, 2010
i have a dataset and a table into named Students. Students(StudentName, age)
i wanna name colunm to string array. but not use loops (for foreach..). is there any way?
string[] array = this.dataSetZLC.Student.StudentNameColumn..
View 5 Replies
Jun 8, 2012
i am creating a dataset from SP Sp when executed in query analyser dislays the output but when i used the same for creating datset , its created but i dont get any columns i checked the xsd in notepad but there is no column source names
View 1 Replies
Feb 16, 2010
I have a datatable in MS SQL that has FirstName and LastName. In MS SQL I created a computed field called FullName that was ((rtrim([LastName])+', ')+rtrim([FirstName])) I created a DataSet and a Business Logic Layer. In my typed DataSet I saw FullName in the listing when I created it. I am able to use FullName in my webpage. I use it to populate a dropdownlist. However, now when I make changes to the Customer Table I am getting this error message (seen below)
Question: Should I have created the field FullName in my MS SQL Table or should I have left it alone and somehow just added a column to the DataSet and placed an expression in the FullName column? The column "FullName" cannot be modified because it is either a computed column or is the result of a UNION operator. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The column "FullName" cannot be modified because it is either a computed column or is the result of a UNION operator. Source Error:
[Code]....
Source File: c:Users ottfarmsAppDataLocalTempTemporary ASP.NET Filesinternalauburnriverside98ea0e1f2a7f0720App_Code.lbdcba1v.2.cs Line: 1240 Stack Trace:
[Code]....
View 1 Replies
Feb 21, 2011
The following query returns me the column name from the table in the database, and stores the column name in the grid. How can I change the column name in the grid using following code, if its possible?
DataSet p_dsInformixDataDs = new DataSet();
string cmd = "SELECT * FROM CUSTOMERS";
try
{
using (IfxDataAdapter da = new IfxDataAdapter(cmd, m_InformixDBConn))
{
da.Fill(p_dsInformixDataDs);
}
}
DataView myDataView = new DataView(m_dsInformixDataDs.Tables[0]);
if (myDataView .Count > 0)
{
GridView1.DataSource = m_dsInformixDataDs;
GridView1.DataBind();
}
View 5 Replies
Jun 30, 2010
how to convert the dataset columnnames to UPPER case letters. I have a code like :
[Code]....
But returned dataset result is not showing the uppercase column names.
View 6 Replies
Oct 15, 2010
I have in my code a gridview that I redirect to excel, it works fine when I have data in the data set. waht I want is to show column headers when there is no data right now what i get is empty sheet.
View 7 Replies
Mar 27, 2010
I have a stored procedure in my database that sorts a dataset by distance from the specific address input by the user. The distance is created among each individual users query and the sorting of distance occurs within my stored procedure, the distance is not returned in the output. Is there a way I can create a temporary column that returns the distance so that I can give the user an option to sort by distance?
View 9 Replies
Jun 29, 2010
I want to dynamically bind dataset values into datagrid's header datafield.
Is it possible? To be more clear, when you click on datagrid's (Collection) from properties window, you get selected columns created from Bound column. So in those columns I want to dynamically display dataset's table values in those columns.
i.e like ds.Tables[0].Rows[0][0].
Is it possible to do it in Datagrid ItemDataBound function like,
e.Item.Cells[1].Text = ds.Tables[0].Rows[0][0]
or something like this? I know the above code is wrong and wont work since I tried it out and while building it throwed error saying, Cannot implicitly convert type 'object' to 'string'.
View 5 Replies
Dec 21, 2010
I was trying to place all the rows of the Column "Title" of the dataset into the string array. But i get an error Identifier Required at strdeals[] in the last line. where am i doing wrong?
string[] strdeals = new string[100];
Dataset dsdeal;
for(int i =0; i< dsdeal.Tables[0].Rows.Count; i++)
{
strdeals[] = dsdeal.Tables[0].Rows[i]["Title"].Tostring();
}
View 1 Replies
Mar 11, 2010
I have a dataset and I want to add a total row at the bottom so it would look like this
user1, 10
user2, 5
user3, 5
user4, 2
TOTAL, 22
How can I do that? I tried to first add the row using dataset1.Tables(0).rows.add() but that didn't work, and how can I add the 2nd column?
View 4 Replies
Mar 31, 2011
In my project I work with Entity Framework (LINQ to ENTITY). I only have ADO.NET Entity Data Model and a DAL (Data Access Layer). I also get the data due a WCFClientService. I have a gridview that needed to be exported in Excel.
FlexCel is a tool for generating Excel files based on a template. The only thing I see in demo's is that they work with DataSets.
Is there a way to convert the data in my gridview to a virtual DataSet?
I've written the following method to get the data:
[Code]....
View 1 Replies
Jan 9, 2011
Till now I used to design RDLC file before and assigned typed dataset table columns.Report processing mode is local. But now my stored procedure returns different columns based on condition i.e columns are not fixed every time. Now I need to add that columns to typed dataset and dataset is assigned to RDLC file. So dataset and RDLC files are create dynamically based on stored procedure result set columns.
View 1 Replies
Jan 18, 2010
What I am thinking is this? Is it possible for me to upload the data from an excel file to dataset of my application first, so that the user can view the data in a gridview to review it first, before the user strike the save button, to save it in the database. So, that in case there is a problem, the gridview will high light all the data with an error. So the user can easily pull out the excel and correct the data before saving it in the database.
View 4 Replies
