|
Hi, how can i create or delete a table in MsAccess using c# and Microsoft.Jet.OLEDB.4.0?
ty very much
Alessio
|
|
|
|
|
What are you having problems with? You need to call a command that executes a 'create' or 'drop' statement on the access database - have you written any code to do this?
It definitely isn't definatley
|
|
|
|
|
Bad Moon_Stick! Didn't you know that you've entered into A Contract with Legion the moment you helped someone? You are now required to write the homework for anyone who asks.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Ah crap - I wish I'd know that earlier!! 
Sometimes it almost seems like it'd be better if I didn't try and help at all - it really does annoy me!!
It definitely isn't definatley
|
|
|
|
|
DataTable tabella = new DataTable("letturair");
DataColumn colonna;
DataRow righe;
OleDbCommand comando;
OleDbDataAdapter adattatore;
colonna = new DataColumn();
colonna.DataType = System.Type.GetType("System.String");
colonna.ColumnName = "CODICE";
tabella.Columns.Add(colonna);
string nomeColonna;
for (int i=1; i<=Convert.ToInt32(tbNumeroQuesiti.Text); i++)
{
nomeColonna="R"+Convert.ToString(i);
tabella.Columns.Add(nomeColonna, typeof(String));
}
....and now? how can i create my table in a Access document?
ty very much
|
|
|
|
|
using System.Data.OleDb;
then you will need to create instances of OleDbConnection and OleDbCommand
pass your database connection string to OleDbConnection then open the connection.
create an SQL Query[^] as a string and pass that, along with the OleDbConnection, to the OleDbCommand
then execute the OleDbCommand as required
p.s. dont forget to use command parameters if you have any UI values
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
When I asked if you had written any code, I meant, have you written any code that will create or delete a table?
If you try and write code (looking at google or documentation will be useful here) and have difficulty with something, I'll try and give some useful advice but I'm not going to write all the code for you.
Go and make some kind of an effort to solve the problem before you start asking questions - I won't offer any help until you've done that.
It definitely isn't definatley
|
|
|
|
|
Hi,
I'm using a DataGridView to display a number of files. I would like to use a ContextMenuStrip to give the user access to some basic functionality for manipulating the files. I have managed to do so, the context menu works and I have determined that the correct cells are being affected by the actions on the context menu. How ever, when I left click a file in my gridview the file is selected and thus highlighted. I would like this to happen when I right click the file to bring up the context menu too.
This snippet does the work if I disable the context menu:
private void viewFiles_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
viewSessions.Rows[e.RowIndex].Selected = true;
}
}
I guess that what I want is to execute this code before showing the context menu, right? Any ideas?
|
|
|
|
|
instead of attaching the context menu to the dataGridView leave it unattached
Then when you set the .Selected = true; in your above event handler add the follwing line
contextMenu1.Show(Cursor.Position);
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
Hi Frnds
I want to implement a application in which i can open any file, image or video through mobile from remote place
Plz help me out It's urgent.......
Thanks in advance.......
modified on Friday, February 20, 2009 8:27 AM
|
|
|
|
|
Took me almost half an hour before I realised that it's not meant seriously! Good one!
I are troll
|
|
|
|
|
If u don't know to implement don't post ur comment.
|
|
|
|
|
If you don't know how to read
- f_off!
If you refuse to spell
- f_off and die!
If you won't make an effort
- f_off and die you m_f_er!
If you want others to do your homework
- f_off and die you m_f_ing p_drinking a_sucker!
Kapeesh?
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
williamnw wrote: If you refuse to spell
- f_off and die!
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
|
Occassionally. Just occassionally. I get 'vexed' and I need to vent. It's a bit like those vile felines scratching at the nearest piece of tailoring there bi-cellular brains encounter.
You goive a guy a hint. He doesn't even take the hint and tries to snarl his yellow teeth at you. You know what I say? "Bring 'em on! And there damned cats!"
[btw thank you for the 5, have one back.]
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Hey hey now! What's all this? Are you trying to mimic my attitude?
|
|
|
|
|
Hi, Welcome to being scorned. You are being laughed at for the following:
1. Using all bold text
2. Using 1337 txt spek.
3. Asking for code.
4. Being stupid
Please correct all of the above and ask again, make sure to look at point 4. Google can help you with that.
|
|
|
|
|
You should be able to make use of the following framework:
using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
namespace NeedsCode
{
class Program
{
static void Main(string[] args)
{
throw new NotImplementedException("The program code needs to be implemented.");
}
}
}
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
well first you might want to consider how you plan to connect to the mobile.... then who knows
Oh, if you do somehow make this application, dont forget how i helped. the source code as a reward should be fine
If you reply to this 'aashish patidar' then i will accept as a written agreement fro my reward
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
OK. First you need to port every file, image, and video reader application to your mobile. Then you need to send the files to it. 
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
In a far off land, there's a large mountain. At the top of this mountain, a reclusive group of monks called the Redoceerf live in a crumbling old monastery. The moss covered walls of this monastery have stood as mute witness to the thousands of travellers who have attempted the difficult task of climbing to the summit of this mountain to ask questions of a wise old hermit.
The wise old hermit is reputed to know the secrets of everything. He knows the sound that one hand clapping makes (it's "cl" if it's the left hand and "ap" if it's the right hand). It is reputed that he knows how to live off the moisture in the air, and has never been known to tread on any form of lower life. The answer to the secrets you seek mean that you must climb the steep mountain paths until you come to the ravine of unanswered souls. Cross this ravine by means of the rickety bridge - it stretches into the mists, and it is missing several slats so take great care. Once across the bridge, you must climb the narrow paths until you come to the monastery. At the monastery, offer up fruits to the monks to seek their permission to pass.
Once past the monastery, you will climb up the mountain goat trails until you reach a small cave near the top of the mountain. There you will find the hermit. Seek to apprentice yourself to him for thirty years or so - he will judge your worthiness by giving you a single slice of hard bread. A word of warning here - do not eat the bread, no matter how much you hunger; after a day or so, he will hand you a bowl with a hole in the bottom and indicate that you should fill it with soup - use the bread to plug the hole and then fill the bowl. Note that the hermit will not speak, and if you pass this test, he will gesture to you that you may stay.
The tasks he gives you will be hard. They will test your endurance, and he will not speak. It is up to you to learn to listen to the silences in the wind. Once you can hear these silences, the secrets he knows will be unveiled to you - he will never speak to you directly, but you will have achieved wisdom. At the end of your apprenticeship, you will be ready to descend the mountain once more. Be sure to stop at the monastery to get your souvenir tea towel.
At this stage, you have the wisdom to know that this task is only urgent to you. Me? Well, I couldn't give a flying fig one way or the other, and I'd much rather spend the time mocking you.
|
|
|
|
|
You get a giant bag of WTF on that one sir.
|
|
|
|
|
Pete O'Hanlon wrote: The wise old hermit is reputed to know the secrets of everything.
His name is AJAX right? I heard he is moving from his cave and taking up new residence on a secret computing cloud such as only befits his regality.
Now a serious question. You plagiarized that yes? I mean you didn't just make that all up did you?
|
|
|
|
|
led mike wrote: You plagiarized that yes
Nope. It's all me. You've known me long enough now to know that all mocking is 100% Pete. I've crafted a few like this over the years, but I had a bit of time this afternoon while a transformation process was running.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
