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:

Forms Data Controls :: Update GridView Content With A Stored Procedure?

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

Forms Data Controls :: Loop Gridview To Update Values In Gridview To Stored Procedure?

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

Forms Data Controls :: Update Database Record Using GridView And Stored Procedure?

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

Forms Data Controls :: Update GridView - Pass Current User To Stored Procedure?

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

Forms Data Controls :: Bind Value To Selected Value Of Dropdownlist In Gridview And Update By Stored Procedure?

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

Forms Data Controls :: Way To Update For A Manually Bound GridView

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

SQL Server :: Sort By Gridview SortExpression Parameter Via Stored Procedure?

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

ADO.NET :: Manually Set Return Type For Stored Procedure?

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

Forms Data Controls :: Edit Or Update Data In Gridview Manually Without Auto Generate In C#?

Mar 12, 2010

how to edit data in grid view manually without auto generate in gridview + ajax.

View 4 Replies

Forms Data Controls :: Stored Procedure And Gridview?

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

DataSource Controls :: Pass A Parameter In To A Stored Procedure In SQL?

Feb 17, 2010

how can i pass a session variable in a C# web form to a stored procedure..?

View 1 Replies

DataSource Controls :: Get The Output Parameter From Stored Procedure?

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

Forms Data Controls :: Paging Using Stored Procedure In Gridview?

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

Forms Data Controls :: Trying To Populate Gridview From Stored Procedure?

May 12, 2010

[Code]....

[Code]....

View 1 Replies

Forms Data Controls :: Gridview Populate From Stored Procedure?

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

ADO.NET :: Update Two Tables From Single Gridview Using Stored Procedure?

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

DataSource Controls :: How To Send DateTable As Parameter In Stored Procedure

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

DataSource Controls :: Calling Stored Procedure With Hierarchyid Parameter?

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

DataSource Controls :: Passing Column Name As Parameter To Stored Procedure?

Feb 12, 2010

ALTER procedure [dbo].[Sample2]
@Col as nvarchar(1000),
@Value as nvarchar(1000)

[code]...

View 5 Replies

DataSource Controls :: Passing Default Parameter To Stored Procedure ?

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

Forms Data Controls :: How To Use A GridView With A Stored Procedure With Changing Columns

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

Forms Data Controls :: Styling Columns In GridView From Stored Procedure?

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

Forms Data Controls :: Call A Stored Procedure And Display In Gridview?

Feb 23, 2011

how to call a stored procedure and to display it in a grid view table..

View 3 Replies

Forms Data Controls :: Updating Row In GridView To Database Through Stored Procedure

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







Copyrights 2005-15 www.BigResource.com, All rights reserved