Home ›
All Tags » sql » Data (RSS)

Browse by Tags

Related Posts

  • Re: Typed DataSet tool doesn't like temp tables!??

    I've found 2 possible solutions. 1.) temporarily change your stored procedure to select the columns you would like to see in the data table (what you see when you open the xsd file). Example: SELECT 0 as [CustomerID], 'some text' as [CustomerName] FROM Customer Comment out the SQL that created...
    Posted to Data Access and ObjectDataSource Control (Forum) by dotcarlisle on 10-13-2006, 12:00 AM
    Filed under: Data, sql, ADO.NET Tutorial, VB.Net

  • Multiple Filters & Mulitple Options

    First post, go easy on me. I have a table with 3 fields I need to filter with, ClientName(text), Status(text), LocationID(int32). I can create a where statement that filters all three, when there is a selection for each one. However, what I need is for the user to be able to pick and choose. Not having...
    Posted to Data Access and ObjectDataSource Control (Forum) by cush on 10-30-2006, 12:00 AM
    Filed under: Data, Help, SQL ASP OBJECTDATASOURCE, ObjectDataSource DataSet Multitable, sql, ADO.NET Tutorial, Data Access, Columns, Database

  • Re: Stored Procedures, Data Set and Data Table Adapters

    Swaino, If this helps you at all. When you use stored procedures you can benefit in several ways, including security and performance or making processes that require procedural action callable. Security because, for example, you may have a user that has read-only access to a table BUT, through a stored...
    Posted to Data Access and ObjectDataSource Control (Forum) by jrlopezp on 01-26-2007, 12:00 AM
    Filed under: Data, sql, ADO.NET Tutorial, DAL, SQL Server ADO.NET Transactions, ADO.NET, SQL Performance, SQL Security, Stored Procedures

  • Pull content from SQL based on url query string

    I am trying to pull content into a content page (within a master page) by using url query strings. I have got the code to pull the query string in and it is working fine. I am having trouble creating my sql Select Command using a variable. My sql Select Command works fine if I hard code it - I am just...
    Posted to Data Presentation Controls (Forum) by timwilson on 02-07-2007, 12:00 AM
    Filed under: database, sqldatasource, asp.net 2.0, datasource, data access layer, data, sql, VB, querystring, dataitem

  • problem with retrieving/displaying data based on form input

    Hi, I've developed a form which accesses a database through a data layer and sends parameters based on the form input. I have written the following code which works by checking if the textbox is empty and passing a null value as a string to the search parameter in the query, of which there are five:...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-22-2007, 12:00 AM
    Filed under: GridView, problem, string, database, sqldatasource, label, datasource, rows, records, If Statement, Null, GridView asp.net, data access layer, table adapter, databinding, data, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, Updateparameters, sql, search, VB, textbox, method, parameter, querystring, ADO.NET, access database, FORM, SELECT

  • Store Procedure vs. Trigger

    Hello guys, I want to log any changes made to table A into table B on insert/update (Table B is table A audit, Basically table B recoreds who changed what value in table A) I do Insert and Update on table A thru store procedure. Now which way is the best: Insert those new values into table B in the same...
    Posted to Data Access and ObjectDataSource Control (Forum) by Mehdi6002 on 03-07-2007, 12:00 AM
    Filed under: Data, sql, SQL Server ADO.NET Transactions, SQL Performance, Stored Procedures, Trigger

  • DataSet or Business Objects (IS ORM a better solution?)

    Hello guys, I am in doubt what solution is the best for a case that we have in hand. We have to develop a web application (ASP.NET 2 with loads of reports which I think we will use SSRS) and on this particular project there are about 100 tables involved. As you know we can add a DataSet for each table...
    Posted to Data Access and ObjectDataSource Control (Forum) by Mehdi6002 on 03-07-2007, 12:00 AM
    Filed under: Data, sql, Data Access, Database, DataSet, DataTable, data set, Data Set Binding, DataAdapter, Business Object, ORM

  • 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: Data, ObjectDataSource DataSet Multitable, sql, Data Access, Database, VB.Net, DataSet, SQL Server ADO.NET Transactions, DataTable, ADO.NET, design, DataView SqlDataSource, passing object, data set, object data source, SQL Performance, Stored Procedures, DataAdapter, Business Object, databind, ASP.NET

  • Re: Conditional repeating with Repeater. I want Repeter to add "CssClass='active'' to hyperlink when content of column "file" for curent field equals "string active"

    Is "IIF" function also in C#? There is the same problem with it. Server Error in '/Kamil Szmit (szmitek)' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify...
    Posted to Data Presentation Controls (Forum) by szmitek on 04-28-2007, 12:00 AM
    Filed under: css, asp.net 2.0, advanced, data, c#, sql, SELECT, ASP.NET, web controls, c# code, CssClass, IIF

  • Update Database structure after Strongly-Typed DataSet is built

    This is my first 3 tier application... I'm using a Stongly Typed Dataset as DAL. After everything was finished, I realized I had to make 2 changes to the database: 1- Add a new column 2- Change a SQL Data type from int to Bool What is the best way to update my Strongly Typed Dataset and make sure...
    Posted to Data Access and ObjectDataSource Control (Forum) by cunharubens on 06-09-2007, 12:00 AM
    Filed under: DAL, SQL, 3-tier architecture, Newbbie, DataTable.Select Method, dataset, Visual Studio 2005, Best Practice, C#, data, help me, newbie, beginner, OOP, xsd, DataSet DataTable TableAdapters, sql express
Page 1 of 2 (14 items) 1 2 Next >

Advertise on ASP.NET

About this Site