Browse by Tags

Related Posts

  • Insert into Access Db functions with Error - No value given for one or more required parameters.

    Hey all, Have a little problem with my web form application, have really tried everything, noticed there was an abundance of solved technical problems here, so I thought I would post up to see if anyone is able to provide a solution. This simple web form written in VB.NET has something strange going...
    Posted to Access Databases and AccessDataSource Control (Forum) by razzleb on 03-03-2009, 12:00 AM
    Filed under: vb.net, access oledb, DataAdapter, DataSets, access 2007 strings SQL
  • Re: How to join more than two DataTables into one DataTable?

    Thank you again Lolli. Do you mean Add Query... ? If I will add query to the DesignationTableAdapter ... this warning... will prompt. If I will make that query... [quote user="Lolli"] SELECT Employees.EmployeeID, Employees.EmployeeName, Branches.BranchID, Branches.BranchName FROM Employees...
    Posted to Data Access and ObjectDataSource Control (Forum) by van.net on 11-05-2008, 12:00 AM
    Filed under: Typed dataset, VB.Net, .net 2.0, Data Access, DataAdapter, DataColumn, DataReader, DataRelation, DataRow, DataSet, DataTable, XML Schema Definition, VB.NET 2005
  • How to join more than two DataTables into one DataTable?

    Hi, I am using .NET 2.0 and new in developing a web application. This is the first time I use Typed DataSet or XML Schema Definition in accessing data. The three DataTable s that I want to join into one DataTable : Employees EmployeeID EmployeeName 1 Steve Nash 2 Jason Kidd 3 Kobe Bryant 4 Tony Parker...
    Posted to Data Access and ObjectDataSource Control (Forum) by van.net on 11-05-2008, 12:00 AM
    Filed under: Typed dataset, VB.Net, .net 2.0, Data Access, DataAdapter, DataColumn, DataReader, DataRelation, DataRow, DataSet, DataTable, XML Schema Definition, VB.NET 2005
  • How to join more than 2 DataTables into a single DataTable?

    Hi, I am using .NET 2.0 and new in developing a web application. This is the first time I use Typed DataSet or XML Schema Definition in accessing data. The three DataTable s that I want to join into one DataTable : Employees EmployeeID EmployeeName 1 Steve Nash 2 Jason Kidd 3 Kobe Bryant 4 Tony Parker...
    Posted to Data Access and ObjectDataSource Control (Forum) by van.net on 11-05-2008, 12:00 AM
    Filed under: Typed dataset, VB.Net, .net 2.0, Data Access, DataAdapter, DataColumn, DataReader, DataRelation, DataRow, DataSet, DataTable, XML Schema Definition, VB.NET 2005
  • HELP!

    Hi Everyone, I'm new to ASP.NET and I am kind of stuck with a project that I am working on. I have 2 tables in my Access db, tblQuestions and tblResponses. For every question in the tblQuestions table, there are multiple responses. How do I pull the question's and include only the responses that...
    Posted to Data Access and ObjectDataSource Control (Forum) by LatinoKid on 05-24-2007, 12:00 AM
    Filed under: VB.Net, ASP.NET, Asp.Net 2.0, data set, DataAdapter, databind, Any help on ADO.NET 2.0 MARS feature
  • Accessing a datatable

    I have created a dataset with a datatable by the name of Test: 'Instantiates my data access class DA = New DataAccess ( strConnString , "Win", " TestApp ") Dim dstTrust As New DataSet 'Populates the datatable with the result of my stored procedure DA .FillDataset(dstTrust, "cset_test_sp", "Test") What...
    Posted to Data Access and ObjectDataSource Control (Forum) by adammillsy on 04-27-2007, 12:00 AM
    Filed under: Stored Procedures, Table Adapter, VB.Net, Asp.Net 2.0, data set, Data Set Binding, DataAdapter, DataSet, DataTable
  • Table Adapter

    I am having trouble getting my head around the tableadapter class. I have a dataset that is opened and populated within code, however all the examples I see use a wizard to create the tableadapter by connecting to a dataset in the IDE. How/where do I implement a tableadapter in code? Dataset is created...
    Posted to Data Access and ObjectDataSource Control (Forum) by adammillsy on 04-20-2007, 12:00 AM
    Filed under: SQL ASP OBJECTDATASOURCE, Table Adapter, TableAdapter, TableAdapters, tableAdapters scope_identity dal, Typed dataset, update, VB.Net, ADO.NET, data Acces, DataAdapter
  • 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
  • How to retrieve data as XML from SQL database

    Hi, I have a website which is designed to search for employee information. I have the search system working which does exactly what I want to, but as an added feature I want there to be a button which, when someone clicks on it, it takes whatever the previous search was and generates a set of data in...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by tomosap on 02-28-2007, 12:00 AM
    Filed under: object data source, objectdatasource, parameter datatype, Stored Procedures, Table Adapter, TableAdapter, TableAdapters, VB.Net, ADO.NET, Columns, combining data sources, DAL, Data, Data Access, DataAdapter, Database, DataGrid GridView Paging, DataSet, DataTable, DataView SqlDataSource, DropDownList, XML, Gridview
  • Re: How to join more than 2 DataTables into a single DataTable?

    Thank you Gabriel. Do you mean like this? Note: I add a new DataTable DesignationInfo with DataAdapter DesignationInfoTableAdapter .
    Posted to Data Access and ObjectDataSource Control (Forum) by van.net on 11-05-2008, 12:00 AM
    Filed under: Typed dataset, VB.Net, .net 2.0, Data Access, DataAdapter, DataColumn, DataReader, DataRelation, DataRow, DataSet, DataTable, XML Schema Definition, VB.NET 2005
Page 1 of 2 (11 items) 1 2 Next >
Microsoft Communities