Search Results

Search found 484 results on 20 pages for 'sqlcommand'.

Page 11/20 | < Previous Page | 7 8 9 10 11 12 13 14 15 16 17 18  | Next Page >

• Database Programming in C#, returning output from Stored Proc

  - by jpavlov

  I am working at gaining an understanding at how to interface stored procedures with applications. My example is simple, but it doesn't display my columns and rows in the command prompt, instead it display System.Data.SqlClient.SqlDataReader. How do I display the rows from my stored procudure? ----Stored Proc-- ALTER PROCEDURE dbo.SelectID AS…

  Read the article

• Using block around a static/singleton resource reference

  - by byte

  This is interesting (to me anyway), and I'd like to see if anyone has a good answer and explanation for this behavior. Say you have a singleton database object (or static database object), and you have it stored in a class Foo. public class Foo { public static SqlConnection DBConn = new…

  Read the article

• Assigning values to the lable through database depending on listbox values

  - by SurajVitekar

  I want to assign the values of five labels from database regarding to values selected in listbox. The db query returns single column with multiple records. Please help. I'm working with C# 2010 and MS SQL. My current code is: private void listBox1_SelectedIndexChanged(object sender,…

  Read the article

• Store multiple values in a session variable

  - by user458790

  Hi, Before I ask my doubt, please consider this scenario that a user on my website have a profileID. With this profileID are associated some pluginID's. For eg: User1 might have 2, 3 and 5 plugins associated with its profile. When the user logs in, I store the profileID of the user…

  Read the article

