I have a table "deposit_options.The form deposit_options.aspx, save the data.When you reopen deposit_options.aspx, I wish that the data are stored and displayed, and only update them.
View 2 RepliesI'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.
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]....
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?
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]....
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.
along with a gridview update file that I store in my database
View 1 RepliesI 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.
i would like to find out how to go about displaying data from multiple database tables on the same page. What i mean is it would look like the feeds on the facebook home page where you can see the information like newply uploaded photo or a new post.
I have two tables, and i want to display any newly created row on my home page from either table in the same control. Currently, i have two gridviews, but i want the data from both tables be displayed together.
Let me try to explain my situation. I have a database table which contains, among other things, a boolean column called PermissionSlipRequired. I have a repeater on my page, and before each row in the database is shown in the repeater, I want to use my code behind to check the value of PermissionSlipRequired. Based on whether the value of PermissionSlipRequired is true or false, I want to change the text of a literal within the repeater. That's a real mouthful; hopefully some markup and code will clarify. Here's my repeater:
[Code]....
Here is what I've been able to come up with for my code behind. Needless to say, this code doesn't work.
[Code]....
As a former PHP user who is trying to migrate to asp.net.
Excel Data should be displayed in gridview?
View 2 RepliesI have a web page that contains a gridview control and is bound to an object data source.
Computers which use this page access it through a LAN.
The databases that the page uses are on a SQL 2005 server.
The page also uses the local users ID from their computer to display a custom data view for each user.
Like so :
If HttpContext.Current.User.Identity.IsAuthenticated Then holdLenUID = HttpContext.Current.User.Identity.Name Session("ID") = Mid(HttpContext.Current.User.Identity.Name, 14, Len(holdLenUID))
The object data source uses the ID to filter the data for the custom view.
<asp:SessionParameter SessionField ="ID" />
I am part of a group of people which use the web app on a daily basis.
I can no longer see my custom data on the page.
I can still access my data or any of my coworker's from a drop down on the page.
My coworkers can see their custom data when their page first loads.
I am the only one who can't !
Up until a week ago I was presented with my custom data on page load.
Also if I run the web app from VS2005 on my machine which uses a local web server the page is presented to me with the custom data.
I am at a loss as to where to begin to look for problem source.
Is it the web server ? IIS on the server ? the ASP net process on the server ?
i want data to drop down list using stored procedure .
However im not able to do that.
I've got a Varchar2 field in my table which I want to convert to a CLOB. I am unsure whether the data would get truncated when selected. If so, what is the limit and does it depend on the database settings?
In my TOAD or SQLPLUS window it gets truncated but this may just be the environment settings. I'm not sure whether it would get truncated in my actual application (I can test this, but up to what size should I test?)
If it does get truncated, what's the best way to display the whole CLOB? There are other fields in my SELECT query, so I think I can't just loop through multiple rows. Is there any way out?
I hv a gridview in my page, and is getting populated on page load in code behind page ..now i want that, when the page gets load the first row should be selected and the all the values of the row should be get visible in the textboxes above the gridview
i sm hw got the default first row selected but the values of that row is not gettign diplayed in the textboxes.
I'm having a problem displaying all data from a couple of database tables in a GridView. Only one row is displayed. I have my SQL query posted in the "SQL Server etc..." forum, and I'm posting the code here in case there's something wrong with how I display the data in the GridView. The GridView should display 2 rows, but displays only 1.
[Code]....
I've a table (named NoAccent) with a colum 'Title'. I need to write a store procedure so that if any special characters found in the title it should update (I'll set the sql agent to run the procedure in a specific time interval) e.g.
[Code]....
I'm a college intern at a small software company. I'm a novice when it comes to ASP.net and Expression Web, so sorry if these are obvious questions.
1. After figuring out how to get fields calculated before they get displayed (did this with SQL), I need to find a way to put certain characters before the output in the fields. I'm fairly certain this is done with a template field, but I have no idea how to touch those without making them blow up.
2. I would also like to have color in the GridViews rows or cells depending on a value returned from the database. Again, I think this would be done with template fields.
3. Thirdly, I need to be able to limit the characters in a few cells. I've searched and found some answers with this, but still Template fields go right over my head.
I have a gridview defined inside a div. I have defined a footertemplate for it, but for some reason, its not being displayed. Here is my code:
<div style="overflow: auto; min-height:10px; max-height: 250px;">
<asp:GridView ID="gvIncidentDetail" runat="server" GridLines="Vertical" OnRowCreated="gvIncidentDetail_OnRowCreated" OnRowDataBound="gvIncidentDetail_RowDataBound" OnSelectedIndexChanged="gvIncidentDetail_SelectedIndexChanged" Width="100%">
[Code]....
I'm using a ListView control and have everything working the way I want, except the display of the data. I have an asp:Label control for each field, and if I have "Text='<%# Eval("MinimumValue") %>' " everything works fine, except the dollar values from the database are displayed as decimal values (how they are stored in the database). I tried adding .ToString("C") to the end of the Eval and I keep getting the same error. I've included the block of tests (with error) from my immediate window. Is the problem just that I'm on the aspx page and need to do formatting in the code behind?
[Code]....
I'm having some difficulties displaying/enabling a link within a gridView but I only want to show it if the formType is equal to 'additional' This doesn't seem to working, Here's my link, inside a TemplateField:
[Code]....
Is it possible to achive this? As currently the link is displayed for all 'formType' and not just for "additional" as intended?
I have a datatable as a datasource to a grid view, it has a column amtDue, i would like to be able to sort by this column,, while not displaying it.
View 4 RepliesI have a query that joins two tables (in Linq) so I usethe result as an Iqueryable. I want the Query result to be displayed in a gridview, but for some reason I see nothing on the gridview.(I also tried without the join and just using the IQueryable result -and still nothing)
[Code]....
why is doesn't work, or link me to an examlple that is similar - (Also is there another way to use the result of a "join" not as IQueryable)
The values in one of the fields in my GridView's table are just either a zero or a one or a null. Well, "zero," "one," and "" are not very appropriate values to display to the end user. Is there a way I could change these to "True"/"False"/"NA" or "Yes"/"No"/"NA"?
View 5 Repliesi need to change the images getting displayed in gridview as per IMAGE_ID selection...which is kept in a dropdownlist...is it possible...
this is my code where when user selects image_id and logo_id from two different dropdownlist...accordingly images and logos will be displayed on two gridviews...but when user is changing data in dropdownlist the gridview doesnot reflects the change
[code]....