I am new to SQLite hence the question:I am trying to execute these statement to insert a record into the table and get the ID of the newly inserted column. There is blahID column defined as auto-increment, PK.I want to get the value of @ReturnValue below:
[Code]....
[Code]....
It dies in setting parameter direction:newSqlParam.Direction = ParameterDirection.ReturnValue
I have an update function in my data layer which is defined as:
public int UpdateRBTable(parameters ...) This calls a SQL Server Stored Procedure to perform an update function on the database.
The process does its job for updating the table. However, the stored procedure has a return value (which indicates how many rows were updated), but this return value is not returned to the application. The application always shows that a zero was returned from the stored procedure.
I don't know what I'm doing wrong. I have done this before but I'm not at my pc so I can check how to do it. I want to receive the ID after insert.
[Code]....
I am doing a sql INSERT and would like to get a copy of object immediately after insert. Does C# have a command to achieve this??
View 1 RepliesI have two pages: the first it's a gridview that bind to DataSet, the second one have DetailsView that bind to DataSet that is used for editing and inserting.
Upon insertion on DetailsView Page, I want to redirect to GridView Page.
[Code].....
how to use database return many field and insert in a object(like any Collection ,Array,Hashtable etc)
[code]....
I want to know if it's possible to return the identity value after an insert working with just the insertCommand and the insert parameters - something like this (but this isn't working):
Code:
<asp:SqlDataSource ID="sqlCustomerInformation" runat="server" ConnectionString="<%$ ConnectionStrings:SloanLEDLightingSystemsQuoteToolConnectionString %>"
SelectCommand="SELECT quoteCustomerInformationId,contactname FROM QuoteCustomerInformation order by quoteCustomerInformationId"
[Code] ....
Not sure what's wrong with my code. Should I be doing this in the code behind? I'm also confused as to how I would then retrieve the identity value in the code behind - on iteminserted.
I want to insert a return confirm confirmation messagebox in the gridview which fires when a row is selected. Is there a way to bring out the confirmation messagebox when the a gridview row is clicked without post back. When the user click yes, then the post back will occur. When users click cancel in the messagebox it will do nothing.
View 3 Repliesi need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesHow to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
I want to take my return value from sql server to c#.
my code
SQL SERVER:
ALTER procedure [dbo].[userss](@email varchar(100),@password varchar(25),@name varchar(250),@DOB varchar(20),@acc_vari int,@ip_address varchar(50),@vari_code varchar(7) )
as
begin
declare @uid int
select @uid=uid from users where email='12we'
if(@uid>0)
return 0
else
insert into users values(@email,@password,@name,@DOB,@acc_vari,@ip_address,@vari_code )
end
In this i want to take return value "return 0 " from sql server to c#.
have a very important issue,i have three Stored Procedures Sp1,Sp2 and Sp3 .the first one (Sp1) will execute the second one (Sp2) and save returned data into @tempTB1 and the Second one will execute the third one (Sp3) and save data into @tempTB2.if I execute the Sp2 it will works and it will returned me all my data from the Sp3 ,but the problem is in the Sp1, when i execute it it will display this Error:INSERT EXEC statement cannot be nested I tried to change the place of execute Sp2 and it display me another error:Cannot use the ROLLBACK statement within an INSERT-EXEC statement.
View 4 RepliesI think this is simple, but I don't know how to do it.I have a table with 13 decimal type columns. I want to return columns in my query where the value of the column is greater than 0. What I think is to do a nested select within my WHERE statement, but that seems clunky, is there a better way?
View 12 RepliesI have an application that I am working on. It displays a list of employees that were born on the current month/day. I do not have a seperate column in the database for firstname and last name. The database was already in place when I started here. I need to be able to display only the last name of the users. The name are formatted like Doe, John A. Would I only be able to display up to the comma in the name? My current SQL Query is below.
[Code]....
how to return two ids from the same table, i need to create a cursor, it has to use two
EID details of different LID of the same table.
[Code]....
The above query is wrong, it is getting duplicate rows, so i need to optimize it ti return the two values in two different variables in cursor.
I have written an insert stored procedure which is called by my business logic layer, I want to return the new ID to the function once it has executed but i'm not sure how.
My SP uses RETURN SCOPE and when I have tested this it works but how I get that into a variable in the BLL function I don't know.
Actually I have a gridview with many rows and I want to insert the all rows in sql server through one store procedure first row can inserted but what should we do for other rows
View 3 Repliesi would like to insert text in sql server that contains words like select and a single quotation mark but sql server gives errors like if i wanna insert this :
View 1 Replies assist me rectifying the error in following sql stored procedure?
Sql Query:- [Code]....
I have created the above Stored Procedure for inserting datas into any table but while I execute the above proceedure its throwing some error.
I need to insert a record in table which is in remote server....I am using two connection strings for local and remote....both the servers are in same workgroup only...so am able to connect the both.The problem is am filling data of local table in on dataset1 and remote server table data in another dataset dataset2..Now whil inserting a record local an error occured like "This row already belongs to another table" after googlingI found like this like "Dataset.importrow()" instead of "dataset.add()" method...then there is no errors but the inserted record is not inserting in remote server database...
View 5 RepliesI am new to Sql server 2005. I have a table in which contains many data. I need to take particular data. For example, I want to take value of 110652.795813712 from FTEBASEPAY column. So i have wrote the sql statment like in below. SELECT * From tblEmployees where FTEBASEPAY='53842.7782655718' But i am not able to get the particular value. Manually i have seen the tblEmployees table, in which contains the particular data ('53842.7782655718'). When i execute the above select statement, there is no result for it. What i have to for overcome this issue?I have to give one more information, the FTEBASEPAY dataType is float in tblEmployees table.
View 4 RepliesHere is the deal. I need to create a Stored Procedure that has 2 SELECT statements. Now in ASP.NET, I know that a DataSet can have multiple tables and the DataAdapter can do just that. I am stuck with a scenario where I need to get a value from the first SELECT statement which will later be used in the second SELECT statement. I am creating a SP that passes one parameter (@AnswerID). Which should give me 2 resultsets. See below SELECT statements.
[Code]....
So how do I get the QuestionID from the first SELECT statement?
Basically I am creating a Questionnaire that has Question Dependacies. So from the above SQL statements I would like to display the Question Title with it's relevant answer options but depending on the previous Answer selected hence the @AnswerID parameter.
The reason why I want to use 2 SELECT statements is because I don't want to have 2 roundtrips to th server. So in my code the DataAdapter should return 2 resultsets and fill the DataSet.
If there is any another solution that can prevent 2 roundtrips to the server, I would most definitely like to know how to do it.
I not getting the return value from stored procedure that I have written so how to get that plzz its urgent I have return the procedure as ALTER PROCEDURE [dbo].[sp_AddPaySlip]
View 2 RepliesI have faced the peculiar case in Sql server's Inner join. I have 2 tablesFor example:Table Name: A and B I have shown the below code.
Select
* From A
Inner
Join B
ON A.JobCode
=B.JobLookupID
This select statement return 500000 records but both table did not have that much recordsI have shown the Records in every table:A=19396 and B= 25366 records.How it will return more then 5 lakh records in above select statemenet?. Please let me know if any one faced this issue earlier?
I am generating links for emails within a class in the model of my MVC site and need to obtain the URL address of the host server the site is running on.
How would I get this?