Visual Basic Discussion Boards

Re: vb.net modify mdb database NEED HELP!

ckkc456710-Apr-06 18:59

10-Apr-06 18:59

do you mean this?

Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=""c:\databasename.mdb"";"

Dim objConn As New OleDb.OleDbConnection(connectionString)
objConn.Open()

Dim ds As New DataSet
Dim da2 As OleDb.OleDbDataAdapter
Dim sql As String

sql = "SELECT [Name] FROM Developer"

da2 = New OleDb.OleDbDataAdapter(sql, objConn)

da2.Fill(ds, "Developer")

Dim cb As New OleDb.OleDbCommandBuilder(da2)

ds.Tables("Developer").Rows(0).Item(0) = "yes"

da2.Update(ds, "Developer")

but it give me an "Invalid Operation Exception" ---"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."

can anyone tell me why?

p.s. do i have to created the primary key? why do i have to check?

Re: vb.net modify mdb database NEED HELP!

Chatura Dilan10-Apr-06 23:11

Chatura Dilan

10-Apr-06 23:11

For your second question
Yes, you have to create the primary key, otherwise you cannot update the database, but you can read data. If you already created the primary key, no need to check it. One day same problem happened to me when I didn’t crate the primary key.
http://www.codeproject.com/script/comments/forums.asp?msg=1401837&forumid=1646&Page=2&userid=2682888&mode=all#xx1401837xx[^]

Regards,

Chatura Dilan

2 frameworks on 1 machine

gtu12285510-Apr-06 14:27

gtu122855

10-Apr-06 14:27

Can you have 1.1 and visual studio 2003 and 2.0 and visual studio 2005 on one machine without everything going wonky?

Re: 2 frameworks on 1 machine

Joshua Quick10-Apr-06 15:16

Joshua Quick

10-Apr-06 15:16

Yes. Visual Studio 2003 and 2005 can coexist on the same machine.

Re: 2 frameworks on 1 machine

CWIZO10-Apr-06 20:37

CWIZO

10-Apr-06 20:37

Please do not corss-post!

--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

i don't know

SVb.net10-Apr-06 13:30

SVb.net

10-Apr-06 13:30

i have a problem with vb.net 2005.
when set localization = true on a form and add databinding to textbox.text and write on load_form event
fill(dataset) i can see my data )( my database has data)
and when change the property localization = false
i can see my data
some body help me
.....

123

Re: i don't know

Chatura Dilan10-Apr-06 17:16

Chatura Dilan

10-Apr-06 17:16

What don't you know?

Chatura Dilan

-- modified at 23:45 Monday 10th April, 2006

Re: i don't know

Colin Angus Mackay10-Apr-06 22:28

Colin Angus Mackay

10-Apr-06 22:28

What do you expect to happen?

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog

(null) not a valid win32 application

Arag0310-Apr-06 6:46

Arag03

10-Apr-06 6:46

this massege show after day or two day on more for customers
this massege is :-

(null) not a valid win32 application

then program not open

please send me solution it

Ahmed

Re: (null) not a valid win32 application

Christian Graus10-Apr-06 15:28

Christian Graus

10-Apr-06 15:28

It's virtually impossible for anyone to provide an answer based on this, unless that's the message you get when .NET 2.0 is not installed on the target machine.

Does your app do any sort of error logging ? Perhaps you should add some.

Christian Graus - Microsoft MVP - C++

Re: (null) not a valid win32 application

Joshua Quick10-Apr-06 15:39

Joshua Quick

10-Apr-06 15:39

I suggest that you look this up on http://support.microsoft.com[^].

Here's a good starting point. I've found a bunch of hits having this error message.
http://support.microsoft.com/search/default.aspx?qu=not+valid+win32+application[^]

They suggest that this could happen if the exe (or the exe in memory) has become corrupted. Possibly due to faulty hardware?
My recommendation is to try running this app on a different PC and try to reproduce the same issue.

-- modified at 21:48 Monday 10th April, 2006

requiring soure code for direct exchange of xml to relational database

sowbarnika10-Apr-06 6:16

sowbarnika

10-Apr-06 6:16

pls i need the help immediately pls help me to generate the source code for direct exchange of data between xml and relational database by using mapping rules in xml.very urgent pls

aiyshu

array increment in vb.net

pankajgarg1210-Apr-06 3:40

pankajgarg12

10-Apr-06 3:40

