Home ›
All Tags » DataSet » ADO.NET (RSS)

Browse by Tags

Related Posts

  • Help on Retrievind Data with ADO.NET

    Private Function UserExists(ByVal username As String) As Boolean Dim ruser As DataRow SqlDALogin.SelectCommand.Parameters(0).Value = username SqlDALogin.Fill(DsLogin1) Try For Each ruser In DsLogin1.Tables("member").Rows If ruser("user_name") = username Then Return True Exit For End...
    Posted to Data Access and ObjectDataSource Control (Forum) by angshumanmitra on 04-04-2008, 12:00 AM
    Filed under: .vb, ad hoc queries, ADO.NET, ASP.NET, Asp.Net 1.1, asp.NET objectdatasource selectmethod, Data Access, DataRow, DataSet, "return value"

  • How to update data returned using REF CURSOR

    Hi all, I am trying to update updated data in a gridview but the update button seem to do nothing as i retreive data using REF CURSOR. Let me describe the architecture of my application first. I'm trying to implement best practice whenever possible. I am following the data access tutorial published...
    Posted to Oracle (Forum) by imanour on 03-10-2008, 12:00 AM
    Filed under: Oracle, Oracle Package, Ref Cursors, VS.2005, .net 2.0, ado.net, c#, Using REF cusror with ADO.net, asp.net 2.0, dataset

  • How I fill my SqlDataAdapter..?

    Hi, I am using a SqlDataAdapter which is manually connected with the database. Now I am trying to fill a DataSet with some criteria and bind a DataList named listImage with that DataSet. My code given below : if (!IsPostBack) { this .sqlDataAdapter1.Fill(ds, 0, 6,"all_bags"); listImage.DataSource...
    Posted to Data Access and ObjectDataSource Control (Forum) by tapasmahata on 02-15-2008, 12:00 AM
    Filed under: DataAdapter, dataadapter.fill(), DataSet, ADO.NET

  • Need help with SQL Statement (combined SELECT and WHERE at same time)

    I am building a file repository page. For data source I use SQLDataSource and Repeater to display the categories. I am trying to achieve the result of displaying the following data: List of all "Main Categories" and all "Sub Categories" under each main category name. Also, "Total...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by alex3003 on 10-29-2007, 12:00 AM
    Filed under: object data source, objectdatasource, ObjectDataSource "rows returned", SqlCommand CommandBuilder, sqldataSource, Access DataSource in code-behind, ADO, ADO.NET, ADO.NET data access, ADO.NET data access, Data, data access, dataset, DataView SqlDataSource, asp .NET 2 datatable tableadapter, SQL Server ADO.NET Transactions

  • How to copy data from one excel file to other excel file

    Hi I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine. My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1. Advance...
    Posted to Enterprise Services Integration (Forum) by SudhaYogesh on 09-12-2007, 12:00 AM
    Filed under: postback variables, querystring, selection, sql, sqldatabase, t code behind, update, VB.Net, ado.net, asp, ASP.NET, Asp.Net 1.1, Asp.Net 2.0, Asp.Net 2.0 and MS SQL Server 2005, asp.net 2.0 asp.net, asp.net 2.0 export to excel, Asp.Net 2.0 session, ASP.net 2.0 Tutorials, ASP.NET Sites, ASP.NET.NET 2.0, c#, C# code, database, datareader, dataset, datasource, excel, GridView field, Asp.NET2.0, grid view, reports, DotNet, Find Control

  • Re: Ican't update my dataset

    here i post the code that i wrote i take the stage and depId from two textboxs and beging to excute the queries usin tabel adapter and put the desired result in arrayList then because the tableadpter StudentCourses1 can't up date the dataset as contain multiple table so i use table studentCourses...
    Posted to Data Access and ObjectDataSource Control (Forum) by semsem0 on 06-08-2007, 12:00 AM
    Filed under: Query, sql, C#, Data Access, DataSet, ADO.NET

  • Excel to Sql

    Hi Thnks for the time I was trying to figure out how to insert the data that I read from an excel sheet into multiple tables in SQL Database 2005. // Connection string to the excel file string excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source= D:\\UserData.xls;"...
    Posted to Data Access and ObjectDataSource Control (Forum) by Poise on 05-25-2007, 12:00 AM
    Filed under: ADO.NET, DataSet, Excel

  • Decode query does not take parameter!

    I am trying to use a Decode Query to define a DataTable method which looks like this: SELECT CDTS, '', '', '', LOC, NULL, DECODE(DTYPE, 'L', CONCAT(CONCAT(CONCAT('***** LOI MATCH:', LOI_DATA.NUM_1), ' ADDRESS: '), LOI_DATA.LOC), 'D', CONCAT('CLETS...
    Posted to Data Access and ObjectDataSource Control (Forum) by Chabo on 05-22-2007, 12:00 AM
    Filed under: outputparameter, Paramter, Performance : Stored Procedure with many params, Table Adapter, TableAdapter, TableAdapters, ADO.NET, ASP.NET, Asp.Net 2.0, DAL, Data, data Acces, Data Access, Data Access connections, data connections, data set, DataAdapter, Database, databind, DataGrid GridView Paging, DataSet, DataSource, Select, SQL Server ADO.NET Transactions

  • ADD NEW ROW TO A DATASET QUESTION..

    I am trying to insert a new column to a dataset with a date value from a sqlreader and my dataset is empty. The date string does have a value but it keeps not being added to my dataset..any suggestions? Dim r As SqlDataReader = cmd.ExecuteReader() Dim dt As New DataTable Dim dr As DataRow = dt.NewRow...
    Posted to Web Forms (Forum) by vicpal25 on 04-20-2007, 12:00 AM
    Filed under: ADO.NET, dataset

  • Saving listbox data - best approach?

    We have an ASP.NET 2.0 site that uses SQL Server 2000/2005. I am working on a page that updates our user table. But it will also update multiple related tables. For example, the user could be a member of several different companies and/or organizations and may have 1 to many roles out of a list of available...
    Posted to Data Access and ObjectDataSource Control (Forum) by nickpup on 04-19-2007, 12:00 AM
    Filed under: object data source, ObjectDataSource DataSet Multitable, passing object, sql, SQL Performance, Stored Procedures, VB.Net, ADO.NET, ASP.NET, Business Object, Data, Data Access, data set, DataAdapter, Database, databind, DataSet, DataTable, DataView SqlDataSource, design, SQL Server ADO.NET Transactions
Page 1 of 3 (29 items) 1 2 3 Next >

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.