|
Rharzkie wrote: please help me...its about vb.net
Really ? Here in the VB.NET forum ? Seriously, try putting a meaningful subject line.
Rharzkie wrote: How can view in the datagrid all of the students who enrolled in that class.
By doing a SQL call to get that data, and putting it in a control like a gridview. What is your data store ?
Rharzkie wrote: please reply as soon as possible.
See, that's just rude.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
ok, sorry, its my first time here...
i just made database in access, the database is composed of different tables: file maintenance of the students, then the different subjects...
how to do an sql call to get the data???
in my module, the user will need to click the search button to search for the the different subjects. then, if you click it, all of the students who enrolled in that subjects will be view in the datagrid...
how can i do it?? i made a separate database for that. I think, i need to make a query for that, but i dont know how.
|
|
|
|
|
There are classes built into .NET for database access, there's tons of info on the web, google 'VB.NET Access database'. If you don't know how to write the SQL, then you need to buy a book and work through it, you're after the most simple SQL line there is.
Rharzkie wrote: I think, i need to make a query for that, but i dont know how.
Yes, you need to take the string and pass it to a query that searches for it. Again, you're asking very much beginner SQL questions, you need to buy a book and learn from it, so you have some understanding of what you're trying to do.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
i just wanna ask again, about what i posted last night... I made a 3 database in access, then how can I connect those 3 database to each other.
I'd use the OleDbDataAdapter. In the data adapter configuration wizard, in the query builder, will i choose those 3 database so that it will be connected?
|
|
|
|
|
As already stated, it's important to read the forum guidelines. We have had a ton of 'bad posts' lately. Some of the highlights:
1. Don't use words like 'need help' or 'urgent' in your message titles. Give them meaningful titles like 'having trouble connecting to DB' or whatever.
2. It makes it easier for us to help you if you post some of your code so we can see what you have, where you are going wrong/right, etc.
______________________
stuff + cats = awesome
|
|
|
|
|
Hi,
I have a schema which reflects a table in the database.
I've just added a field to the schema table, called Watermark.
I've built the library.
But when I access it in my main project, the intellisense works:
reportSchema.Dataset.tblReport(recordnum).Watermark
But at runtime, I get an error:
Watermark is not a member of tblReportRow
I've tried removing and readding it a few times.
Its like the autogen code in vs2005 hasnt updated everything.
Anyone seen this before?
|
|
|
|
|
Mark06 wrote: I've just added a field to the schema table, called Watermark.
Did you just add this field to the database only?? The designer will not know this happened and hence, won't regenerate the code you're talking about. You either have to scrap your existing dataset and drag the table to the desginer again, or you have to modify the designer generated code by hand to add this field and all the support for it.
|
|
|
|
|
is there any program that finalize the application of vb2005 in order to launch in any computer ?
as setup factory !
urgent
|
|
|
|
|
Visual Studio includes a setup project type - Add that to your solution.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
is there any example for that
|
|
|
|
|
google not working where you live ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Well since it appears that Google is down where he lives I at least took the time (for some odd reason) and did a Google Search[^] for him.
magedhv,
Hopefully Google will be up and running in your area again soon.
"Well yes, it is an Integer, but it's a metrosexual Integer. For all we know, under all that hair gel it could be a Boolean."
Tom Welch
|
|
|
|
|
Hi all
I Want to run ppt(powerpoint) in half screen and show picture in another half screen.
is it possible from ActivexControl.
I am working in VB 6.0. Plz help Me
Raghvendra Kumar
Raghvendra Kumar Roy
|
|
|
|
|
Hi
Is can you not add a reference to ppt object then open it up from there (it is a COM object):
http://msdn2.microsoft.com/en-us/library/aa220907(office.11).aspx
to create the application. Then use this resource to get the desired effects:
http://msdn2.microsoft.com/en-us/library/aa213568(office.11).aspx
This provides a complete overview of the power point object model so you can use its functionality to get what you want.
I am sure there will be an activex control but I have only ever done it this way so can only offer this help.
Hope it is of use
Dan
|
|
|
|
|
Is any other Way?
Raghvendra Kumar Roy
|
|
|
|
|
If you're not willing to do it the way that has been suggested, then I'd recommend black magic, it's as likely to work as anything else, once you've excluded the right way of doing things.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
I am using an SQLDataadapter in my app, with a query. Something along the lines of:
SELECT * FROM MyTable WHERE MyTable.MyField IN ('ABC', 'DEF', 'GHI')
The number of items in the IN bit is variable as well as their respective values.
Usually with a parameterized query I would use @MyParameter in the query and then
SDA_MyAdapter.SelectCommand.Parameters("@MyParameter").Value = "ABC"
This doesn't work however when I try:
SDA_MyAdapter.SelectCommand.Parameters("@MyParameter").Value = "ABC, DEF, GHI"
Can I use this principle at all in this case, and if yes, then how?
If not, then how else can I do it using good VB.NET practices?
All help and suggestions appreciated,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Not sure, but is the problem occurring in any other test cases, such as ones without the , being used...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi Paul,
I have tried the following variants:
- "ABC,DEF,GHI"
- "ABC, DEF, GHI"
- "'ABC','DEF','GHI'"
- "'ABC', 'DEF', 'GHI'"
In all cases the hard coded query will return results but not the parameterized one.
How would you propose to do it without commas?
Best Regards,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi,
I have coded a small desktop based windows app which parses a flat text file and generate a word document with some values from the said file. The code contains lots of loops and huge string manipulation and its 438 lines of code. The problem is when I checked task manager, its eating memory worth 20MB !!
So, any ideas, suggestions, checklists in this situation how to decrese occupied memory by the program from string manipulation perspective?
--------------------------------
**** JOB23743 Submitted ****
|
|
|
|
|
Arindam Giri wrote: The problem is when I checked task manager, its eating memory worth 20MB !!
And.... If it was eating 20Gb I'd be worried, but 20Mb is nothing. Also, remember that what you seen in the task manager is the amount of memory the application has reserved from the OS. Not what is actually used.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
Thanks Colin.
--------------------------------
**** JOB23743 Submitted ****
|
|
|
|
|
intensive programs use 150 +, you've got nothing to worry about, if it was that i'de be worried, but 20 is ok. Task manager also isn't always accurate, as was said, it is what is eserved and often a little extra as a buffer.
Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"
|
|
|
|
|
Thanks.
--------------------------------
**** JOB23743 Submitted ****
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
