Well, it would help if you mentioned which database you are working with. I can help you with oracle: for all tables: 'select table_name from dba_tables;' for tables for a specific owner: 'select table_name from dba_tables where owner = 'XYZ';' for all the tables you have access to: 'select table_name from all_tables'; based on the result you may fill the listbox ! hope this helps

regards, Noman Nadeem :zzz:

alexkwh wrote: DataView dv = new DataView(ActivityData. Tables["MediActivities"]); try DataView dv = ActivityData.Tables["MediActivities"].DefaultView; Now ... your Web service might not be return what you think ! check it though debug mode. ALSO, in the web service, you might have given the table a different name. so try DataView dv = ActivityData.Tables[n].DefaultView;where n is the zero-based index of your table. regards, Noman Nadeem :zzz:

I do not think that you can have a cookieless forms authentication. What you can do is not keep the cookie persistent, i.e. not save after user logs off. in order to use forms authentication change the authentication tag in the we.config: you will be redirected to login.aspx page automatically ! cookieName needs to be unique for every application running. If you do not supply the "name" attribute, default value is assigned. change the authorization tag as follows: In your global.asax file use the Application_AuthenticateRequest function string cookieName = FormsAuthentication.FormsCookieName; HttpCookie authCookie = Context.Request.Cookies[cookieName]; . . . If you need more help, search for "ASP.NET forms authentication" on MSDN. regards, Noman Nadeem :zzz:

Hi Mike, thanx for the input, I was kind of hoping for another solution. I ran into a strange problem using the session, maybe u have a solution. First of all, it is an oracle DB. I have an ID field which has to be incremented by value 'x' upon each insert. I'm using myDataView.RowFilter = "type_id = max(type_id)" I get the max inserted ID and increment by 'x' I add using myDataSet.TABLE_NAME.AddRow(blah blah); The first insert works just fine. The next time I get the VersionNotFoundException upon setting the RowFilter for myDataView. I can resolve this by adding the code myDataSet.AcceptChanges(), BUT in this case myDataSet.HasChanges() returns false in my finalize code. My final resolution was make a copy of the dataset, AcceptChanges() for the copy and apply the RowFilter. If you /anyone can suggest a better approach, I would love to check it out. regards, Noman Nadeem :zzz:

Hi guys, I have a datagrid (myGrid) populated with a dataset (myDS) myDS is fetched and saved using a web service. everything is working fine. I need an additional functionality of keeping changes (any changes) made on the page temporary until the user clicks on "Save and Finalize" button (btnSave) Can someone please point me in the right direction on how to go about implementing this stuff. Much appreciated. regards, Noman Nadeem :zzz:

Hi reinier, by linkButton i'm assuming you mean you created a template column and added an ... your item should look something like the following: <%# DataBinder.Eval(Container.DataItem,"JobNo") %> you need to handle the ItemCommand event of your datagrid( myGrid ) this.myGrid.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.myGrid_ItemCommand); your myGrid_ItemCommand should look something like the following: private void myGrid_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { if ( e.CommandName == "myJobNo" && e.CommandArgument.ToString() != "") { // this contains the JobNo field you want !! string strJobNo = e.CommandArgument.ToString(); // do processing here } } Hope this helps regards, Noman Nadeem :zzz:

try the datagrid regards, Noman Nadeem :zzz:

he means the Page_Load function ! Directly using sessions is not a good idea if you are expecting huge clientelle (users). Cookies and Databases are the way to go, if you expect heavy traffic on your pages. regards, Noman Nadeem :zzz:

you can use session state upon FIRST successful login save user variables, e.g. username, passwd, server, logintime, blah blah. return to calling page of login.aspx (i'm assuming u know how!) on your shopping page Page_Load check if session variables are present.

try
{
// if your Session["username"] does not exist, it will throw exception
// if it is empty or null, we throw our own exception
if ( null == Session["username"] || "" == Session["username"].ToString() )
throw new Exception();

}
catch
{
// on exception - meaning not logged on or timed out
Response.Redirect("login.aspx?returl=...", true);
}

Take care though, session has expiry for idle time. e.g. you cannot login and come back after an hour and expect the values to be saved. If you need more help, don't hesistate :) Of course, another approach is to use cookies (which are stored on the client machine as apposed to the session) Hope this was what you were looking for. If anyone has a better solution I would love to hear it. regards, Noman Nadeem :zzz:

appologies for the mistyping the code. I should've copy/pasted from my code instead of writing it myself. I feel really bad about your wasted time, maybe someday I'll be able to make it up to you. take care regards, Noman Nadeem :zzz:

you should keep the un-install and re-install the last option. try the following: in IIS manager right-click on your virtual directory -> All Tasks -> Permissions wizard. just follow the wizard choosing default values for everything. Last click finish. Try your page now. If that doesn't work, try to shutdown and restart the IIS. type "iisreset" from the command prompt. Hope this helps. Lemme know how it turns out :) regards, Noman Nadeem :zzz:

Hello Ryan, The Response.Redirect is used for redirecting the current window to a new location (as the name suggests). you should try the following:

Response.Write("window.open("mailto:" + (Entry.AnEntry)sender).Email,null,null) ");

hope this is useful, regards, Noman Nadeem :zzz:

hello all, could anyone tell me of a possible way to get a CBitmap/HBITMAP from imagelist (CImageList/HIMAGELIST) best regards,

Hi, I have come accross a memory leak in my project ... could anyone suggest any memmory leak testing utility which will help me pinpoint the source of the leak regards