Hey Guys - would like to ask you guys for advice - [History] I have a table which I will grab from my sql server and place into a gridview(limited view/sample of data specific data to give users enough info to select a row). Now each row is selectable and once selected I would like to get the rest of the data which corresponds from the row selected - so users are able to view and be able to edit the related data. (This first part is completed I can select the data and get the pri key related to the selected row and pass it to page) [Question] What would be the best way for me to give the users the ability to view the data, edit the data, update, and delete it(I only need one set of buttons at the top of the page)? The data be retrieved is big. I don't need the ability to page threw the data as in dataview - Would like to get some feed back on ideas andor with some examples. I appreciate any advice.... Thanks Nick

Hey Guys, Here is my issue - I have a table with 3 date fields. (Entry Date, Pending Date, Accounting Date) -> in my GridView I need to represent this value in 1 column called (Report Date). My rules are if Accounting Date is null use Finalized Date, if Pending date is null use Entry Date. This rule has to work on a row by row basis as I am returning 100's of rows. Now if this is better done in the code - I can do that also. Any help would greatly be appreciated. Thank you.

Hi Guys, I am working on a console app which telnets to a linux server. Now this linux server ask for a username and password which i try to send via my code. Now everything works up until the SendKeys.SendWait() - it seems that the window does not react to the "Enter" command. I have tested this with some other telnet servers, which are not linux and they work. Any help or if any other work around are available I am open for anything. My issue is - I have a system built by ADP and would like to grab data from them and put it into my on db to process. However, their system is closed and the solution I came up with is to screen scrape what I need. If you guys know something alredy out there or can point in the write direction it would be great. Thanks ahead of time.

public string Login(string Username,string Password,int LoginTimeOutMs)
{
int oldTimeOutMs = TimeOutMs;
TimeOutMs = LoginTimeOutMs;
string s = Read();
while(s == "" )
s = Read();

        // s += Read();
        Console.Write(s);
        
        if (!s.TrimEnd().EndsWith(":"))
            throw new Exception("Failed to connect : no login prompt");
        Console.Write(Username);
        SendKeys.SendWait("{ENTER}");

Only 2 rows have actual data and 4 of them are just either yes (nor) no then calculate from those fileds depending and yes or no across 4 fields and only one field can be yes. Then you sum the row and that column. Sorry to be pest - i am not very good a stored p.

I have to gather some info from and database - now the issue comes into play with either coding somethng or writing a extremely difficult query - what to do??? Here is the scenario: Data from a single table. Have to calculate columns(sum) according to to certain criteria and have a total at the bottom. Also have to calculate columns(sum) that subtract from a main column and then sum that column. I am just confused as to which: 1) is eaiser ( as the sytem does not have many users) 2) more efficient 3) which would you guys do (code or sql query)? 4) Is a query even possible? Any suggestions or comments in the right direction would be greatly appreciated. Thank You.

Are you having problems with an AOL browser. I can't get it to send files. Nits

I created aspnet page that takes down a users information and allows them to attach 4 picture files. The page works fine as long as it used outside of AOL. How would I go about trying to resolve this issue??? Any help would be appreciated. The page works by saving the file to the server first before the e-mail message is sent out. I am using the System.Web.Mail methods for my page. Nits -- modified at 15:15 Tuesday 30th August, 2005

I want to be able to change the html code at certains points in a aspx page using a code-behind page. For example:

I want to be to do this:

GET HTML CODE FROM CODE-BEHIND PAGE

Any help of in the right direction would be appreciated. Thanks

I would I go about ading more TextBoxes with the push of button. For instance a user invite page that has 4 Textboxes but needs more - so there is a button that says add more boxes - which adds additionals 4 boxes and so on .... I have searched the web for ariticles on how to do this. Any help would be appreciated. I would like to use the code-behind page to do this. Thanks

Heys Guys I need some help. I have a ASPNET web app that needs to be able to call curl functions from another website to gather user data. If anybody knows how to integrate to the 2. Or if if the calls themselves would be transparent and could just be called from ASPNET? If any gurus out there could point me in the right direction. Thanks

Thanks for the help. It was I didn't put in the page_load, to not rebuild the datagrid. if( !IsPostback ) { builddatagrid(); } thanks for the help.

Hey all, any help would be appreciated. I have written a webform that has a datagrid. I am trying to get it to update but it will not update the changes. My code is listed below please help. I have no errors: Whats happens is the eventArgs does not pick up the changes but only the old values. Thanks public void UpdateCommand(Object sender, DataGridCommandEventArgs e) { //Retrieve items from Grid. string custID = ((TextBox)(e.Item.Cells[0].Controls[0])).Text; string cgARName = ((TextBox)(e.Item.Cells[1].Controls[0])).Text; string arPrice = ((TextBox)(e.Item.Cells[2].Controls[0])).Text; string arDesc = ((TextBox)(e.Item.Cells[3].Controls[0])).Text; arPrice = arPrice.Substring(1, arPrice.Length -1); double cost = double.Parse( arPrice ); //SQL Update Information SqlConnection sqlCon = new SqlConnection("myconnection"); string update = "UPDATE ActionRequestitems SET actionName = '" + cgARName + "',actioncost =" + cost + ",description = '" + arDesc + "' WHERE actionid = '" + "1" + "'"; sqlCon.Open(); SqlCommand myCommand = new SqlCommand(update); myCommand.Connection = sqlCon; myCommand.ExecuteNonQuery(); myCommand.Connection.Close(); sqlCon.Close(); // Reset the edit mode for the current item MyGrid.EditItemIndex = -1; // Refresh the grid BuildDataGrid(); }