Home ›
All Tags » sql » C# (RSS)

Browse by Tags

Related Posts

  • Need to list the Stored Procedure's parameter list in the same order through C#

    Hi, I have a requirement like, to display all the SPs in a dropdown. On choosing one SP, i need to read that SP's parameters and display in the same order as how the SP contains. I could read the SP params through, sqlQueryForSPDetails = " select s.id , s.name as [Name], t.name as [Type], t...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by aravind.pk on 04-29-2009, 12:00 AM
    Filed under: SQL, stored procedure, c#

  • BETWEEN and WHEN function in VS 08 (ASP.NET C#)

    Hi everyone, I'm having difficulty coding an SQL statement needs some form of an IF Clause in it, so that, depending on the value it is referring to, searches within a certain range. The value that it is referring is one of which is user defined from a drop-down-list which is then passed on to the...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by dt86uk on 04-22-2009, 12:00 AM
    Filed under: SQL, BETWEEN, c#, IF LOGIC, where, ASP.NET

  • Use Session Variable in Sql Select statement. - Using C#

    if (!IsPostBack) { if (Session["SessionUserID"] != null) { string SessionName = Session["SessionUserID"].ToString(); // Declare the query string. String queryString = ( "SELECT [LoginName], [UniqueID], [GroupName], [AutoAcceptPayment], [ShowUserControlPanel], [PreferredPayType...
    Posted to State Management (Forum) by SubsonicRecordPool on 04-12-2009, 12:00 AM
    Filed under: session variable, SQL, c#

  • Cant get a data

    Hi, all Not much to explain I write this code and I dont get data (if I run the query in the DB it works) 1 private void ShowFullView(String strFullViewName) 2 { 3 OleDbCommand command = new OleDbCommand( "SELECT sCat_Code " + 4 "FROM CATEGORIES_TAB " + 5 "WHERE sName = '...
    Posted to Access Databases and AccessDataSource Control (Forum) by SweeT EviL on 04-10-2009, 12:00 AM
    Filed under: sql, sql queries, sql Statements, access, Access Database, Access db, asp.net, c#, connection string, ConnectionString, data access, DataAdapter

  • OdbcCommands usage

    Heloes again asp.net community! On lack of a better section I'm posting this under webforms section - if not applyable please move it at will - it is authentication related but more of a database connection problem. So I have this piece of code: //select pwd do dado user cmd = new OdbcCommand("SELECT...
    Posted to Other Databases (Forum) by voliveira on 03-25-2009, 12:00 AM
    Filed under: odbc, sql, Authentication, c#

  • need help: how can i write this code in framework 3.5

    ok, i understand how to do this: [CODE] public class Fetch { private SqlConnection sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["DataConnectionString"]); public DataSet ContactsList() { try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlConn; sqlCmd.CommandText...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Arsalan03 on 02-13-2009, 12:00 AM
    Filed under: SQL, sqlconnection, .NET 2.0, 2008, c#, .net 3.5

  • check username availability using ajax

    Hi guys, I am trying to get a little ajax script working on my site that allows me to check for the availability of a username using an ajax call on my sql database. The code I have below works but it doesn't give me the result value from the webmethod class. I tested my sql statement and that does...
    Posted to ASP.NET AJAX Networking and Web Services (Forum) by Onimusha_kiyoko on 01-25-2009, 12:00 AM
    Filed under: ajax, c#, sql

  • DataBinding: 'System.Data.DataRowView' does not contain a property with the name '1'.

    the error: DataBinding: 'System.Data.DataRowView' does not contain a property with the name '1'. my case: getting this error when deleting a row from gridview and reloading the gridview with the changes using a single stored proc to delete and select.. dataset contains column names and...
    Posted to Access Databases and AccessDataSource Control (Forum) by snet on 01-09-2009, 12:00 AM
    Filed under: sql, stored procedure, visual studio, ASP.NET 2.0, c#, DataSet, Gridview Data Sources, .ASPX, GridView

  • How to populate a table from a CSV File

    Using SQL Server 2005 Standard, Visual Studio 2008 Profession, ASP.NET 3.5, C#, ASP.NET AJAX. System Configuration: Web Server is a Virtual Server, Database Resides on a different server, also a Virtual Server (VMWare). I need users to be able to upload a file from their LOCAL machine. This file will...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-30-2008, 12:00 AM
    Filed under: ObjectleDbDataReader, odbc, oldedb, sql, SQL 2005, SQL Data Adapter, SQL Datasets, sql server 2005, sql server 2005 stored procedure, SQL Server Stored Procedures, sql serverver reports, SQL TransactSQL Randomize Function, SqlDataAdapter, sqldatasource, SqlParameter, sqlreader, SQL-Server, stored procedure, stored Procedures, stringbuilder, Strongly Typed Datasets, strored procedures, table, table adapter, tables, Thanks, Thanks in Advace, Thanx, to a sql server database and how to retrive them, UPDATE, updating, Urgent Help needed, .NET 3.5, 2 column text field, add data, adding data, ADO.NET, ADO.NET 2.0, advanced, as.net 3.5, asp, 'ASP', asp .net 2.0, asp .net code, ASP .net.NET, ASP .net.NET Grid View, asp sql query customize datalist, ASP>NET, ASP.NET, asp.net c# sqlserver 2005 dataadapter querystring date comparison, asp.net 2.0 c#, asp.net 2.0 with c#, ASP.Net 3.5, c#, 'C#', C# 2005, c# code, c#.net, data, data access, data access layer, data entry, Data list, data mapping layer, data presentation, data repeater control, Data Set, data source, data tables, Dataa access, Excel to Sql-Server C# ASP.Net 2.0, fields, file upload, fileupload, insert, insert command, insert database sql, Insert new records, insert parameter value, insertion, InsertMode, LINQ Dynamic Data, LINQ SQL-to-LINQ DataGrid DetailsView, linq textbox query, LinqDataSource Linq, linq, ASP.NET3.5, ASP .net.net2, asp .net.net2.0, asp .net2.0, vs2008, SP, ASP .net ... c#, ASP .net ... c# ., asp .net ... c# ... SQL javascrpt, ASP .net ... c# 3.5, upload file, ASPNET SQL Server, excel C#, Sql Server, sqll, VS 2008, adding table data, ado.net designer dataset datatable datatableadapter designview gridview webforms bug, asp.net 2.0, C#. NET 2005, C#3.0, Data table, document, insert select, insert values, ASP .net ... c# ... javascript

  • 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
Page 1 of 8 (72 items) 1 2 3 4 5 Next > ... Last »

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.