|
|
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??
|
|
|
|
|
kranius wrote: 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??
Perhaps a DataGridView would be a place to start. Just a suggestion. I'm sure there are an infinite number of ways to solve the problem, but I'd likely start there.
Good Luck
“You can't teach people to be lazy - either they have it, or they don't.”
-Dagwood Bumbstead
|
|
|
|
|
In terms of data structures how about:
An array may be a structure that works as you can reference the row and column directly just like a spreadsheet.
You always pass failure on the way to success.
|
|
|
|
|
Before you think about how you are going to represent the data visually, you would be well advised to consider how it is represented in code. Would you store your information in a 2D array, or some other structure? Hint - the 2D version is very, very innefficient.
Now, on the surface it would seem that you would be well advised to use a 2D structure because that mimics the layout of the cells very well, but as soon as your cell sizes grows to any distance then the memory consumption will go right through the roof. You can simulate the 2D structure with an algorithm such as a sparse-array which is much more memory efficient.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks for the advise. Well internal structure wise, I was thinking something like a double linked list. It is really the gui side that I can't think of a good way to accomplish it..
I take a look at the datagridiew and see how it would work..
|
|
|
|
|
HI,
i like to know if there are some ready to use controls
that are not by def in C# (like button...)
For Example : Led - a.k.a light emitting diode
or Like Digital Stoper (CLock) and so on...
kobkob
|
|
|
|
|
kobibi wrote: i like to know if there are some ready to use controls
that are not by def in C#
Yes - there's a thriving industry in third party controls. That's the beauty about .NET, it's very easy to create your own controls. You should only be limited by your imagination.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
There's a Search box at the top of the Code Project website. I was able to find examples with precious little effort on my part - try it out sometime!
“You can't teach people to be lazy - either they have it, or they don't.”
-Dagwood Bumbstead
|
|
|
|
|
hi guys,please help me on how to upload an image to the database?
thanks..more power..
|
|
|
|
|
Which type of database? Have you tried searching google for such a vague topic? I suggest you search google
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Use some form of binary datatype in the database. Insert it from a byte array. Without knowing more about the basics such as which database and whether it's an ASP.NET or WinForms project then I can't really offer you any more advice than that.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Do you know something about BLOB?
Check, it may help you.
|
|
|
|
|
I found a way to write my game in c#, but it using 3d graphics. XP and voodoo3 don't agree with each other. So i need to know how to change this so i can use software or change it to full screen when it opens:
namespace WindowsGame1
{
class Engine : Microsoft.Xna.Framework.Game
{
Microsoft.Xna.Framework.GraphicsDeviceManager Graphics;
Microsoft.Xna.Framework.Content.ContentManager Content;
Microsoft.Xna.Framework.Graphics.Texture2D mytext;
Microsoft.Xna.Framework.Graphics.SpriteBatch SpriteBatch;
Microsoft.Xna.Framework.Vector2 Spritepos;
public Engine()
{
this.Graphics = new Microsoft.Xna.Framework.GraphicsDeviceManager(this);
this.Content = new Microsoft.Xna.Framework.Content.ContentManager(this.Services);
}
protected override void Initialize()
{
this.Spritepos = new Microsoft.Xna.Framework.Vector2(100f, 50f);
base.Initialize();
}
protected override void LoadGraphicsContent(bool loadAllContent)
{
if (loadAllContent)
{
this.mytext = this.Content.Load<microsoft.xna.framework.graphics.texture2d>(@"new\text\Mike1");
this.SpriteBatch = new Microsoft.Xna.Framework.Graphics.SpriteBatch(this.Graphics.GraphicsDevice);
}
}
protected override void UnloadGraphicsContent(bool unloadAllContent)
{
if (unloadAllContent)
{
this.Content.Unload();
}
}
protected override void Update(Microsoft.Xna.Framework.GameTime gameTime)
{
base.Update(gameTime);
}
protected override void Draw(Microsoft.Xna.Framework.GameTime gameTime)
{
this.Graphics.GraphicsDevice.Clear(Microsoft.Xna.Framework.Graphics.Color.Black);
this.SpriteBatch.Begin(Microsoft.Xna.Framework.Graphics.SpriteBlendMode.AlphaBlend);
this.SpriteBatch.Draw(this.mytext, this.Spritepos, Microsoft.Xna.Framework.Graphics.Color.White);
this.SpriteBatch.End();
base.Draw(gameTime);
}
}
}
Michael
(Up and coming Game programmer)
EST
|
|
|
|
|
What? What are you asking here? I'm sorry, but I read and reread your post and I still don't know what the question really is? Are you asking how to get the code to run in full screen mode when it's running? If so, the graphics device has a property called IsFullScreen. Set it to true.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
HI,
is there any way that i can put text at the Row Header?
THNKS
kobkob
|
|
|
|
|
Yes. Take a look at the DataGridView documentation - it is really quite easy once you get the idea that the header cell is similar to other cells in the datagridview.
Suppose you wanted to set the text for row 0's row header... you could do this:
dataGridView1.Rows[0].HeaderCell.Value = "Some String";
Good Luck!
It isn't enough to do well in life.
One must do good when and where one can.
Otherwise, what's the point?
|
|
|
|
|
THNKS 
kobkob
|
|
|
|
|
I need to find an integer element in this 2d list and modify it.
|
|
|
|
|
It's a list like this: List<List<int>>
|
|
|
|
|
Not tested:
list is List<List<int>>
foreach(List<int> list2 in list)
{
int index = list2.IndexOf(value);
if(index != -1)
{
list2[index] = newvalue;
break;
}
}
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Loop through the outer list, for every list loop through the inner list and look for the item.
---
single minded; short sighted; long gone;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
