Well, I don't know exactly how this can be done, but I was thinking of updating the tables for each time a cell is changed. But in cases where the tables run large that can become a bit sluggish, so a good/better alternative can be to first do all changes needed, across columns and rows and then push an update database button.
The thing is that there are going to be quite a few rows that need update each time and it is too cumbersome to push...
Kurt Jakobsen
Last Activity: Nov 10 '08, 05:59 PM
Joined: Jun 20 '07
Location:
-
Dynamic gridView with editable columns
Hi,
I would like to have a dynamic gridview (number of columns will change depending on project) and I would like to be able to change the value in a gridview cell and that the database tables will be updated when the grid view cell is updated. An edit button is too cumbersom for the operator.
Anybody know if this is possible, and if so, do you have a piece of sample for me? Preferrably C# aspx with MySql but anything that can get me... -
Hi,
I am using xp. I've reinstalled the MySql server without that it seems to help. I've also run the myisamchk without it seem to help anything.
The only thing that helped was to run mysqladmin shutdown and then mysqld --skip-grant-tables which leaves it completely open.
The windows services does not manage to start nor stop the MySql service.Leave a comment:
-
ODBC 5.1 Driver connection fail
Hi,
I have a MySql 5.0 database installed on a remote server.
Until yesterday I have successfully communicated with it from other computers via ODBC 5.1 Driver.
What happened yesterday was that an application stopped on a data verification check (application specific) and the application was left with the connection open waiting for me to click ok on a warning. Since I had left for the day, the connection was left until this... -
C# Console (exe) application crashes on open command (MySql)
Hi,
I have problem opening an MySql connection from an win console application. I am using SharpDevelop as IDE. Previously I've been working with MySql through C# aspx and am new to writing exe programs in C#, so I assume that I might be missing something in the IDE / project configuration.
I am successfully opening a connection and reading data from the table using adapter (window panel application binding to a grid), but... -
Hello again,
after disabling the antivirus program the server could still not be accessed. Hence it was not the firewall.
It turned out that (although the user had not been changed) dropping the user and creating it again with grant all did the trick. Don't know why.
best regards
KurtLeave a comment:
-
Yes, that is a special written sw that has not been changed, and has been working perfectly before, and still does, but now only when running from the server machine, not from the remote machine anymore.
Yes, I am running windows 2000 professional on the server machine, and XP on the remote machine.
I tried the connect command as well as -u x -h y -p but did not manage to get it to work on local nor on remote login....Leave a comment:
-
Hello again,
sorry, I forgot to answer the last question:
The server is installed on one of my personal computers, so unless the IT department has hacked something, I do not think something has been changed. How can I check it?
Could it be a network security problem? If so, how can I come around it?
Best regardsLeave a comment:
-
Hello, thanks for the reply.
It looks like this is a message from the client program because it crashes with a fatal Run-Time error before it returns message from MySql. Anyhow, the message is: The program has caused a 'General Protection' fault at 001B:685004C9.
Yes, I can ping the server machine from the remote machine.
best regards
KurtLeave a comment:
-
MySql 5.0 community server remote access stopped working
Hello,
I have a client program that I use to access a MySql 5.0 community server. The client can be on the machine where the MySql server is installed or from a remote machine.
The client has worked fine for 1/2 a year from both the local machine and from remote. I installed the server in january. After returning from vacation in july, I cannot access the server from a remote machine anymore. But the client that is locally... -
Hello Jared,
thanks for your reply. By the way, I forgot to mention, I use C# and .net 2.0.
I've tried GridView, but it seems like you need to put in a button or any other control into each row that the user must click in order to be able to enter data into it? Hopefully I have missed some property setting? Also, I do not want the list to be bound to a table because it need to be empty when the page is loaded.
...Leave a comment:
-
etitable and tab'able list
Hello,
I need a single empty list/table control (one column and multiple rows) where the user can type in some numbers in the first cell, then press the tab button, and the cursor jump's to the next cell etc. Finally, he/she push a register button, and a sw loop fetches one cell at the time, treat's the input a little bit and store it in a table.
Anybody know a good and simple solution for this? -
Extracting cell values from gridview
Hello,
anybody know how to specify a particular cell in gridview and extract the value it contains into a variable?
best regards
Kurt -
FTP failure: 550 Failed to open file
Hello,
I am having problem to download files via a bat script from an ftp server.
When I do it manually (typing the commands into the ftp prog) it works. However this is no option as there are many files to download regularly.
The page advice me to use PASV, but I am not sure how to specify it. I've looked at some discussion group's round about, and they that you should enter 'passive' or 'PASV' as a command after logon.... -
Thank you mwasif!
that was the fix
best regards
Kurt :-)Leave a comment:
-
ORDER BY with floating point formula does not work?
Hello,
I have a problem getting 'Order By' to work properly on calculated results producing floating point value in MySql.
Ordering by single columns seems to work ok (like 'ORDER BY t2.Col4' in the query below).
This is a stripped version of my query:
[code=sql]
SELECT t2.Col4, ROUND(SUM(t1.Co l1 * t2.Col3) / SUM(t1.Col2), 2)
FROM Table1 AS t1, Table2 AS t2
Where t1.Col4 = t2.Col1... -
Thanks sicarie!
I found a nice and simple cmd line exe called SimpleCUrl on SourceForge that does the job.
Best regards
KurtLeave a comment:
-
Thank you kenobewan,
I read through the article and it looks to me like my code should be conform with it, but for some reason it still does not work. The colum headers are "click able", but when they are clicked, sorting is not performed.
Maybe there is something with my control config or config files or maybe I need something in the onsorting handler or maybe I need a different handler? I'm quite stuck here. Appreciate...Leave a comment:
-
cmd line tool for downloading a html page from internet
Hello,
I want to parse some info from a page that I've found on internet on a daily basis. To look up this page on internet explorer, and save it on my disk manually is no option.
The file can be downloaded as a csv file or xml file, and it is a https site.
There is no ftp connection info on the page for getting it via ftp.
Does it exist some command line tool or any other tools that can grab this... -
Sorting a GridView in C#
Hello,
does anybody have a simple and good example on how to sort any of the columns in a gridView? Preferrable a C# example.
How does it go along with a default paging handler?
My paging event handler looks like this:
protected void GridCtrlSite_In dexChange(objec t sender, GridViewPageEve ntArgs e)
{
g_GridCtrlSite. DataSource = (DataSet)Sessio n["Site_DataS et"];
g_GridCtrlSite. PageIndex...
No activity results to display
Leave a comment: