Visual Basic

4-Jan-07 17:48

Initialy i've taken the fileName and i want to take filename's contents the Datas.And i want to directly store in Access Database 2000

How to take the file's condents and one more thing i want to store the file's contents directly in AccessDatabase 2000.so pls some one help me.....

thanking You
somasundaram

Christian Graus4-Jan-07 18:04

Christian Graus

4-Jan-07 18:04

File.GetAllBytes, or something. Then, you need to create a field that can hold the data ( a BLOB? ) and push it in.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

somagunasekaran4-Jan-07 19:34

4-Jan-07 19:34

I've put the code it won't the execute So pls some one help me vry vry Urgent

Thankig you
somasundaram

Christian Graus4-Jan-07 19:41

Christian Graus

4-Jan-07 19:41

What code ?

Are you using VB2005 ? Have you heard of google ? Why is it that so many people need urgently to know how to do something that's widely documented, but are unable to search for it ?

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

somagunasekaran4-Jan-07 19:54

4-Jan-07 19:54

Very sorry,no iam using VB.Net 2003, ok u carry on pls tel me....

I want to join in the website

Christian Graus4-Jan-07 20:00

Christian Graus

4-Jan-07 20:00

OK, then you don't have access to File.ReadAllBytes, I don't believe. The system.IO namespace contains the File object, which you'd use to read the bytes of a file. Then, you just need to google for soemthing like store bytes access VB.NET to get the second half together.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

somagunasekaran4-Jan-07 21:32

Hiding rows in a datagridview

4-Jan-07 21:32

Thank you

Thanking you
somasundaram

steve_rm4-Jan-07 17:46

steve_rm

4-Jan-07 17:46

Hello

using vs 2005

I have a datagridview and i would like to loop through and hide rows based on a cell condition. For example, if the user want to hide all the rows that has "Serviced" in the status column.

code so far

 <br />
dim i as integer<br />
for i = 0 to ds.tables(0).rows.count - 1<br />
if(serviced = true) then<br />
'hide this row<br />
next i<br />

thanks in advance,

Steve

Re: Hiding rows in a datagridview

EldieBongers10-Jan-07 22:09

EldieBongers

10-Jan-07 22:09

Hi Steve

Simply make the RowHeight 0

Eldie

Problem

amaneet4-Jan-07 17:18

amaneet

4-Jan-07 17:18

Sir/Madam,
I am facing the problem in the query implementation in vb.net.Like I have an id that is present in 5 tables(like table1,table2,table3,table4,table5).I have to pick those records from table1 which are not present in tabl15.I mean an id number 1 is present in table1,table2,table3,table4 .but the id number 1 is not present in table5.My final motive is i have to pick all the id like 1.
i am using the query in the following way.

dim str as string = "Select able1.field1,table2.field1,table3.field1,table4.field1
from table1,table2,table3,table4,table5
where
(table1.id<>table5.id and table2.id <> table5.id and table3.id <> table5.id
and table4.id<> table5.id)

it is showing those records that are not present in table5 but present in the remaining tables.
But the problem is , there occured duplicacy.I mean one record is iterating 24 times i the final result.
Please help.
Thanks and Regards
Pankaj

Re: Problem

ChandraRam5-Jan-07 0:58

ChandraRam

5-Jan-07 0:58

amaneet wrote:
dim str as string = "Select able1.field1,table2.field1,table3.field1,table4.field1
from table1,table2,table3,table4,table5
where
(table1.id<>table5.id and table2.id <> table5.id and table3.id <> table5.id
and table4.id<> table5.id)

it is showing those records that are not present in table5 but present in the remaining tables.
But the problem is , there occured duplicacy.I mean one record is iterating 24 times i the final result.

Maybe you should look up the DISTINCT command and use it in your query.

HTH

Chandra

Re: Problem

amaneet6-Jan-07 0:20

amaneet

6-Jan-07 0:20

Thanks

Textbox drop Focus on ENTER key

roo4264-Jan-07 16:50

roo426

4-Jan-07 16:50

Every time I press the enter key after updating the value in a textbox I hear a beep and no events are raised. I would like it to raise the 'leave' event so I can change it's color and transfer focus to an other object. I managed to do it by checking for "vbcr" in the "form keypress event" but is there a better way? Why isn't enter key working on my textboxes?

Hope that was clear as mud!!!! LOL

Rob

Re: Textbox drop Focus on ENTER key

minhnguyen084-Jan-07 20:55

minhnguyen08

4-Jan-07 20:55

You can use Textbox_presskey event. Such as
if keypress =13 then
textbox.background=......
textbox2.focus
end if

Re: Textbox drop Focus on ENTER key

roo4265-Jan-07 2:32

roo426

5-Jan-07 2:32

Thanks, nerver noticed that the textbox had a keypress event too!!!! I stay up to late to program I guess..... LOL But it still doesn't solve my problem of why it beeps when I press enter instead of just updating the control.

Multi-Tab Controlling

MatrixCoder4-Jan-07 16:26

4-Jan-07 16:26

I have searched everywhere but can't find out how to do it. I am trying to create a multi-tabbed program and manage sub controls and content in it.
The program I'm designing is a multi-tabbed text editor, (like EditPad), and I want to manage the textbox inside of it so I can save and manipulate the text.

Is there an article on how to do this? I'm starting to think I'm in over head here. Would it be easier to do this in another language?

Thanks!

Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.

tosch4-Jan-07 21:04

tosch

4-Jan-07 21:04

How about a MDI application?

Tosch

MatrixCoder5-Jan-07 3:48

5-Jan-07 3:48

Thanks, but that's not what I'm looking for.

Any other ideas?

Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.

Enriad6-Jan-07 23:13

Enriad

6-Jan-07 23:13

This is what you might be looking for (Tabbed MDI[^]), though it is in C# (you can convert to vb.net, there are plenty of sites out there that do it if you don't know how). Another option is a control (by Weifen Luo), pre-made which can be found here[^].

Cheers,

Daniel

MatrixCoder7-Jan-07 5:52

how to use marquee property in status bar?

7-Jan-07 5:52

The "Tabbed MDI" article is just what I needed.

Thanks a lot!

Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.

sararaj4-Jan-07 16:15

sararaj

4-Jan-07 16:15

i want to move the text in status bar at the time of form loading

Re: how to use marquee property in status bar?

MatrixCoder4-Jan-07 16:28