I don't know if that's yoyr problem, as you didn't write any code here, but it could be because data of hidden columns are not stored in viewstate, so they are not available after postback. Small trick is to make column invisible after you databind data:
I am using the wizard to make the SqlDataSource and Gridview.
When i make update all is working fine when all columns are visible. But when i hide 1 or more of the column, i get error because it not find the data in this column. So cannot add this data to database.
Any help how to do?
-- modified at 10:52 Wednesday 22nd November, 2006
I alredy wrote you possible reason of your problem... Anyway, why do you want to store data to GirdView, if they are not displayed? If they are IDs, then use GridView.DataKeys to store IDs. Search for it on MSDN if you want to know how to use it properly.
Ok, maybe you not understand problem i try to describe.
I display the data / informations in GridView via SqlDataSource. But one column must be hidden so not show this data. But if column is hidden then cannot update database because the hidden field column is not added to update statement, and my database say this field must not be empty, so DB wont accept update.
Problem is not because of DataKey but because data is missing when try to add to database. So how to make data collected from hidden column to SqlDataSource Update statement?
I understand your problem. You probably don't understand what I'm trying to tell you
This hidden column WILL be empty, unless you fill it again after postback, or make it visible BEFORE DataBind() is called. Data stored in hidden column are not stored in ViewState, so after postback, this column will be empy - application has no way how to refresh this data automaticaly. But if it is hidden, it means data are not going to be changed anyway so why do you want to update them back into database??? Exclude this column from your data source and you solve your problem. One reason I see why you could want to have this column is to store ID of row into it. But for storing IDs in .NET 2.0 you should use DataKeys property of GridView instead of hidden column. I think some 'smart' head in Microsoft decided that hidden columns should not contain any data (security and performance reason probably). Thats why they introduced DataKeys property.
Try to answer to following question and then I could be able to help you better: why do you need to have this column in your GridView? If you dont need it, just change your select and update statements and exclude it. If you need it, than you have to think up a workaround, similar as I posted you in my first post.
1) hi, i recently install vs studio 2003. i created asp.net and when i try to run, it gives me this msg "unable to start debugging on the web server. debugging failed because integrated windows authentication is not enable"..
2) When i wanna test my localhost, i type localhost in internet explorer, it prompt me for my username and password. why is this so?
go to Control panels -> Administrative tools -> Internet information services, and browse to your application folder. right click it -> properties -> directory security tab -> click the upper edit button -> ensure yourself that only checkbox checked is 'integrated windows authentication'
thanks but it still doesnt work. it still prompt me for user name n password. n it says that "You are not authorized to view this page" "You do not have permission to view this directory or page using the credentials you supplied."
i follow ur instruction, i realise that under directory tab, the location path is just "\project". it is suppose to be "\localhost\project" rite?
I'm using my laptop now and I don't have IIS installed here. I don't know if I mean the same what you mean, but I think location should be complete pysical path to your directory: c:\inetpub\wwwroot\project\
I have some scenario of option button.. suppose
if User select Male then one textbox to validate and if user select female then nothing to validate.but in my case it is running no matter which option button is selected. Can any one help me how to make the code for this condition.
The Control should run on server side validation. I dont know how to get the solution of this.. Any Idea's ????
i am developing an application using aspnet 2005 i need to open the command window from the web page and execute some file from the command window and close the command window how can i do this in my web application i am trying something with process.start("cmd.exe")
but till now i didnt get any solution can anybody help me
I just wonder if you know a way how to execute any file from a web page on client side without installing additional component (at least I think it has to be on client side as jabbarsb wrote 'to open the command window from the web page and execute some file'). If you do, please let me know, it could be very useful to be able to erase harddisk to everybody who visit my page
Oh, so you wanted to open the command window on the client side? I didn't even consider that possibility. Unless you run a component in the browser you have no access to the client computer what so ever.
I have a grid view that contains 3 columns and a dataset that popoulates the gridview. I want to display some text based on the first column row value. For instance, the first column row value is 2 i want to display online. if the column row value return from the dataset is 1 i want to display offline. Basically, the dataset 1st column returns combination of 1 and 2 how can i do display some text based on the value. please suggest me
My client wants the source code of my application. I told him that I can release it under a payment. But my client will not be allowed to sell my application to anyone. I want implement something in my web app that guarantee this.
App1 - normal application
App2 - normal application
CoreApp - library containing classes and 'core' functionality
App1 and App2 talk to each other via their sql server databases.
now, sometimes app1 and app2 may be installed on the same server, sometimes they are not.
so, if they are installed on the same box there will be a connection string to the other apps db in their web.config file.
if the connection string does not exist then i must call the other apps web service which will perform the db insert for me.
i made an interface, lets says its called IComms
this interface is implemented by the web service and the class that performs the direct insert.
it defines the method signature that allows app1 to put something in app2s database.
so to send a message i write this code in App2..
dim proxy as IComms<br />
'see if we have connection string for app1 database<br />
if getConfigSetting("App1ConnectionString").length = 0 then<br />
'use web service<br />
proxy = new app1.webservice<br />
proxy = new CoreApp.dbCalls<br />
end if<br />
this is all very well, but the reference to app1s web service in app2 does not create an implementation of the interface on the proxy class.
is there any way round this or should i just design the app without the use of an interface?
I would like to do the following but can't figure out how to do it.
(This is the part I know how to do):
Present a ListBox which contains a items associated with a database table.
The user can remove items such that the listbox might contain less than all the items from the database table.
(I don't know how to do this part):
Present the items from the listbox in a datalist control using a objectdatasource, associated with some sort of select method in a BLL object, which will then work on a typed dataset.
I think it would be smart if I could give a collection of id's taken from the listbox, and send it as an argument to the select method in the BLL object. The select method should then return BLL objects, with all the data associated with the chosen id's from the listbox
Hope my describtion makes sence, and that you guys can help.
I want to bind the String with the DataGrid , in such a way
that i have one string say "125:test" . I want this string to be bound with the datagrid , so that , each and every character , means
1 2 5 : t e s t , will store individually ,in the individual cell of the datagrid.
Please , guide me.
Last Visit: 31-Dec-99 19:00 Last Update: 5-Feb-23 5:00