DataSource Controls :: Can Capture Return Value From A SQL By Using SqlConnection SqlCommand
Apr 15, 2010can capture return value from a SQL by using SqlConnection SqlCommand
[Code]....
can capture return value from a SQL by using SqlConnection SqlCommand
[Code]....
I'm trying to determine whether it is better to declare the connection outside with it's own using statement or to create it inside the sqlcommand itself. This is in regards to a single command interaction with the database (no loops).
[Code]....
Or
[Code]....
I am accepting query/queries from user (our support team) in a text box where user can enter only one query or multiple queries. I need to display result of all queries entered in the textbox. If it is SELECT statement then result of that statement in grid which is done. If UPDATE/INSERT/DELETE then total number of rows affected which is also done but if only one UPDATE/INSERT/DELETE statement is entered in the textbox.
If user enters 2 UPDATE statements and then a SELECT statement then how can I get number of rows affected for individual UPDATE statements just like SQL Server Qury Analyzer displays messages in its result pane.
e.g.
(6 row(s) affected) -- first UPDATE statement
(4 row(s) affected) -- second UPDATE statement
(16 row(s) affected) -- for SELECT statement (grid will also be displayed along with these messages).
I tried almost everything, SqlDataSource (returns count of first statement only), SqlCommand.ExecuteNonQuery and DataAdapter.Fill (returns count of last statement only).
Declaring the SqlConnection and SqlCommand objects in a webform without CodeBehind I am trying to query data from a MS SQL server with a C# web form without "CodeBehind". I want to write the information to a table in the web form's body.
I am having trouble declaring the SqlConnection and SqlCommand objects that connect to the server.
How do you use "using System;", "using System.Data;", "using System.Data.SqlClient" inside the script element of an .ASPX file?
(code below)
[Code]....
I have th following code:
[Code]....
I got any error from the code, saying 'not all code path return a value', i suspect it is the catch block doesnt return a value. If so, what value should i return?
i have 5 methods in classA. each and every methods i have open the sqlconnection and close it, instead of that is there anyway to create a sqlconnection at one time if its opened then no need to create a new connection, if its closed then we have to connect.
View 5 RepliesIs it possible to use a pre-existing ConnectionString in this construction?
myConnection = New SqlConnection("server=localhost;" & "database=pubs;Trusted_Connection=Yes")
Regards -Penn
I have a whole bunch of data access methods where in each one I am doing this
[Code]....
and them moving on with my SqlCommand and SqlDataReader and so on.Is this creating to many instances of an SQLConnection?I was thinking doing this instead. Creating a SqlConnection Manager which would look like this
[Code]....
and then in my database access methods
[Code]....
Is this a good or bad idea and why?Also would this even be neccesary?
i am making a simple cms system
but I have a problem when updating some information
here is the code
[Code]....
and in the page load everything is fine
[Code]....
'SqlConnection' is not defined in the behind code as follows:
Source Error:
[Code]...
Source File: I:WebsitesCMPHostFox BackupDefault.aspx.vb Line: 24
Snippet reads as follows:
[Code]...
I want to add array list in sqlcommand.but i don't no how to pass it. My code is.
ArrayList
ProductId = new
ArrayList();
for (int i = 0; i < ShipmentPackage.Items.Count; i++)
{
ProductId.Add(ShipmentPackage.Items[i].ProductVariant.ProductID);
}
select * from TableName where id= ProductId(ProductId is my Arraylist)
i want to ask how to i set variable in asp:sqldatasource in sqlcommand in asp.net c#....
This is my code
asp.net
<dx:ASPxListBox ID="lsAssignToko" runat="server" DataSourceID="SqlDataSource6"
TextField="NAMA" ValueField="ID" AutoPostBack="true"
EnableCallbackMode="True" SelectionMode="CheckColumn"
OnSelectedIndexChanged="lsAssignToko_SelectedIndexChanged">
<Columns>
<dx:ListBoxColumn FieldName="ID"/>
<dx:ListBoxColumn FieldName="NAMA" />
</Columns>
</dx:ASPxListBox>
<asp:SqlDataSource ID="SqlDataSource6" runat="server"
ConnectionString="<%$ ConnectionStrings:Ora2010 %>"
ProviderName="<%$ ConnectionStrings:Ora2010.ProviderName %>"
SelectCommand="SELECT ID, NAMA FROM REF_TOKO WHERE ID IN ( :inTOKO ) ORDER BY NAMA">
<SelectParameters>
<asp:SessionParameter Name="inTOKO" SessionField="inTOKO" Size="200" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
c#
string dummy = "";
string data = "";
string inTK = "";
string inTOKO = "";
//string inTOKO1 = "";
int pot;
for (int i = lsToko.SelectedItems.Count - 1; i >= 0; i--)
{
string tok = lsToko.SelectedItem.Text.ToString();
data = lsToko.SelectedItem.Value.ToString();
dummy = dummy + "" + data + ",";
int index = lsToko.SelectedItem.Index;
lsToko.Items.RemoveAt(index);
}
if (lsToko.SelectedItems.Count <= 1)
{
inTK = dummy.Length.ToString();
pot = int.Parse(dummy.Length.ToString()) - 1;
inTOKO = dummy.Substring(0, pot);
}
Session["inTOKO"] = inTOKO;
the problem is where in my variable inTOKO consist of couple of value...
Example
while variable inTOKO = one value success but while value inTOKO = two value error
inTOKO = 1101111 => success
inTOKO = 1101111,1211321 => not success
i have the followng code:
[code]...
Now what I want is how can I print the complete sql statement and try to run it in sql query of
Sql server. How can I print Sql statement from sqlcommand. the cmd.commandtext seems notworking.
[Code]....
is used for update, insert and delete operations.Besides the fact
I am using "ASP .Net 2.0" with "SQL Server 2005". What is better and preffered approach towards making a sqlconnection to interect with database?
1. To open new connection each time we need to interact with DB and then close the connection
2. Or to make a shared database connection for whole web application.
I know you can point to a OnSelecting event on the aspx page datasource. But I've created my SqlDataSource in the code behind. Is there any way to point to a selecting event in the code behind (I need this to provide the parameters)? Or should I just include all my logic in the Page_Load event (where I keep my SqlConnection)Here's what I have so far:
protected void Page_Load(object sender, EventArgs e)
{
SqlCommand myCommand = new SqlCommand();
[code]...
how to write code for database transaction(eg; Insert,delete,update) i want to write a better code
eg:sqlcommand.Commandtext="some sql insert query";
sqlcommand.parameter.Add(new sqlparameter("@cmdname","someValue"));
sqlcommand.ExecuteNonquery();
how to write the above code in better and safe way, i am expecting .net master also answer this question
put his view(pros and cons)
How would I convert an empty textbox.text to null when updating/inserting using an SqlCommand? I've got this to populate the textbox:
If IsDBNull(dr("data")) Then
TextBox1.Text = ""
Else
TextBox1.Text = dr("data")
End If
Here's the SET of the SqlCommand:
[Code]....
'i'm working with visual studio 2005 asp.net c#. and i want to bind my website to my database with the "sqlConnection"
how do i get and set details from the database to the website fields with the sqlCommend and ect...
I added the button attribute on page load.
[Code]....
What I want to do is if the OK button is clicked, save the data and then open the grid. If the Cancel button is clicked, open the grid. The problem is when I clicked the Cancel button, it didn't do anything in the OpenGridButton_Click event.
I have created a .aspx page that contains a web form. The information in the form is submitted to a companies web site and once accepted is manipulated by the company.
This all works wonderful.
My problem is that once the data submitted to their site my page receives a response code. (1 = Member Added, 2 = Updated Member...)
How do I go about capturing this response code? Currently I end up with a blank page and a number in the upper left corner.
m trying to capture an output parameter from an SQL insert.for
CREATE TABLE [dbo].[Test](
[TestID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[Test1] [int] NULL,
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED
INSERT INTO [Test] ([Test1]) OUTPUT inserted.TestID as TestOut VALUES 1))
[code]....
I want to know about Change Data Capture(CDC) benefits in SQl Server?Especially on Data Base Volume?
View 1 RepliesI was reading about "Change Data Capture" functionality in SQL Server 2008. It sounds awesome. My implementation of it would be in a website environment where ASP.NET pages use SQLDatasources to do inserts, updates and deletes. When enabling "Change Data Capture" can you store additional information supplied from the website like a UserID, SessionID, UserRole etc so you can identify who did the insert, update or delete? [URL]
View 1 RepliesIn one of our sprocs, we have a validation and it returns an error as: RAISERROR('this is the error message', 18, 1) When I call it in the business logic layer, how do I obtain this error message and pass it through the web service?
[Code]....
As you can see, it supposes to return a Users type, but how would I capture that error message in sproc and pass it all the way to UI?