Forms Data Controls :: SQL Timestamp In GridView And Manually Added Update Parameter For Stored Procedure In C#
Nov 4, 2010
I have a SQL table containing a timestamp column. This table is displayed in ASP using GridView control. The timestamp column is indicated in the DataKeyNames property of the GridView. I'm using TemplateFields for all columns and a ItemTemplate HiddenField control connected to the timestamp column using Eval.
<asp:TemplateField
ItemStyle-Wrap="false"
Visible="false"
HeaderText="timestamp"
SortExpression="timestamp">
<ItemTemplate>
<asp:HiddenField
ID="gv_hid_timestamp"
runat="server"
Value='<%#
Eval("timestamp") %>'
></asp:HiddenField>
</ItemTemplate>
</asp:TemplateField>
The data is displayed properly. I'm trying implement the optimistic concurrency in C# using the value of above mentioned timestamp and a stored procedure. The SQL stored procedure expects the @timestamp as varbinary(8). I'm not sure how to pass the value of gv_hid_timestamp back to the stored procedure. I'm using the following:
command.Parameters.Add("@timestamp", SqlDbType.Binary).Value = Byte.Parse(((HiddenField)gv.Rows[row].FindControl("gv_hid_timestamp")).Value);
resulting in the following error: "Input string was not in correct format." (I also tried different data types but with similar result). I want to be able to pass this parameter programmatically from C# and not have to specify it on the UpdateParameters list.
View 2 Replies
Similar Messages:
Jul 12, 2010
I'm getting problems to update a database table shown in a gridview using a stored procedure.
My table has 3 columns and my stored procedure is something like:
spUpdateMyTable(@column1 varchar(20), @column2 varchar(50), @id_table integer)
as
update mytable set column1 = @column1, column2 = @column2 where id_table = @id_table
The stored procedure works perfect when I try to execute it in the SQLServer query analizer, but my problem is when I call the sqldatasource update command.
When I do that, it seem that there are problems whith the parameter's names...
I'm doing that whit updateparameters.Add(parameter) and parameter is created whit the same name, tipe and the value that Is shown in the gridView.
I'm looking for in the msdn but everything I founded was about doing that through an update query but I need the stored procedure.
View 4 Replies
Jan 14, 2010
I would like to ask a question on the visual basic codes to loop the gridview to retrieve the values and based on the values, it will be provided as parameters to update to the database table using stored procedure.
Firstly, I have a gridview named grvProduct. The page (ui) will be loaded with data from the database with the use of stored procedures. And only certain values can be edited through the use of template in gridview. So based on those edited values, I'm supposed to pass these values as parameters to the stored procedure which will then update a database table.
Let say, I have 3 records retrieved from the database and displayed in the gridview. And I would like to edit a values in the 3 records, how do I do batch update and pass those parameters to the stored procedure? I went to debug and step through the visual basic codes and realised there were too many arguments specified because I actually loop the gridview.
Below is my visual basic codes:
[Code]....
Below is my Stored Procedure code:
[Code]....
I believe it is the error in the looping of the gridview which results that I could not batch update the data/values.
View 3 Replies
Sep 8, 2010
I am trying to update record via stored procedure, but i got error at very start point. Problem is when i click on Edit link button within the Gridview it produce error.
I can populate values from database fine but its produce error when i click on edit link button. see the code below.
[Code]....
[Code]....
View 4 Replies
Feb 26, 2010
I have a page, let's called that Parameter page, displaying data from a database table using GridView. (The database is a SQL database.) I allow editing of data in GridView. The GridView uses stored procedure to retrieve data and to update data. In my project, users need to log in before using my asp.net project. So at every page, I know who the current user is by using HttpContext.Current.User.Identity.Name. Now as requirement changes, I need to record who has changed what (row) in the Parameter page. The information is to be written to a new table - audit log. Therefore I do not expect to change the Parameter table structure.
I have modified the stored procedure retrieving data. It returns one more column - an empty column with name currentUser. So GridView will create one more column. After data bound, I have the GridView_DataBound() to popluate that column using HttpContext.Current.User.Identity.Name.
I debug it in Visual Studio and am able to see the name of current log in user as the last column in GridView. I change the update stored procedure to take in one more parameter. That parameter, currentUser, takes default value. The default value is an empty string. So if UI part fails to send in the current user name to stored procedure, it just write the empty string as the user name. I change the <asp:SqlDataSource>. I add a <asp:Parameter> for currentUser.
[Code]....
I debug in Visual Studio. However when I save the change, the SQL profiler shows UI sends in @currentUser as NULL. Why?
View 7 Replies
Dec 9, 2010
Girdview has dropdownlist TemplateField called ddlSate, how to bind state field value in sql table to selected value of ddlState dropdownlist control? For example the sql table has AL value for state field, (Note by default ddlState lists all states options with sqldatasource), how AL is selected in ddlState when binding to ddlState?
Secondly, when user selects different state like GA, how below update stored precedure works? that means how to find ddl selected value in update procedure as shown below question mark line:
Here is part code:
<asp:GridView ID="gvOrder" runat="server" DataSourceID="ods1" AutoGenerateColumns="False"
style="margin-top: 11px" CssClass="pnlOrdercss" ScrollBars="Both"
BorderColor="Black" BorderWidth="1px">
<Columns>
[Code]....
View 2 Replies
Mar 3, 2010
I am having a hard time updating from my gridview based the value that I am setting in the datakeynames it is the Ucc field I keep getting and index out of range exception on the e.keys[0]. I have done this before so I am confused what I am missing here.
View 8 Replies
Aug 20, 2010
I have a gridview that calls data via a stored procedure. I am unable to enable the gridview columns to be sortable. I need to set the parameter in the Stored Procedure.
Here is my gridview:
[Code]....
And here is my Stored Procedure, I want to pass the sortExpression to the gridview:
[Code]....
View 4 Replies
Dec 8, 2010
I have this storde procedure that I add to my dbml file, when I do that it does not recognize the return type. The return type is a string, how do I set that it should be a string?
View 6 Replies
Mar 12, 2010
how to edit data in grid view manually without auto generate in gridview + ajax.
View 4 Replies
Jul 31, 2010
I have one problem with stored procedure.
My table:
tbl_payments
UserId
PaymentId
PaymentType
Stored procedure:
ALTER PROCEDURE dbo.Select_Customer
@PaymentId varchar(100)
/*
(
@parameter1 int = 5, [code]....
View 10 Replies
Feb 17, 2010
how can i pass a session variable in a C# web form to a stored procedure..?
View 1 Replies
May 6, 2010
I have stored procedure that increments a number. I am supposed to use the newly generated number and insert it into a table. My question is how do I execute the stored procedure, with a hardcoded value of 3 that it expects as a paramter, receive the number it generates as the output parameter and use it in the insert statement.
Here is the stored procedure code:
CREATE PROCEDURE [dbo].[Generate]
@myid int,
@next_no int output
AS
update mytable
set mynumber=mynumber + 1, @next_no = number
where myid=@myid
RETURN
Here is my insert statement, that I tried and it failed:
EXEC @GetNo = Generate '3'
Insert into customers (custid, name, phone ) values
( @GetNo, 'MSFT', '800-345-5678')
View 5 Replies
Jul 12, 2010
i need an example of a paging gridview using stored procedure.
i tried finding on the web and i can't find exactly what i need.
View 7 Replies
May 12, 2010
[Code]....
[Code]....
View 1 Replies
Oct 15, 2010
I'm pretty new at web programming but a lot of years as a client-server dev.
I'm populating a gridview from a stored procedure, but I don't want to actually execute the populate till I have all the values filled in the page. (some are static textboxes, a calendar (date) value and some drop-downs that are populated earlier) I see there's nothing like gridview1.show() like there is in c# windows form programming. I tried
[Code]....
[Code]....
View 2 Replies
Oct 12, 2010
I want to update two tables using stored procedures but my data not updating to data base
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace INV_DN
{
public partial class Form1 : Form
{
SqlConnection con;
SqlDataAdapter da1;
SqlCommand cmd;
// SqlCommandBuilder cb;
DataSet ds;
public Form1()
[Code].....
View 2 Replies
Jul 9, 2010
I have a Datatable and I want to send it in SqlServer as Parameter in stored procedure.
1. How i send datatable
2. How I use that datetable in sqlserver to read its data.
View 3 Replies
Apr 3, 2010
How do you call a stored procedure using C# .NET 3.5 that contains a parameter that is of type hierarchyid in SQL Server 2008?
A basic outline of my current code is as follows:
SqlConnection conn =
new
SqlConnection(DatabaseConnectionString);
SqlCommand StoredProcedureCommand =
new
SqlCommand("AddUser", conn);
StoredProcedureCommand.CommandType =CommandType.StoredProcedure;
SqlParameter ParamUsername = StoredProcedureCommand.Parameters.Add("@Username",
SqlDbType.NVarChar);
SqlParameter ParamPassword = StoredProcedureCommand.Parameters.Add("@Password",
SqlDbType.NVarChar);
SqlParameter ParamMasterNode = StoredProcedureCommand.Parameters.Add("@MasterNode",
SqlDbType.Text);
// HierarchyID type
ParamDynamboUsername.Value = Username;
ParamPassword.Value = Password;
ParamMasterNode.Value = "/";
conn.Open();
StoredProcedureCommand.ExecuteNonQuery();
conn.Close();
View 2 Replies
Feb 12, 2010
ALTER procedure [dbo].[Sample2]
@Col as nvarchar(1000),
@Value as nvarchar(1000)
[code]...
View 5 Replies
Feb 13, 2010
I am using DAAB with stored procedures. I use stored procedures more then once if possible. If I add a parameter later in stored procedure, I have to supply value for this in functions where it is even not being used as well, other wise it shows an error that number of parameters are not same. if I add parameter in last of parameter list in stored procedure and set a default value for it and I may have not to provide value for this from functions where I am not using it.
View 1 Replies
Sep 21, 2010
I have a stored procedure that returns a dataset with a different number of columns and different column names depending on user input. How can I use this with a GridView? Normally I define the columns beforehand in a static fashion, but, have never done a dynamic dataset like this.
View 1 Replies
Feb 16, 2010
Im loading some results from a SQL Stored procedure into a Grid View. From my stored procedure I simply get 2 columns returned, Details and Savings, the savings are being returned in the format 30.50123 I want to limit this to 2 decimal places and put a euro sign in front of it like so €30.50, I have managed to do this however its adding a new "savings"column to my Grid view which I obviously don't want. So I now have a savings column with the correct format of €30.50 and my 2 columns from my stored procedure
details and savings. Heres my code....
[Code]...
View 2 Replies
Feb 23, 2011
how to call a stored procedure and to display it in a grid view table..
View 3 Replies
Feb 8, 2011
I have an app where i have a GridView connected to a DropdownList....The selectedIndexChange determines what the gridview shows. Then have coded in the row editing event the ability to change the information in the row. MY ISSUE- cant take the new information changed in the row and update it in the database. I have a row updating event that im trying to figure out how to attach it to my stored proc and the newly edited row
View 12 Replies