|
Hi,
I have two tables in the same dataset. What I want to do is select a row in table 1 and copy the values in some columns from table 1 to table 2.
Should be easy and I think I'm making it difficult for myself with code like:
DataRow[] dr = this.mycourtsDataSet1.Court1.Select("BookingDate = '" + bookingDate.ToShortDateString() + "'");
DataRow nr = this.mycourtsDataSet1.CourtSchedule.NewRow();
nr["Date"] = bookingDate;
nr["Court"] = "1";
if (dr.Length > 0)
{
for (int i = 0; i < dr[0].ItemArray.Length; i++)
{
string test = dr[0].ItemArray.GetValue(i).ToString();
}
etc .......
Any suggestions as to where I can find some help on this.
TIA
Glen Harvy
|
|
|
|
|
Have you tried using BeginEdit() and EndEdit() on new row before anf after making changes?
Visit my blog at http://dotnetforeveryone.blogspot.com/
|
|
|
|
|
It's making the change that I want help with, not how to save them.
Glen Harvy
|
|
|
|
|
Do you add the new data row in the second table?
Visit my blog at http://dotnetforeveryone.blogspot.com/
|
|
|
|
|
DataRow[] dr2 = this.mycourtsDataSet1.Court2.Select("BookingDate = '" + bookingDate.ToShortDateString() + "'");
DataRow nr1 = this.mycourtsDataSet1.CourtSchedule.NewRow();
nr1["Date"] = bookingDate;
nr1["Court"] = "2";
if (dr2.Length > 0)
{
for (int i = 0; i < dr[0].ItemArray.Length; i++)
{
if (dr2[0].Table.Columns[i].ColumnName.ToString().StartsWith("T") && !Convert.IsDBNull(dr2[0].ItemArray.GetValue(i)))
{
nr1[dr2[0].Table.Columns[i].ColumnName.ToString()] = Convert.ToDouble(dr2[0].ItemArray.GetValue(i));
}
}
}
this.mycourtsDataSet1.CourtSchedule.Rows.Add(nr1);
this.courtScheduleTableAdapter.Update(mycourtsDataSet1.CourtSchedule);
mycourtsDataSet1.AcceptChanges();
Glen Harvy
|
|
|
|
|
dr.AcceptChanges();
Do your best to be the best
|
|
|
|
|
Hai All,
Can any one tell me how to create a mail box of a user without having the AD interface i.e. the mail box should be there for the user but that user should not be in the Active Directory.
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
Hi all,
Am replacing a particular string with another string of a text file dynamically. but while doing this am putting them to a richtextbox also. the contents of this text file contains lot of HTML tags. right now am facing alignment problems. here is the code i have for replacing can some one help me with better solutions than mine
<------------------CODE---------------------><br />
public void ConvertFile(string Pathstring)<br />
{<br />
<br />
<br />
bool change = false;<br />
StreamReader re = File.OpenText(Pathstring);<br />
<br />
string test = "";<br />
string input = null;<br />
string fileName = Pathstring;<br />
while ((input = re.ReadLine()) != null)<br />
{<br />
<br />
if (input.Contains("XXX-XX"))<br />
{<br />
change = true;<br />
}<br />
if (change == true)<br />
{<br />
if (input.Contains(".jpg"))<br />
{<br />
if (test.Contains("XXX-XX"))<br />
{<br />
<br />
test = test.Replace("XXX-XX", GetFilename((input)));<br />
<br />
}<br />
}<br />
}<br />
test += input+"\r\n";<br />
}<br />
re.Close();<br />
richTextBox1.Text = test;<br />
}<br />
<------------------END OF CODE--------------------->
|
|
|
|
|
I see you've taken none of the advice you were given the other day ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Yes if i give File.WriteAll, i tried but it was not working, cause its taking last file name and writing it on places of XXX-XX.
|
|
|
|
|
I don't follow you ?
if you create a string [] by calling File.ReadAllLines, you can iterate over the lines and call your method to get the filename, and then call File.WriteAllLines. Putting it in a richtextbox is superfluous, unless you want the user to hand edit the file. Even then, a text control makes more sense, b/c you don't have rich text to start with, do you ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi
How i can get a header from Executable File??
(example: to detect if the program is a keylogger, because... well, the "bad user" can change the file name, and to identify the file using a .... quote?)
|
|
|
|
|
Check out the FileInfo class, it should be in System.IO
It might have some stuff you could find useful.
My current favourite word is: Waffle
Cheese is still good though.
|
|
|
|
|
Hi guys, ive JUST started c# and im having some problems. I think the reason is that im misunderstanding something with object oriented programming(i came from Delphi).
Ok, so i want to create a sort of space invaders game, and ive got this far: www.nuked.co.za/SpaceInvaders.rar
^^^^ that includes the source code(made in sharp develop 1)
Ok now my problem is this: i can only have one enemy/bullet at a time because else i have to create a picturebox for every possible bullet or enemy there may be. Now I found a way to create pictureboxes on the fly, but then I couldnt reference them from anywhere else(I need to so that the timers can make them move etc). What I mean is if I created one inside an onClick event its fine, but then I cant say this.thatthingicreated because it was not created publically(i presume). So the work around would be to just declare every name at the top and have global variables(thats my Delphi brain speaking), but thats tedious and what happens when you get a machine gun(for example).
Im sorry that im an idiot..
Thanks in advance for your help
Regards
Matt
Im lost...very very lost.
|
|
|
|
|
roguemat wrote: because else i have to create a picturebox for every possible bullet or enemy there may be
No, you're right, you're very lost. You create NO picture boxes. No game can work that way. Your best bet is to use DirectX, but if you want to try and make it work on just a form, you need to handle the paint event of the form, and draw your bullets, and everything else, directly onto the form.
What generally happens is that you keep an array of alien objects, an array of bullet objects, etc. Your paint event iterates over those arrays and draws the screen. Some other code grabs each bullet and checks if it's intersected with an alien. When you press space to fire, a bullet object is added to that array, with the position and velocity that makes it appear where it should, and move as you want it to.
I wrote a game called collision, it's far from perfect but I went through three articles explaining how I did it, and it sounds like you could learn a lot from that article ( although, again, I would say there's plenty I did wrong, being very new to C# when I wrote it ). It's on this site, just search for it.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
thanks man 
will go in search of it now
-- modified at 18:18 Sunday 7th October, 2007
|
|
|
|
|
I was looking at that just the other day actually. Stumbled accross it whilst browsing some articles.
My current favourite word is: Waffle
Cheese is still good though.
|
|
|
|
|
Cool - glad the article is gettng some use then.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
What's new and different about Visual Studios 2008? Can I import 2005 projects to it, and also for C#, is it the same or just upgraded code? Thanks.
|
|
|
|
|
VS2008 is a beta product, you should not expect it to work 100%. There are many new language features, you'll find out all about them if you try some googling.
If 2005 projects don't import into 2008 it would be the first time Microsoft did something that stupid.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Hey guys,
I have a CSV file whose contents I would like to upload to an online MySQL datbases (running on a php server) using a simple C# app.
I am not sure how to do this but I figured uploading the entire CSV file to the server
if the first step.
Is there a way of achieving this using ftp within C# somehow?
Help much appreciated!
Gerry
C# newbie
|
|
|
|
|
Can you connect with the MySQL database directly, or do you need to FTP the file and then have code on the server to parse and insert the files ?
http://www.codeproject.com/cs/internet/ftplib.asp[^] might help.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi Christian,
Thanks for this ftp article, I'm sure it'll do the trick (yes file has to be uploaded, then Mysql inserted by running php script on server).
Many thanks!
Gerry
|
|
|
|
|
I generally mean the cell like structure.. Is this jsut a panel with a grid on it and mouse events to track which cell the user mouse is over??
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
