Browse by Tags

Related Posts

  • some question

    Hi, I am creating a web services which insert and update one of the company database table call customer. i want to ask that for this method: public DataSet insertCustomer( String CustomerID, String FirstName, String LastName, String Email) { conn = dbCon.getConnection(); DataSet custData = new DataSet...
    Posted to XML Web Services (Forum) by zoaka on 01-07-2009, 12:00 AM
    Filed under: Web Service DataTable, Web service in C#.net, web service namespaces class name, Web Service reference, C#, database, insert, Web Services, webservice, webservices, web Service namespace dynamic, database access using webservices, WEb Service, C# webService
  • Upload Excel File to SQL Server 2005 and Retrieve as link

    I want users to be able to upload an Excel file using the ASP.NET File Upload Control, have the file saved into a database table (which I have not created yet), and later on, based on an ID assigned to the file, retrieve it as a hyper link that when they click on it will open the file for them. I have...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-19-2008, 12:00 AM
    Filed under: slq 2005, Slq Server, SQL, SQL 2005 SQL, Sql 2005 .NET, SQL 2005 ASP.NET, SQL Database design, SQL Server 2005, SQLL Serverr DTS, SQLServer, sqlserver 2005, SQLServer 2005SP2, sqLserver2005, sqlserverver, System.Array, varbinary, Visual Studio 2008, Visual Studio 2008 SP1, Web Project, "T-SQL", .NET 2.0, 2005, 2008, ADO.NET, asp.net 3.5, binary data, BLOB, c#, C# SQL, complex, convert, Data, data Acces, data access, data source, data storage, Database, DTS, DTS package, File Upload, files, LINQ Statement, LINQ toSQL, .NET SQL Server 2005, SQL 2005, SQL datatable, SQLServere2005, "SQL Server", .net 3.5, Linq, Store File to database, Stored procedures, ASP.NET C# sql, CSV, cvs, Data Type
  • Need foreach functionality in Stored Procedure

    I have a stored proceudre that brings back 6 columns (PART, FSC, NIIN, NAME, TotalQty, ReqID). After the SELECT statement has run, I need to update one of my tables. In the table that I need to update, there is a column named ReqStatus, and this tables PK is ReqID (from above SELECT statement). Fore...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-05-2008, 12:00 AM
    Filed under: query, query?, slq 2005, Slq Server, SQL, SQL 2005 SQL, sql server, SQL Server 2005, sql server update, sql 2005, SQL Server 2005, Stored procedure sql, Stored Procedure update / insert, stored procedure variables, stored procedure variables WHERE clause, stored proceduredure sql, stored proceduree, Stored procedures, StoredProcedure, StoreProcedure, UPDATE, update column, Update SQL Statement, update statement, "T-SQL", "User Defined Function", 2005, asp.net c# profiles sql server, ASP.NET C# sql, c#, C# SQL, column attributes, column name, column name query, Data, Database, HAVING, "Dynamic SQL", For Each Loops, for loop, queries, SQL 2005, SqL For Each Loops, update records, "SQL Server", .net 3.5, db
  • Combine 3 tables to one gridview with Select Count

    I have 3 tables that i am trying to join to create one gridview that shows a detailed count of different items. My gridview works fine when it only joins two tables but when i add the third table it throws my counts completely off here is my code. If you have any suggestions on how to work this please...
    Posted to Data Access and ObjectDataSource Control (Forum) by cgreene.gsu on 10-16-2008, 12:00 AM
    Filed under: Paramter, sql, SQL Query, sql reader, sqlclient, Sqlconnection, .net 2.0 c#, 2.0, asp 2.0, C#, Columns, data Acces, Data Access, Data Access ASP.net vs. ASP, Database, DataColumn, datatable full join, dataTable join, Gridview - dataset, joins, database connection, Gridview DataGrid, codebehind
  • Binding data to objects in a form

    Hello all, I'm working on what should be a simple web application in C#.NET and I'm having some noobie trouble with data. I basic need is to populate a hidden text box with data from a database (called availableDownloads) and depending on whether a cookie exists or not, the value in the availableDownloads...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Deucallion on 10-13-2008, 12:00 AM
    Filed under: asp .NET 2.0, attach database on the fly, c#, C# SQL, Data, data access, data access insert mssql, Data set, Database, DataBind, Databinding, dataset, datasource, ASP .NET 2
  • Dynamic LINQ Objects

    I have spent quite some time Googling and looking around for anything relatively related to my subject, and have found very little. My scenario is this: I want to use LINQ in a web application, BUT I need the ability to dynamically create a Data Context, I believe it's called? The .dbml file that...
    Posted to Data Access and ObjectDataSource Control (Forum) by JMoore5268 on 09-17-2008, 12:00 AM
    Filed under: Query, sql, Visual Studio 2008, "Linq to Sql" LinqDataSource, .NET 3.5 SP1, asp.NET 3.5, asp.net 3.5 Linq, C#, data Acces, Data Access, Database, dynamic LINQ, LINQ in Action, Linq query, LINQ SQL Dynamic predicate builder, Linq to SQL, LinqDataSource, database connection, Linq, linq ado, LINQ databasecontext dbml, LINQ databasecontext dbml System, 3.5, Data Access connections, Data Access Application block, linq databasecontext
  • What to use in my situation?

    Hello, I am having a hard time deciding what will work or not for my website as far as a login and memberhip system goes. I have a File System based website designed, and now I need to add a mambership system to it. I need it to have roles, login and logout capabilites, profile spicific data-storage...
    Posted to Security (Forum) by kjkramer1219 on 07-13-2008, 12:00 AM
    Filed under: Profiles, security, sql 2005 asp.net membership, SQL express, user, ASP.NET 3.5, C#, database, membership role, MembershipProvider, database login sql sign up sign in roles user management access rules, Membership account, membership authentication, roles, login
  • Google Maps via ASP.NET / SQL Server Tutorial

    Hi, I worked out for google map with ASP.Net / VB.Net. below steps you have to follow, 1. You need to get encrpyted key from google which key for your own website. 2. create a table as below, if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[map]') and OBJECTPROPERTY(id, N'IsUserTable'...
    Posted to Tips & Tricks (Forum) by antonyvijayan on 07-08-2008, 12:00 AM
    Filed under: SQL, User control, .net, .NET Answers, .NET applet, .Net Faqs, .net interview faqs, .NET Interview Question, Abstract class, Access, ADO.Net, Ajax xml-script Tabstrip, asp, Asp .net, asp.NET 1.1, asp.NET 2.0, ASP.NET AJAX, ASP.NET TextBox Javascript MultiLine MaxLength, aspose.newsletter, c#, class, Code sample, Code sample sql script countries country province Provinces server 2000, code snippets, daily Free Code, Database, email, FAQ, .net layered design, asp .net ... c# ... SQL, structure, .Net FAQ Links, ASP.NET
  • Insert record into sql database express when button pressed

    I'm new to asp.net and I have gotten quite far with books and such but I'm stuck at this point. I have a web form that is mostly populated with data pulled from AD and all the user does is make a selection in two drop lists and enter their initials to sign. I can't figure out how to insert...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Medros on 04-30-2008, 12:00 AM
    Filed under: sql express, .NET 2.0, c#, data source, Database, insert
  • Re: mysql 'latin5_turkish_ci' error

    In asp code, i solutate Turkish character error same this code. But i can't do this in asp .net. How can i do it. { Set bag = Server.CreateObject("ADODB.Connection") bag.Open "Driver={MySql ODBC 3.51 Driver}; Server=localhost; uid=root; pwd=123456; database=deneme; option=3; port=3306;"...
    Posted to MySQL (Forum) by senol on 03-12-2008, 12:00 AM
    Filed under: mssql, MySQL 4.1, mysql 5.0, asp.net, ASP.NET 2.0, ASP.NET Membership, C#, connect to, connect to MySQL on remote PC, Connection, Connection with MySQL Database from ASP.NET 2.0, database, db, error, file, mysql.dll, MySQL.NET connector on Medium Trust Level, MySqlClient, aspnet
Page 1 of 6 (55 items) 1 2 3 4 5 Next > ... Last ยป