Browse by Tags

Related Posts

  • Re: Default value for a feild

    Hi, I think I know what you are asking, and my guess is that you may be trying to combine two parts of a solution into one . The default value for a column is a value set for every row in a table, until it is changed by entering another value. So that default value is stored in the database for each...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Brian27 on 11-20-2006, 12:00 AM
    Filed under: ASP.NET, Trigger, Database, Dynamic Data entry, Default value
  • Inserting a new record into sql db using user-entered information

    Im trying to add a new rcord to my db on a button click usign the following code 'data adapter Dim dAdapt1 As New SqlClient.SqlDataAdapter 'create a command object Dim objCommand As New SqlClient.SqlCommand 'command builder Dim builderT As SqlClient.SqlCommandBuilder 'connection string Dim cnStr As String...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rox163 on 11-22-2006, 12:00 AM
    Filed under: ASP.NET, Microsoft SQL Server 2005, Connection String, .NET SQL Server 2005, insert, SQL, Database
  • Calculate the total values of a column in a datagrid

    I'm working in VB, on my web form i have a datagrid with all the values that i need pulled from an sql database I need to total up all of the numerical values in a single column of my datagrid then inserted the answer in a textbox. Any help would be greatly appreciated Thanks Dazza22
    Posted to Data Presentation Controls (Forum) by Dazza22 on 12-05-2006, 12:00 AM
    Filed under: ASP.NET, Database Export, Database, SQL Server 2000, Datagrid
  • Image display in Reportviewer

    hi I developed a site to display information and this information include images using SQL Express and asp.net (C#), the pages works fine but to print i needed when I click print I wanted only the information and the Images to be printed. so I was adviced to use ReportViewer but I got stuck on 2 issues...
    Posted to SQL Server Reporting Services (Forum) by Yaslam on 12-12-2006, 12:00 AM
    Filed under: ASP.NET, Web Controls, database form, create web form, ASP.NET 2.0, Database, Web Forms, DataGrid, Reports, checkbox, Filtering across pages, Website design
  • Not getting any data

    Hello I am not really new to ASP.NET but I am building my first site at my new job. I just built the computer that I will be developing on. I have XP Pro, SQL server 2000, and visual studio 2005 with AJAx extensions. I created a web app and put a datagrid on the default.aspx page. I created a connection...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jgsteeler on 12-12-2006, 12:00 AM
    Filed under: table lookup, sql stored procedure, ASP.NET, .NET SQL Server 2000, Connnection String, Connection String, SQL, Database
  • sqlBulkCopyProblems

    I'm attempting to bulk copy delimited files into my MS SQL 2005 db. Some of the columns in the destination table are of type numeric. Consequently, SQL throws an InvalidOperationException when attempting to convert from a string to a decimal. Does any one know of a way to remedy this problem? Changing...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by em00guy on 12-27-2006, 12:00 AM
    Filed under: SqlBulkCopy, ASP.NET, .NET SQL Server 2005, Database, SQL 2005 ASP.NET, Dataset population problems, decimal, bulk, numeric, convert
  • Inserting Data into one table with category chosen from another table

    Hi, I am a novice programmer. I have this problem and can't seem to find an answer to my problem. I have two tables, an artist and a category table. the artist table have the following fields, name, artist_id and cat_id, and my category table have the following fields, cat_id and category_name . Both...
    Posted to Data Presentation Controls (Forum) by RuanRossouw on 01-06-2007, 12:00 AM
    Filed under: ASP.NET, Visual Web Express, inserting data, dropdownlist, database, multiple tables, bind
  • sql server membership accounts and another database.

    Hi, I hope this is in the correct category. I have two .mdf files. aspnetdb.mdf and emotiveonline.mdf. My host provider can only give me one database in sql server express 2005. Now I am no genius when it comes to programming and that kind of stuff but those two mdf files would be seen as 2 databases...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by RuanRossouw on 01-17-2007, 12:00 AM
    Filed under: SQL Server 2005, ASP.NET, Table Export, Vwd 2005, Database Export, Microsoft SQL Server 2005, .NET SQL Server 2005, ASPNETDB asp.net bug problems database spy, Database, SQL 2005 ASP.NET, Roles, Profiles
  • Fileupload and Database and url's

    Hi, I am a novice programmer. Doing this merely for fun as I am actually in the finances sector. I am hope you guys/ladies can help me. I have a fileupload control on one of my pages to upload pictures. It works perfectly. I do want to save some of the data, like the title and description, into a database...
    Posted to Web Forms (Forum) by RuanRossouw on 01-20-2007, 12:00 AM
    Filed under: data, data source, ASP.NET, Visual Web Express, inserting data, database, bind
  • Using declared variables in SQL INSERT statement.

    I am new to scripting in general and I've run into an issue when attempting to write a VB variable to a database table in SQL Express. I am trying to record the value of the variable to the db, but it does not appear that the value is being passed to SQL. If I hard code the values in the SQL statement...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by agolia on 02-03-2007, 12:00 AM
    Filed under: data source, ASP.NET, Visual Web Express, inserting data, database
Page 1 of 8 (76 items) 1 2 3 4 5 Next > ... Last ยป