I want to increment the size of array at run time and also want to preserve the data already existing in the array.
Please help me
Thank You
Pankaj

Re: array increment in vb.net

Joshua Quick10-Apr-06 15:36

Joshua Quick

10-Apr-06 15:36

"ReDim Preserve" will do this for you. For example:

Dim myArray() As Integer = {5, 10, 15}<br />
ReDim Preserve myArray(3)<br />
myArray(3) = 20

See this MSDN article for more information.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vastmredim.asp[^]

Re: array increment in vb.net

pankajgarg1210-Apr-06 18:43

pankajgarg12

10-Apr-06 18:43

Thank You

DatagridView Master/Detail

alwinSCH10-Apr-06 3:22

alwinSCH

10-Apr-06 3:22

Hi,

In my new project(VS2005) i want to create a datagridview and in that view
a new datagridview!
But i don't know where to start

I know i have to use some sort of relationship with the dataset, but i don't know the rest!
I want to display a row With in front of the row a + (Like in Explorer)
which you can expand (-) and see for this new a new datagridview inside the other with the child
rows.
Example :

Row 1 --> Customer, name, ...
Row a --> orderid, item,...
Row b --> orderid, item,...
Row 2 --> customer, name, ...

Does anybody have an example or an article about this

Thanks
A.

colored columnheader

Greeky10-Apr-06 3:19

Greeky

10-Apr-06 3:19

is there any easy way to paint a column header?

if not i will set UseItemStyleForSubItems of listviewitems for specific subitems that located at the columnheader which i want to paint;then set backcolor of that subitem to any color.

dont focus next controls

Greeky10-Apr-06 2:15

Greeky

10-Apr-06 2:15

Protected Overrides Sub OnEnter(ByVal e As System.EventArgs)<br />
        MyBase.OnEnter(e)<br />
        If Not Me.ReadOnly Then Me.BorderStyle = Windows.Forms.BorderStyle.FixedSingle<br />
End Sub<br />
Protected Overrides Sub OnLeave(ByVal e As System.EventArgs)<br />
        MyBase.OnLeave(e)<br />
        If Not Me.ReadOnly Then Me.BorderStyle = Windows.Forms.BorderStyle.Fixed3D<br />
End Sub

After adding this code, when i try to shift next control by pressing tab key ; why cant i focus to the next control ?

OVERRIDE READONLY PROPERTY OF TEXTBOX

Greeky10-Apr-06 0:47

Greeky

10-Apr-06 0:47

How can i override readonly property of Text Box

Public Overrides Property [ReadOnly]() As Boolean -- this doesnt work it says it is not overridable.
Is there any other method except controlling keypress,keyup,keydown events?

Re: OVERRIDE READONLY PROPERTY OF TEXTBOX

J4amieC10-Apr-06 1:01

J4amieC

10-Apr-06 1:01

Override it to do what exactly? Change the visual look of readonly fields maybe?

Re: OVERRIDE READONLY PROPERTY OF TEXTBOX

Greeky10-Apr-06 2:08

Greeky

10-Apr-06 2:08

IF value is TRUE, i'll set TabStop to FALSE.

Re: OVERRIDE READONLY PROPERTY OF TEXTBOX

J4amieC10-Apr-06 2:38

J4amieC

10-Apr-06 2:38

protected override void OnReadOnlyChanged(EventArgs e)
{
	this.TabStop = !this.ReadOnly;
	base.OnReadOnlyChanged (e);
}

VB.net help

Ron.S10-Apr-06 0:29

Ron.S

10-Apr-06 0:29

hi there
whil i open an input file which is huge in size , if some popup occurs in between the loading fails , if i break and try to find the error it is not giving any source code what might be the reason???

thanks in advance..
Bharath.S

bharath.s

Re: converting a report to PDF and saving it(in VB 6.0)

dex58ter10-Apr-06 0:10

dex58ter

10-Apr-06 0:10

To answer ur question,yes i'm updating my database.I have been trying to use the ".preview" function i.e
datareport1.preview (but there's no such function I can only get .show function)
Can you also plz show me how to convert a datareport into a PDF file and save it or how i can manupulate the exporting facility on datareports to enable exportin to PDF

Your responsibility determines your authority which in turn specifies your teritory

very urgent change color a cell in datagrid

vipinpaliwal19809-Apr-06 23:55

vipinpaliwal1980

9-Apr-06 23:55

hi,
i want to change a cell color in datagrid.pls help

sdfsdfsdfs

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