|
I am using the following code
Dim con As ADODB.Connection
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
con.Provider = "Microsoft.Jet.Oledb.4.0"
con.Open "C:\Documents and Settings\Administrator\Desktop\Sandy\db2.mdb"
rs.Open "select * from student", con
Set dg1.DataSource = rs
the error is The rowset is not bookmark
|
|
|
|
|
Reposting your question every 2 hours until someone gives you the answer you want, will only get you ignored...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Try specifying the cursor location. Add this to your code:
Dim con As ADODB.Connection
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
con.Provider = "Microsoft.Jet.Oledb.4.0"
con.Open "C:\Documents and Settings\Administrator\Desktop\Sandy\db2.mdb"
rst.CursorLocation = adUseClient
rs.Open "select * from student", con
Set dg1.DataSource = rs
IIRC, Access databases don't support server-side cursors...
Dave Kreskowiak
Microsoft MVP - Visual Basic
-- modified at 11:58 Thursday 4th May, 2006
|
|
|
|
|
Dear Sir/Madam,
I am design an VB.Net application for a project and I am using data grid. Can I split the data grid to fixed a column and row heading like we do in Microsoft Excel?
What is the code and command for that?
Regards,
Sithy
|
|
|
|
|
Suddenly the error appear and i don't why....
Query Engine Error:'C:\Documnet ...... \Temp\tem_1edd79...etc.rpt
Help!
Militiaware
Faris Madi
|
|
|
|
|
|
Or you can try to find an answer on the Support forums at http://www.buisnessobjects.com[^]. After all, they wrote Crystal Reports.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have a MainMenu with multi MenuItem on it. I want to disable that menuitem when that childform open. And enable that menuitem when childform close. How can I control it. Plz help me Thanks a lot.
|
|
|
|
|
Build one function in MDI like this
Public Sub SetMenu(Enable as boolean)
mnuITem.enabled=enable
end sub
and call this from mdiChild
like me.Parent.SetMenu(True)
|
|
|
|
|
Dear Sir/Madam,
I posted my first question here yesterday and received some advice on that. But the result is still empty. For clarity sake: I designed a database application by using VB.Net as interface and SQL Server 2000 as back end data stored. My clients wants to use the local language, Khmer or Cambodian.
The data type for the text string is NvarChar. For example I want to search for a particular person by his/her first name:
I wrote the typical query statement but the result is empty. But when I double check the data stored in the table, there exists such name. I tried to use the "N" keyword, it's still doesn't work.
What is the solution to this situation? Will it support for searching using "like" key word?
Sithy
|
|
|
|
|
how can i call one form's procedure from another form.i have created an object of first form and call ,it works but the values in the first form is not changed.
|
|
|
|
|
I guess You are using VB.Net...
It wont update because they are different objects...
|
|
|
|
|
If they are both of the same type, you can make the method static, which would mean it can't access any member variables. Either way, you can use delegates to hook methods between classes.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi All
I am having a requirement to apply for a font (Frutiger 55 Roman) over my label on a windows form. I have installed this font and I couldn't see in the Font dialog box of the label property section during design time.
I have tried to apply this font during run time, but also I didn't get that font and instead Microsoft Sans Serif font has come.
How can I apply this new font over the label?
If any one has solution please share it with me.
Thanks in advance
Arunag
|
|
|
|
|
You can the get the available fonts in VS using
comboBox1.Items.AddRange(FontFamily.Families);
To change the font
label1.Font = new Font ("Courier", 10, FontStyle.Bold);
|
|
|
|
|
If your font doesn't show up, it's possible that it's corrupted.
Try going into the Fonts folder in C:\Windows and seeing if the font is listed, then double-click it to get a "test" page showing your font.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hi there,
i am using xml data as the database. i am getting the output in xml format, i want that to be viewed in richtextbox and that should be arraged properly for better vision.
thanks in advance
bharath.s
|
|
|
|
|
I have a color picker control on a form VB.Net form. When I select a color it changes the color of the txt on a label on the form. How can I save this value to the underlying Access database? The form and it's fields are already linked to the dataset, table and database etc.
Basically I want the end user to be able to pick, then save say the company's color to the database.
1. What "type" field should the field in the Access table be?
2. What code do I use to commit the selected color's value to the database?
DSS
|
|
|
|
|
The type is an 32-bit Integer. You then have to get the value of the color your user picked as an Integer, then just save that value.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
how do I make richtextbox.savefile append to a file?????
|
|
|
|
|
RichTextBox1.SaveFile (any file you want)
E.g.: RichTextBox1.SaveFile (“C:\myfile.rtf”)
You can load it by
RichTextBox1.LoadFile (“C:\myfile.rtf”)
Regards,
Chatura Dilan
|
|
|
|
|
That overwrites the existing file.
I want to append to the existing file.
|
|
|
|
|
It can't be done using the SaveFile method. It only overwrites.
IIRC, because of the format of an RTF file, you have to load the file you want to append to, add your new data to the end of that, then resave the file, overwriting the entire file with the new version.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Can any body help me out here.It's urgent.
I am using crystal report 8 and vb.net 2002. I want to display photos or images at runtime within crystal reports based on some criteria. For examplae display employee photos based on employee ID provided at runtime.
Can u please email me the solution at sam.pinnacle@gmail.com.
Thank you
|
|
|
|
|
your images are in the database or in specific path?.
you can bind directly to the report if it is in db.
or u need to insert picturebox to do manual
raj
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
