Browse by Tags

Related Posts

  • 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
  • setting empty text box input on form to null parameter for sql

    Hi, I'm pretty new to ASP.NET and VB, but I'm working on a project which is essentially a staff directory. Using VS 2005, I've setup a basic grid view which connects to an object which connects via a data layer to a SQL database with Name, Surname, Email, Extension No and Department fields. I have it...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-19-2007, 12:00 AM
    Filed under: dataview, string, database, sqldatasource, rows, If Statement, Null, data access layer, specific record, table adapter, mysql, sql, VB, textbox, datatagrid navigarion paging style, FORM, SELECT
  • 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
  • How to Membership and Login in SQL?

    I have a two problems. First is connecting to my sql server 2005 express with my sql account. Every time i try to configure data source to connect to my db on server using my windows auth. it works and when i try using my sql account i get error, User is not associated with a secure SQL Server connection...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mzmiric5 on 03-14-2007, 12:00 AM
    Filed under: c#, ASP.NET 2.0, www, asp.NET 2.0 C#, Database, ADO.NET, SQLDataSource, data access, aspx, .net, datasource, data binding, Asp .net, Beginner, Vista, data access validation
  • ConnectionStrings prefix problem

    I am building a Web Application Project with Visual Studio 2005. On one page, I added a SqlDataSource with a connectionstring. The problem is as follows: I get the warning "Generation of designer file failed: The expression prefix 'ConnectionStrings' was not recognized. Please correct the prefix or register...
    Posted to Data Access and ObjectDataSource Control (Forum) by Heleboel on 03-21-2007, 12:00 AM
    Filed under: Web Application Project, web.config, ConnectionStrings, sqldatasource, database
  • There's always an easier way.

    Hello All, Right now I am getting ready to write an onSubmit handler. In the event handler, I would like to write a function that: - validate some information in a text box Should be 'RO' + 6 numbers(ex. RO152465) - builds a SQL query based on checkboxes selected and then the values that are in the drop...
    Posted to Web Forms (Forum) by dohertyk on 04-24-2007, 12:00 AM
    Filed under: event validation, TextBox, ASP.NET, form, radio button, DropDownList, submit, "Asynchronous Operation", <%@ Page Language="VB" %>, ASP.NET 2.0, codebehind, View, Database, Validators, DataGrid, event, ASP.NET 2.0 VB.NET, ASP.NET 2.0 IIS, SQLDataSource, visual studio, validation, IIS, validate, aspx, .net, ASP.NET 2.0 webform, Valdiation Controls, ASP.NET 2.0 Ajax Control Toolkit Ajax Tab Control, asp, Webforms, Beginner, dropDownList radiobuttonlist, events, event handlin, vb.net, CustomValidator, Button Event OnClick, validation Controls, SQL SERVER, 2.0
  • SQLDataSource - specific data base owner

    Is there a way to get VS2005 designer to use a different database owner instead of dbo? We have a SQL 2000 database that was created with a specific user as the database owner, rather than dbo. In all of the old SQL procs the tables must all be referenced as user.tablename rather than just tablename...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by AspGuyNewToDotNet on 07-24-2007, 12:00 AM
    Filed under: .Net 2.0, SQL Server 2000, database, SQL Server 2005, Dataset database connection DataAdapter Dbconnection, Data Controls ADO, sqldataSource, DataSet DataTable TableAdapters, SQL SERVER, ADO.NET
  • What are your thoughts?

    For intranet development, our DBAs are asking web developers to use fixed domain NT ID accounts instead of SQL accounts to connect to backend databases in all web applications. We are: Windows XP workstations in a 2003 Active Directory Topology. I don’t think that this is a good idea (I could say more...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wfudge on 08-20-2007, 12:00 AM
    Filed under: ASP.NET, ASP.Net 2.0 Login Control, Asp.Net 1.1, asp, ASP.net 2.0 Tutorials, .Net FAQ Links, asp.NET 2.0 asp.net control template referencing codebehind findcontrol, Asp.NET2.0, ado.net faq, ado.net, datareader, sqldatasource, database, datasource, Asp.Net 2.0 and MS SQL Server 2005, sqldatabase
  • Editing Underlying boolean data without making cells Editable

    I'm having a real hard time coming up with a solution to this problem. I created a custom gridview control from Dino Esposito's "Extending Gridview" article which autogenerates a checkbox column that allows for multiple record selection. Once a user checks a box, the entire row gets...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by elaw on 10-05-2007, 12:00 AM
    Filed under: Database, c#, sqldataSource, gridview, ASP.NET 2.0 Data Binding SQl Server 2005 ASP, Dynamic Query, data source, data access, column attributes, asp.net 2.0
  • User Instances on qsh.eu

    Hi. I am trying to connect to a database but keep encountering the same error. I have a free hosting account with quantasoft (qsh.eu) who fully support SQL express user instances. I have also used the connection string generator on their site. This is the result of the error. Cannot create file 'H...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by briggins5 on 11-10-2007, 12:00 AM
    Filed under: Microsoft SQL Server 2005, Database, sql 2000 "sql server express 2005", sql 2005, sqldataSource, MSSQL, Sql 2005 .NET, SQLServer, ASP .NET 2, dataset, user, SqlDataSource Repeater, "MSSQL error"
Page 1 of 2 (13 items) 1 2 Next >