Browse by Tags

Related Posts

  • Table Adapter Insert Problem

    Hi Guys I am hoping someone kind person would help me out here, I a have just starting using tableAdapters but I am not quite confident just yet, although I have come a long way in the last few days and " Nights ", the problem I have is very simple I am sure, but I cannot solve it for the life...
    Posted to Data Access and ObjectDataSource Control (Forum) by Web Design Devon on 06-13-2009, 12:00 AM
    Filed under: Data, TableAdapter, TableAdapters, Table Adapter, DataSet, DataSet Access Parameter C#.NET 2.0, DataAdapter, Insert, Data Access Layer, DataAdapter DataTable SQL Server, DataRow, tableadapter dataset datatable, datatable.rows, dataadapter.fill(), insert datatable, database add records, Insert data, tableadapter passing parameter, data accesss layer, Insert Data Values into SQL Database
  • Filtering a DataSet that is retrieved by a stored procedure

    I hope someone can clear this up for me. I have a dataset that is returned from a stored proc with 3 parameters, but I only want a subset of that data once it is returned. I know the best way to do this is to add a 4th parameter to filter data at the source but that is not an option with this particular...
    Posted to SQL Server Reporting Services (Forum) by redtempo on 06-11-2009, 12:00 AM
    Filed under: dataset, filtering
  • Re: Dataset Class Not Generating Fill/GetData parameters

    Thanks for the reply but the tutorial only answers how to create a dataset with parameters and not why my parameters weren't being created in the dataset class which was my question. I actualy found the answer here: http://windev.wordpress.com/2007/03/05/tips-and-tricks-generate-typed-dataset-from...
    Posted to Other Databases (Forum) by illumna1 on 06-10-2009, 12:00 AM
    Filed under: Typed Dataset, .NET, dataset, Dataset Class, Fill Parameter, Get Parameter, XSD
  • session: sql field from one aspx to aspx

    Hi, I'm a newbie trying to use a session to capture a model no. from sql on 1.aspx page and post it in a textbox in 2.aspx. I can get the string on Page - 2, however Page - 1 has been a challenge. Page - 1 has a SqlDataSource1 connection and the Model No. is being posting along with other data from...
    Posted to State Management (Forum) by z.cross on 06-08-2009, 12:00 AM
    Filed under: SQL Server SessionState, sql session state, SQLServer, sqlserver session state, ASP.net Session, DataSet
  • SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

    Hi, I have an c# asp.net application. I use an dataset with an insert query like this: public void updateItem(configItem item) { configurationItemTableAdapter.InsertItem(item.id, item.startDate, DateTime.Now); } When item.startDate is null in the database, it gives me an sqlDateTime overflow error. When...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by khalidelmeknesi on 05-11-2009, 12:00 AM
    Filed under: dataset, datetime, error, insert
  • How to skip some parameters in an dataset query

    Im making an asp.net c# application and I have an dataset with some query's like add, remove and update. In my update query I have some parameters. Is it possible when I call the query in the c# codebehind, to skip some parameters. This is the update query with the parameters: configurationItemTableAdapter...
    Posted to Data Access and ObjectDataSource Control (Forum) by khalidelmeknesi on 05-11-2009, 12:00 AM
    Filed under: Parameter, TableAdapter, DataSet
  • Re: Export MsAccess database to Excel

    Thanks ... finally i got some code in codeproject .. Excel.ApplicationClass excel = new ApplicationClass(); excel.Application.Workbooks.Add( true ); DataTable table = DATASETNAME.Tables[ 0 ]; int ColumnIndex=0; foreach (Datacolumn col in table.Columns) { ColumnIndex++; excel.Cells[ 1 ,ColumnIndex]=col...
    Posted to Data Access and ObjectDataSource Control (Forum) by rameshsengamalai on 05-10-2009, 12:00 AM
    Filed under: datagrid, DataSet, Export to excel
  • Dataset design with multiple SELECT statements

    Hi, I'm using VS2008 SE to build a website. I'm building a dataset which is filled by the results of a Stored Procedure. The SP returns two data tables as it has two SELECT statements in it. The problem i have is that the dataset designer is only recognising the first SELECT statement and not...
    Posted to Data Presentation Controls (Forum) by Simon.uk on 05-07-2009, 12:00 AM
    Filed under: stored procedure, Visual Studio 2008, data table, dataset, designer
  • FbDataAdapter.Fill problem

    I am having trouble getting a simple VB code to populate a dataset (or datatable) based on a Firebird query. The connection string and query syntaxes are fine. What am I doing wrong here? All the examples I find in the fb documentation make it look like this should be fine. I do not have any selectcommand...
    Posted to Other Databases (Forum) by chase5465 on 05-06-2009, 12:00 AM
    Filed under: VB, dataset, datatable, fbdataadapter.fill
  • Re: Binding Data to Gridview

    you have to use dataset insted of datatable see my example public void personal_info_show() { string connectionString = ConfigurationManager.ConnectionStrings[ "CoreSqlServer" ].ConnectionString; DataSet datasetinfo = new DataSet(); DataTable datatableinfo = new DataTable(); // Search Previous...
    Posted to Data Presentation Controls (Forum) by rezakawser on 05-05-2009, 12:00 AM
    Filed under: dataset, GridView
Page 1 of 31 (305 items) 1 2 3 4 5 Next > ... Last »