Search results for query: *

This is my stored procedure and it gives the following error, I'm new to sql server stored procs so I'm sure its some basic error... Incorrect syntax near the keyword 'IDENTITY'.Procedure(InsITRRComments) CREATE PROCEDURE dbo.InsITRRComments @CommentId int IDENTITY, @DacType...

I have an application that reads data from a database, wraps the data in html table tags and then sent as an email to myself. My problem is as follows. I have set the email format to be html so when I open the email I should see the data in a nice table format. That does not happen however. The...

1. I'm querying a database that brings back rows of data 2. I wrap the data in html so it has a table structure Q. What I want to do is send the table in the body of an email .... I'm gona google it but any suggestions before that would be great

The following query wont work because GO needs to be on a separate line, is there a way I can force a new line in there. I can use a stored proc because I am joining a few tables together.... I want to force sql server to treat SET ANSI_NULLS OFF GO SELECT.... on separate lines SET ANSI_NULLS...

I have the following problem. I am trying to execute a rather complex sql statement. The first sql statement below returns the desired rows, the second one wont return anything. Both sql statements work perfectly when run from the database. I dont understand why the second sql says that nothing...

I am calling a method inside a for loop and the problem is that the method calls another method. There is nothing wrong with the method if its called as a one off, it works fine but inside the loop the page just hangs. The loop is going to iterate about 1300 times and the method called calls...

is there a simple way to connect to a sql server database from a simple c# application. I want to return the rows to a dataset. What i have researched so far is confusing... a code sample would be great

I have this web.config file and I have added a key value describing the connecting string to a db. I'm wondering whats the easiest way to read the value of the connection string from the web.config file, c# is the language i'm using. <?xml version="1.0" encoding="utf-8" ?> <configuration> <!--...

The code below is implemented as a web service where the input is an xml file. It calls a stored procedure to add a row of data to a table. The problem is that when there is a space between a paramter, for example if <param> ab </param> works but <param> a b </param> wont. It works for the...

Why wont response.write work in a asmx.cs file. if i try to pass the error as a string to a method is has to be a web method which takes a string as a parameter. Fine so far. The web method returns the string to web form so i can view the error. However when i call the webmethod from...

i've been calling my functions in c# using the select function_Name from dual , but i'm in a spot of bother now as i cant do this with the boolean function. The reason i did this is because i could not get the code that is used to execute a stored procedure to work with the functions. The code...

i've been calling my functions in c# using the select function_Name from dual , but i'm in a spot of bother now as i cant do this with the boolean function. The reason i did this is because i could not get the code that is used to execute a stored procedure to work with the functions. The code...

Is it possible to examine the contents of a dataset if you are using it when it comes to executing a stored procedure in c#. The procedure will add a row of data to the table in question. The procedure does not return anything at all. Will there be anything in the data set at all or is it only...

I am giving the user the option of calling a procedure or function from a c# method. The problem I have is that sometimes the procedure will return an int value and sometimes the method may return a string value or even a database. It depends on which procedure is called. Do I have to write the...

create or replace procedure add_row_to_test ( aid in test.id%TYPE, afn in test.firstname%TYPE, aln in test.surname%TYPE ) is begin /** In this procedure I want to put single quotes around the values of aid,afn, and aln. Any ideas how I do this ??? **/ insert into test (id,firstname,surname)...

using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.IO; using System.Xml.XPath; using...

Below is code that I thought would run a function from asp.net passing it one argument, an id and return one number an integer as well. I am able to call stored procedures from asp.net with code similar to below but those procedures added a row of data to the table. I'm wondering is the...

I am just wondering that if you run call a stored procedure from c# that adds a row of data to a table, is there any way check the contents of the dataset after the stored procedure has run successfully. This is the code: public DataSet getData(string[] aParams) { string sConn =...

using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.IO; using System.Xml.XPath; using...

I want to execute a stored procedure from where the name of the stored procedure and the parameters are passed to the method in an array, the name of the stored procedure will always be at array[0] and the remaining parameters will follow... However the number of parameters can vary from 1 to...