Click here to Skip to main content
15,907,392 members
Home / Discussions / C#
   

C#

 
GeneralRe: "The file isn't specified" error for opening documents Pin
tchaka27-Dec-03 12:53
tchaka27-Dec-03 12:53 
GeneralRe: "The file isn't specified" error for opening documents Pin
eggie51-Jan-04 6:40
eggie51-Jan-04 6:40 
GeneralManually setting MIME type in WebBrowser Pin
Alex Korchemniy26-Dec-03 13:06
Alex Korchemniy26-Dec-03 13:06 
GeneralLOL Pin
Alex Korchemniy26-Dec-03 15:08
Alex Korchemniy26-Dec-03 15:08 
GeneralRe: Manually setting MIME type in WebBrowser Pin
Heath Stewart27-Dec-03 5:14
protectorHeath Stewart27-Dec-03 5:14 
GeneralRe: Manually setting MIME type in WebBrowser Pin
Alex Korchemniy27-Dec-03 11:39
Alex Korchemniy27-Dec-03 11:39 
Generaldrop files into windows explorer Pin
elena1234526-Dec-03 7:49
elena1234526-Dec-03 7:49 
GeneralRe: drop files into windows explorer Pin
J. Dunlap26-Dec-03 8:58
J. Dunlap26-Dec-03 8:58 
GeneralRe: drop files into windows explorer Pin
elena1234526-Dec-03 11:22
elena1234526-Dec-03 11:22 
GeneralSimple PDF filling Pin
Alex Korchemniy26-Dec-03 7:22
Alex Korchemniy26-Dec-03 7:22 
GeneralWow this is awesome Pin
Alex Korchemniy26-Dec-03 8:46
Alex Korchemniy26-Dec-03 8:46 
GeneralRe: Wow this is awesome Pin
Kentamanos26-Dec-03 9:31
Kentamanos26-Dec-03 9:31 
GeneralRe: Wow this is awesome Pin
Alex Korchemniy26-Dec-03 12:22
Alex Korchemniy26-Dec-03 12:22 
GeneralRe: Wow this is awesome Pin
Kentamanos26-Dec-03 13:38
Kentamanos26-Dec-03 13:38 
GeneralUnit Testing: Mock Objects Tutorial Pin
drazz7526-Dec-03 6:34
drazz7526-Dec-03 6:34 
GeneralRe: Unit Testing: Mock Objects Tutorial Pin
LongRange.Shooter30-Dec-03 9:54
LongRange.Shooter30-Dec-03 9:54 
GeneralVariable error Pin
Melanius26-Dec-03 4:27
Melanius26-Dec-03 4:27 
GeneralRe: Variable error Pin
Corinna John26-Dec-03 4:55
Corinna John26-Dec-03 4:55 
GeneralRe: Variable error Pin
Melanius26-Dec-03 4:59
Melanius26-Dec-03 4:59 
QuestionHow do I read the Identity Column using ADO.NET Pin
derik_konark26-Dec-03 4:24
derik_konark26-Dec-03 4:24 
AnswerRe: How do I read the Identity Column using ADO.NET Pin
LongRange.Shooter30-Dec-03 10:01
LongRange.Shooter30-Dec-03 10:01 
GeneralProvideProperty Attribute Problem Pin
Takeru Koushirou26-Dec-03 2:22
Takeru Koushirou26-Dec-03 2:22 
GeneralRe: ProvideProperty Attribute Problem Pin
Alex Korchemniy26-Dec-03 7:29
Alex Korchemniy26-Dec-03 7:29 
GeneralRe: ProvideProperty Attribute Problem Pin
Takeru Koushirou26-Dec-03 8:07
Takeru Koushirou26-Dec-03 8:07 
GeneralAdd Column to Access database using OleDB Pin
Wouter Van Ranst26-Dec-03 1:32
Wouter Van Ranst26-Dec-03 1:32 
Hi guys,

I've been searching for this for 4 hours, but it just doens't seem to work.

I have an access database, and i have to add a column to it.

Here's my code:

string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +<br />
	@"Data Source=D:\My Documents\Visual Studio 2003.NET\VerboServe\Verboserve.mdb;" +<br />
	"User ID=Admin;" +<br />
	"Password=";<br />
OleDbConnection conn = new OleDbConnection(connString);<br />
DataSet ds = new DataSet();<br />
<br />
conn.Open();<br />
<br />
OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT * FROM Verbs", conn);<br />
OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter);<br />
<br />
dataAdapter.Fill(ds, "Verbs");<br />
<br />
ds.Tables["Verbs"].Columns.Add("Wouter");<br />
<br />
foreach (DataRow thisRow in ds.Tables["Verbs"].Rows)<br />
{<br />
	thisRow["Wouter"] = "True";<br />
}<br />
<br />
commandBuilder.QuotePrefix = "[";<br />
commandBuilder.QuoteSuffix = "]";<br />
<br />
ds.AcceptChanges();<br />
dataAdapter.Update(ds, "Verbs");


Can anyone tell me how to do this?

Thanks,

Wouter

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.