|
Create a proper data layer, with proper data access code, where you can run any SQL you like.
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 )
|
|
|
|
|
DataAdapters only work on single tables. You'll have to write the data layer code to support this query, and it updates, yourself.
|
|
|
|
|
Thanks Dave,i want to Join these two tables, but the second table, that has onyl two field, i dont want to update them, i only want to update the First one in the adapter.
can i create a Procedure for the first and create one Procedure for Update, insert, delete?
please post a link on data layers, remember am new
Vuyiswa Maseko
|
|
|
|
|
The DataAdapter, if used with a xxxCommandBuilder object, will take the initial SQL SELECT statement and build the other three queries from it. If it references more than one table, the other three queries cannot be built. In that case, you will have to provide SQL xxxCommand objects for the other three queries.
|
|
|
|
|
Am still new to Vb.net even i got Successfullfy Finished some small Projects. Dave when it comes to DataLayer, i have no Experience, i tried to google the data layer. but did not get a clear Answer, all i see are Opps codes that has nothing to do with SQl, please point for me a Thread or an article, or site that can help me understand the data layer and and in my situation , having two tables joining them , but the update should be done in one table.
Thanks Dave
Vuyiswa Maseko
|
|
|
|
|
The data layer is simply a class, or collection of classes, that does nothing but interact with and maintain the database. It's where all of your SELECT, INSERT, UPDATE, DELETE, queries get executed from and it passes the results back up to the business logic layer, and sometimes the UI layer, like if you were filling controls with selectable data.
|
|
|
|
|
I dont like plain VB.NET Forms to create a user interface.... i want the forms to be more colorful jst like windows media player 11;)
(Jameel)
|
|
|
|
|
That's called skinning, not themes. Basically, it involves a lot of owner drawing. I think there are articles on this site on how to skin an app
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 )
|
|
|
|
|
Thanx for reference Christian Graus;)
(Jameel)
|
|
|
|
|
anyone know of good c# to vb.net converter (free)
I know a few sites that will convert code but I'd like to be able to convert a project. My college works in c# but my boss wants us to work in vb.net so now I have to convert his code
|
|
|
|
|
A programmer who works in C# and a manager who likes VB - how ironic.
There are some free tools on this site, but you get what you pay for, the commercial ones are going to work better.
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 )
|
|
|
|
|
Sharpdevelop comes with a converter. It is free, so like Christian said, you get what you pay for.
TDDragon wrote: My college works in c# but my boss wants us to work in vb.net so now I have to convert his code
Huh? I thought you were converting from C# to VB.NET? What does your college work have to do with your boss's work?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Well my boss is the one who detirmens what we will do how we will do it and when
At the start of the project he toled my college (just as he told me) we were werking in vb.net but my college started in c# anyway so now I had to convert his code to vb.net
the reason my boss wants us to work in vb.net is that we are a small software firm that untill very recent only worked in access (vba) and to learn c# with a vba background is more difficult than to learn vb.net
granted they will have to learn the framework anyway but at least vb.net and vba have a simular syntax.
hope this explains
Paul Conrad wrote: Huh? I thought you were converting from C# to VB.NET? What does your college work have to do with your boss's work?
|
|
|
|
|
Hi Ryan,
You can look into TableStyles en ColumnStyles. Just look at the properties of your datagrid and you'll find it. You can map a TableStyle to a dataset or something, and next the ColumnStyles to the dataset's columns. Simply add only a ColumnStyle for the columns you want to display.
You will have to take care of the value in the "hidden" columns by code though, or else you'll receive NULL errors and such.
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Thank You. Johan. But I'm not getting paid for this.
Also, what sql string should I write? "SELECT * from member" only, or "SELECT * from member where memberID = 'txtMemberID'" where the txtMemberID is the new member's id on the form.
Or if possible, please tell me how to do this datagrid step by step. Thank You.
Ryan
|
|
|
|
|
Hi Ryan,
alurora wrote: But I'm not getting paid for this.
Perhaps you misinterpreted my quote, otherwise I don't understand...
alurora wrote: what sql string should I write?
I can only guess at what it is exactly that you are trying to accomplish, so I suggest you consider what sort of user will be using your application and what they want to see / what they are allowed to see / what it is you want them to see.
As for the datagrid, from your original question I understood that you have a form with a datagrid on it, and hopefully a dataset that you fill with data from your tables.
If so just select the datagrid in the designer, and look at its properties. There you will find a property called TableStyles.
If not, what do you have so far?
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi all,
I have a project that converts different files in to a PDF Document. For that i have used a third party dll(ABCPDF.DLL). The projects works fine in my PC. When i publish This as a smart client application, this works fine in machines that have ABCpdf installed. But in other machines it gives the following error
Unable to install or run the application. The application requires that assembly ABCpdf Version 5.0.2.0 be installed in the Global Assenbly Cache(GAC) first.
So i have tried in another way. In the publish tab of the project properties, there is a button application files, inside that i have changed the publish status of ABCpdf.DLL from Prerequisite to Include. Then published the application. Then also it gives error. Now the error message is
SmartPDF has encountered a problem and needs to close. We are sorry for the inconvenience.
Please tell me how to solve this Problem
Thanks in advance
Sebastian
|
|
|
|
|
SO what other .DLL or .EXE files does this ABCPDF.DLL library depend on?? That's probably why your app is crashing.
|
|
|
|
|
Thanks Dave for your reply.
I will look in to this point and get you back soon....
Thanks & Regards
Sebastian
|
|
|
|
|
Hi Dave,
As you said, abcPDF.dll refers MSCOREE.DLL, and this refers KERNEL32.DLL and this refers NTDLL.DLL.
Can you tell me what should i do to resolve this issue?
Thanks once agian.........
Sebastian
|
|
|
|
|
mscoree.dll is part of the .NET Framework. If the .NET Framework that the component expects isn't installed, you need to install it.
Also, you can NOT have two different versions of the .NET CLR loaded into the same process at the same time. If this component is written under 2.0, you can't use it in a .NET 1.x app.
As for anything else, you'll have to get with the manufacturer of the component for any further support on it.
|
|
|
|
|
Thanks Dave, Thank you very much.
with best Regards
Sebastian
|
|
|
|
|
how to create password and username using vb.net. i would like to save the username and password in microsoft access.. pls help with the coding....
|
|
|
|
|
Well, a password and a username are both strings, so I guess the easiest thing is to create a table with two columns, and make them both strings.
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 )
|
|
|
|
|
This is very straightforward. Like Christian said, both username and password would be strings, and stored in the database as text fields in Access. Encrypt the password using an encryption algorithm of your choice, preferably one that isn't crackable like DES...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
