|
How To use a component that is present outside the current working environment.
How deos the DataAdpter,DataSet work together in establishing connection between VB.NET and SqlServer2005.Explain with example
trustworthy
|
|
|
|
|
somunu wrote: How To use a component that is present outside the current working environment.
No idea what you mean
somunu wrote: How deos the DataAdpter,DataSet work together in establishing connection between VB.NET and SqlServer2005.Explain with example
ADO.NET works in a very simple and well defined way - some classes handle connecting to the DB, others handle creating a representation of the data returned. Have you got any books on the topic ? Have you tried google ?
What you're asking is not clear, in both cases.
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 All
i want to Deploy my application, am using Access as my backend.i have included the DB with the application. but now when i install it on a client's machine it reqiures a Database to be in
C:Programfiles\Development For One\Search_Property
How do i Deploy my Application, when it is being installed on a client machine, it should have the correct mappings?
PLease provide Articles or Explanation.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
|
Vuyiswamb wrote: it should have the correct mappings?
What do you expect the "correct mappings" to be?? Where did you want the database to be?? What does the code look like that builds the file path to the database?? Or did you make the mistake of hard-coding the path to the database into your application??
|
|
|
|
|
Dave Kreskowiak wrote:
|What do you expect the "correct mappings" to be??
When i install it in a client machine, it will go to c:\Programfiles\MYApp\mydb.mdb. but now it is looking for that DB in same location where i was Developing. what if i was Developing this application and Saved all my Projects under a different Drive like G:,when i install it in my client machine it will look for a the db in G: drive.
Dave Kreskowiak wrote:
Where did you want the database to be??
i want it to be in the Application Folder, yes i can achieve that, but now, even if i put it in the application folder, it will still look for in my Development drive. i have used a wizard to make a connection to my database and the Db is in my application development directory.
Dave Kreskowiak wrote:
What does the code look like that builds the file path to the database??
i used a Wizard to achieve this, so i did not hardcode the DB mappings
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
|
Vuyiswamb wrote: used a Wizard to achieve this, so i did not hardcode the DB mappings
Yes, you did, by using the Wizard. The full path to the database is probably going to be in the connection string stored in either your application Settings or in your app.config file. I don't know which because I don't use the wizards to do my database work.
|
|
|
|
|
i will remember that.
thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
|
|
|
|
|
I'm getting an error when i load the crystal viewer and my report source is a crystal report that has a datasource of a dataset.
The error is "Error in File C:\Docu~\\temp_7232f9...rpt: Query Engine Error."
The things that I did was I created a crystal report in .net. I have a crystal 9 developer edition installed in my computer. When I tried to run Custom Tool I got an error. so I changed crystaldecisions.vsdesigner to crystaldecisions.vsshell. Then I created a dataset. When I'm trying to add in crystal report the dataset i got an error. so I add in my reference vsdesigner.dll from the crystal report 9 folder in my program files. after that i can already add the dataset in my crystal report. but when i run the viewer and set my report source to my crystal report i'm getting the error "error in file c:\Docu~\\temp....".
Can someone help me to solve the problem without uninstalling the existing crytal report in my system?
|
|
|
|
|
hi all,
i am trying/wanting to just remove or delete a record or element from my array. i have been spending too much time on this area and want to move on. i don't want to use the arraylist syntax because i want to know how to do the removing using a static array.
my array is: arrBooks(20)
any kind of help is much appreciated. thank you
Unicept
|
|
|
|
|
you can use Array.Clear to remove the item, then if you wish you could always resize the array ( you don't have to do that part tho )
eg:
<font color="#008000">'/// say i wanted to remove item 15 in the array<br />
''/// i'd specify the index of the item to remove as 2nd parameter ( 15 in this case )<br />
'/// i'd specify the amount of items to remove from that point as 3rd parameter ( ie: 1 item to remove just position 15 )</font><br />
Array.Clear(arrBooks, 15, 1)<br />
<font color="#008000">'/// then if you wish to resize the arrBooks to account for the deleted item ( s )</font> <br />
Array.Resize(arrBooks, " the new size here as an integer " )
hope it helps 
<--- my signature --->
<font color="blue">Csharp</font> me = (<font color="blue">Csharp</font>)Dynamic_Sysop; <font color="#008000">// My Signature.</font><br><font color="#008000">$twins</font> = <font color="#008000">me.twins</font>(<font color="#800080">"Taylor"</font> , <font color="#800080">"Delta"</font>); <font color="#C0C0C0">// My twin daughters.</font><br>echo <font color="#008000">$twins</font>;
|
|
|
|
|
Simply, you can't. If an element is in the middle of an array, you need to create a new array that is one element smaller, and copy the elements you want, across. Even if it's the first or last item, you need to do this, it's just one copy then. That's what arraylist is for, because you have to recreate your array to remove an item from it.
If you know the right tool for the job, why would you insist on trying to use something else ?
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 )
|
|
|
|
|
If you are using .net 2.0 and want this functionality available easily you can use a generic list
Dim books As Generic.List(Of myType)
Dim item as new myType
'Add an item to the list
books.Add(item)
'remove an item from the list
books.Remove(item)
'Remove item at index from list
books.RemoveAt(1)
Hope that helps
|
|
|
|
|
Hi
I have done this in my previous project successfully. Now I am doing this again on my current project and it does not display groups. although ShowGroups property is set to true with view property = details.
The code is
Dim lg As System.Windows.Forms.ListViewGroup = lvAll.Groups.Add("abc", "abc")
Dim lstSC As New ListViewItem("xyz")
lstSC.SubItems.Add("xyz1")
lstSC.Group = lg
lvAll.Items.Add(lstSC)
' where lvAll is listview name
I copy pasted the listview control from my previous project incase I am missing any property but it does not work.
Any Suggestions would be highly appreciated.
Regards
|
|
|
|
|
ListViewGroups only work on XP or above. They don't work on Windows 2000 and below. In addition, you're application must have previously called Application.EnableVisalStyles() and the ListView's View property must be set to anything other than View.List in order for groups to work.
|
|
|
|
|
Many Thanks.. It works 
|
|
|
|
|
i m developing an application and 50% completed bt the memory usage at this time is too high its abt 40MB  y is that so? how can i solve the problem?
(Jameel)
|
|
|
|
|
use less memory.
What other advice did you hope for, you've not descibed your app at all. 40MB is not a whole lot, given that it includes the runtime. I think you need to just relax, in all likelihood
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 )
|
|
|
|
|
Is there any spacific shared folder in windows for which every(admin,guest,other etc) user have write/read access....
(Jameel)
|
|
|
|
|
jamilkhan007 wrote: spacific shared folder in windows for which every(admin,guest,other etc) user have write/read access....
Wouldn't System Temporary folders (TEMP) satisfy this criteria? But I don't think they are by default shared, unless you share them explicitly or through an Administrative Share.
|
|
|
|
|
Shared folders?? No, there are none.
You'd have to create a folder, Share it yourself, and set the appropriate permissions on the Share and NTFS sides.
|
|
|
|
|
where do different applications store there file which have to be read/write by different users on the target machine???? my app stores an xml file which contains users password,names etc. and this file placed under C:\prog-files\myapp\users.xml. bt when app tries to write to this file and "access denied" exception is thrwon. Now i hope u can help me in a better way....
Heartly Thanx for all of u frnds.
(Jameel)
|
|
|
|
|
Either in the applications Program Files folder or in
Program Files\Common Files\manufacturer\appname
|
|
|
|
|
hi All again i managed to solve my previous adapter. as Acces does not support substring function, i used Mid instead. so now i have problem in my search button. and the Problem is Poiting to the following line.
damixed.SelectCommand.Parameters("Boundary_Area").Value = cmbboundary.Text
damixed.SelectCommand.Parameters("Lis_key").Value = txterf.Text
i used "mid" function to Extract the value to is needed to be searched. like this
SELECT Boundary_Area, Compl_Boundary_Area, Extension, Current_Values, Improvements_Value, Improved_Value, First_Prop_Address, Lis_key, Num_key, Own_Name, Parcel_No, Parcel_Portion_No, Primary_ID, Prop_Address, Purchase_Date, Site_Value, Street_Name, Street_No, Actual_Extent, Title_Deed_No, Values_Effective FROM Property_ValRoll WHERE (Boundary_Area = ?) AND (MID(Lis_key, 5, 5) = ?)
When i run project code, it tell me that
An OleDBParameter with Parametername 'Lis_key' is not contained by this oledbParameterCollection.
As you can see am connecting to Acces database,i had a same project that is successfully but DB as SQL, so the code will differ in the adapter and in the parameter. So please tell me if its the correct way to get input from a user's textbox and combobox this way? and what is wrong with my code.
Thank you
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
|
Vuyiswamb wrote: damixed.SelectCommand.Parameters("Boundary_Area").Value = cmbboundary.Text damixed.SelectCommand.Parameters("Lis_key").Value = txterf.Text
OleDb doesn't use named parameters. You have to create the parameters and assign values to them in the order they are seen in the SQL statement.
|
|
|
|
|
i understand, please Post an example code.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