• please help me for performing serch in my program

  - by Abid

  i want to perform searching in my programe.. i have my class in which i have made a function i.e. public DataTable Search() { string SQL = "Select * from Customer where " + mField + " like '%" + mValue + "%'"; DataTable dt = new DataTable(); …

  Read the article

• C# SQL Data Adapter Fill on existing typed Dataset

  - by René

  I have an option to choose between local based data storing (xml file) or SQL Server based. I already created a long time ago a typed dataset for my application to save data local in the xml file. Now, I have a bool that changes between Server based version and local version. If…

  Read the article

• How can i pull an image and data from a Database?

  - by user1851377

  I am trying to pull data from a Database using C#.net and use a Foreach loop to make it visible on a page. Every time i run the code i only get one item that shows up when i know that there is at least 7 items in the DB. i have placed the code below for the C#. SqlConnection…

  Read the article

• Error in My Add button SQL Server Management Studio And Visual Basic 2010

  - by user2882523

  Here is the thing i cant use insert querry in my code there is an error in my sqlcommand that says the ExecuteNonQuery() not match with the values blah blah here is my code Dim con As New SqlClient.SqlConnection("Server=.\SQLExpress;AttachDBFilename=C:\Program…

  Read the article

• Stored procedure or function expects parameter which is not supplied

  - by user2920046

  I am trying to insert data into a SQL Server database by calling a stored procedure, but I am getting the error Procedure or function 'SHOWuser' expects parameter '@userID', which was not supplied. My stored procedure is called "SHOWuser". I have checked…

  Read the article

• Get Multiple Values From Database ASP.NET/C#

  - by user1043177

  I am trying to get/return multiple values from an SQL-Server database using and display them on an ASP.NET page. I am using a stored procedure to perform the SELECT command on the Database side. I am able to return the first value that matches the variable…

  Read the article

• upload new file first check if this file exist already in database or not then if not exist save that in database

  - by Hala Qaseam

  I'm trying to create sql database that contains Image Id (int) Imagename (varchar(50)) Image (image) and in aspx write in upload button this code: protected void btnUpload_Click(object sender, EventArgs e) { //Condition to check if the file uploaded…

  Read the article

• ( Sql Server 2005 C#.Net ) - I want just the insert query for a temp table.

  - by John Stephen

  Hi..I am using C#.Net and Sql Server ( Windows Application ). I had created a temporary table. When a button is clicked, temporary table (#tmp_emp_details) is created. I am having another button called "insert Values" and also 5 textboxes. The values that…

  Read the article

• Is this method a good aproach to get SQL values from C#?

  - by MadBoy

  I have this little method that i use to get stuff from SQL. I either call it with varSearch = "" or varSearch = "something". I would like to know if having method written this way is best or would it be better to split it into two methods (by overloading),…

  Read the article

• Value is zero after filter SQL in C#

  - by Chuki2

  I`m new in C#.. I have write function to filter department. And this function will return idDepartment. New problem is, department keep value "System.Windows.Forms.Label, Text : ADMIN ", that`s why i got zero. So how can i take "ADMIN" only and keep to…

  Read the article

• Code Keeps Timing Out

  - by DForck42

  So, we've got this set of code that, for some reason, keeps timing out. It's not the stored procedure that it's running, because that runs fine. Also, if we remove the parameter from the c# code, the code runs. The parameter keeps breaking (causing it…

  Read the article

• C# SQL Parameter Errors in Loops

  - by jakesankey

  Please help me out with this. I have this small application to load txt files into a sql db and it works fine with sqlite. When I ported to SQL I started getting 'parameter already declared' errors.. If anyone can help me reorganize this code, it would…

  Read the article

• SQL error C# - Parameter already defined

  - by jakesankey

  Hey there. I have a c# application that parses txt files and imports the data from them into a sql db. I was using sqlite and am now working on porting it to sql server. It was working fine with sqlite but now with sql i am getting an error when it is…

  Read the article

• Bulk inserting best way to about it? + Helping me understand fully what I found so far

  - by chobo2

  Hi So I saw this post here and read it and it seems like bulk copy might be the way to go. http://stackoverflow.com/questions/682015/whats-the-best-way-to-bulk-database-inserts-from-c I still have some questions and want to know how things…

  Read the article

• ASP.NET Podcast Show #148 - ASP.NET WebForms to build a Mobile Web Application

  - by Wallym

  Check the podcast site for the original url. This is the video and source code for an ASP.NET WebForms app that I wrote that is optimized for the iPhone and mobile environments.  Subscribe to everything. Subscribe to WMV. Subscribe…

  Read the article

• data source does not support server-side data paging uisng asp.net Csharp

  - by Aamir Hasan

  Yesterday some one mail me and ask about data source does not support server side data paging.So i write the the solution here please if you have got this problem read this article and see the example code this will help you a Lot.The…

  Read the article

• How to deal with transactions when creating a database connection for each query

  - by webnoob

  In line with this post here I am going to change my website to create a connection per query to take advantage of .NET's connection pooling. With this in mind, I don't know how I should deal with transactions. At the moment I do something…

  Read the article

• how to enable SQL Application Role via Entity Framework

  - by Ehsan Farahani

  I'm now developing big government application with entity framework. at first i have one problem about enable SQL application role. with ado.net I'm using below code: SqlCommand cmd = new SqlCommand("sys.sp_setapprole"); …

  Read the article

• Stored Procedure call with parameters in ASP.NET MVC

  - by cc0

  I have a working controller for another stored procedure in the database, but I am trying to test another. When I request the URL; http://host.com/Map?minLat=0&maxLat=50&minLng=0&maxLng=50 I get the following…

  Read the article

• How to use SQL file streaming win32 API and support WCF streaming

  - by Mahesh

  I'm using Sql server file stream type to store large files in the backend. I'm trying to use WCf to stream the file across to the clients. I'm able to get the handle to the file using SQLFileStream (API). I then try to return…

  Read the article

• How to Resolve Jason issue

  - by Mohammad Nezhad

  I am working in a web scheduling application which uses DayPilot component I started by reading the documentation and use the calendar control. but whenever I do some thing which (fires an event on the Daypilot control) I face…

  Read the article

< Previous Page | 7 8 9 10 11 12 13 14 15 16 17 18  | Next Page >