I added some fields to a table in my Access database which is the dataset in my VB.NET 2008 project. So now I'm going to have to re-configure the dataset. (Data/Show data sources/configure dataset with Wizard - at least that's the way I know to do it). Will this wipe out the exixting queries in my table adapters? Even on tables that have not been changed? If so, is there any way to avoid this?
View 1 RepliesHow do you query a Dataset with SQL queries? I'm using VB with Visual Studio 2005. I've got a large library of SQL queries I'd like to run in-memory on a Dataset.All the examples in the documentation show how to "query a dataset with code," but none show how to run a simple SQL query against a dataset. I've seen other threads that say you can do so, but no code examples. Can anyone provide sample code to show how you would run a simple SQL "Select..." query (using the same syntax you would use to query a database) on an in-memory dataset?
View 3 RepliesI want to avoid the creation of SQL queries inside the dataset. Here's the screenshot:
Dim search_by_dateofcanvass = sqlcomm.CommandText = "SELECT [#], Material_Name, Brand, Unit, Discount, Supplier, Category, Date_of_Canvass, City, ListPrice, Material_Description, NetPrice, Area FROM CanvassTable WHERE (Date_of_Canvass = " & DTPcanvass.Text & ")"
Me.CanvasstableTableAdapter.search_by_dateofcanvass(Me.FinalDatabaseDataSet.CanvassTable, datepick)
By the way that query can be use to search for date.
I need to loop through a gridview to find records that match items in a different table (in SQL). Is the best method to loop through the gridview and call an SQL procedure on every loop to find matching records? Or should I pull the entire sql db into a datatable and query the dataset in my gridview loop?
'find source ID based on make/model/serial No combination.
Dim cSource As New clsSource()
Dim ds As DataSet = cSource.GetSources()
[Code].....
I have a vb.net project where I have data loaded into a datatable in a dataset and have to do approximately 20 updates that are sql like. On this project, I don't have access to sql nor does the end user want to use any type of sql, sql express etc.
My question is, is there a generic way of doing this so I can reuse it. Was wondering if a dataview could be analgous to the "WHERE CLAUSE" and some type of delegate function could be the update function.
[Code]....
I have a vb.net project where I have data loaded into a datatable in a dataset and have to do approximately 20 updates that are sql like. On this project, I don't have access to sql nor does the end user want to use any type of sql, sql express etc
View 2 Repliessomehow combine the results of separate Fill queries on a single dataset?Basically, I'm trying to implement a 'Filter' function, whereby, the user can filter the records in a DataSet according to specific criteria.
View 4 RepliesI am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
How to reconfigure code to output specific values rather than collection
View 2 RepliesI currently this code on my app that works great to loop through a page and grab the label of an input value of a form and then print the value to a rich text box.I am now trying to revamp the code to give me the ID the value if the label contains a specific name.For instance if the label before the input field contains the word Username then I want the application to output the ID of the input field rather than just everything that has a label.
Here is my current code:
Dim web As HtmlAgilityPack.HtmlWeb = New HtmlWeb()
Dim doc As HtmlAgilityPack.HtmlDocument = web.Load("http://shaggybevo.com/board/register.php")
Dim nodes As HtmlNodeCollection
[code]....
I want to detect if a user has alt-tabbed to an other application, so that I can auto pause my application, or let my application blink in the taskbar. Problem is that I can't figure out when someone has alt tabbed to an other application or has clicked an other application.
View 1 Repliesi have this form, lets call it form1, i dont want the user to be able to click outside the form or let the form lose focus, kind of like when you are setting an options for a program and you click outside of the options settings and the options dialogue box flashes and refocuses your mouse on it and wont let you click anywhere until after you hit ok. i also dont want the user to do a cntrl + alt+ delete and open that options box thing that takes over your screen
View 2 RepliesI have a VB method
Public Sub append_text(ByVal s As String)
f1.TextBox1.AppendText(s)
End Sub
which is called over COM from C++
_bstr_t b(L"test
new
lines
");
ATLENSURE_SUCCEEDED(t->append_text(b));
But the text box ends up saying
testnewlines
Without the aforementioned new lines.Why is that then?
been struggeling with this issue for quite some time now. I`ve got aan combobox on a detailform.
[Code]...
i'm making a astoroids clone and i use pointF to store units position, but they lost y value on events like form.losefocus(i think)Is there any ways to prevent this?
View 1 RepliesI'm not sure where should I post this as this is not really related to VB.NET but since I'm always here(in the VB.NET section) I'm gonna ask here.How do I make an icon that won't lose it's quality? I tried so many dimensions already. 32x32, 250x250, 16x16, 64x64.It will lose it quality on Desktop and taskbar. An icon like the IE's, Visual Studio's, Google Chrome's icons.. icons that doesn't lose quality.
View 9 Repliesif the last 4 chars in my string(result) are " AND" or the last three chars are " OR" I would like to remove these from the string. So far I have am trying result.trimend and a few other methods but am unsure how to get it working.
View 3 RepliesI have an Unhandled Exception handler that does something like this[code]...
So it looks like from the "add" that the last person that subscribes to Application.ThreadException is the one who gets it (it's not additive as most event handlers are). I don't want to give up my subscription to this eventhandler no matter what. Can anyone think of a way that I could track when I lose my subscription to the Application.ThreadException so I can steal it back from whoever stole it from me?
I'm use Somee host.And here is my page [URL] While page in debug mode it still remeber new rss I'm add on(All cookie is work).But when I upload to host and add new rss , my page lose all cookies in this code after re open browser (exceped 1 cookie befor this code).
Sub EvShowUpdate(Optional ByVal Message$ = "")
Dim Ex = If(Message IsNot "", Message, _
Me.Request.Cookies("RssLink").Value.Decode).Split(",")
If Ex.Length < 2 Then Me.GoToPage("/") : Exit Sub
[code]....
I want to develop an app which won't allow the user to open or jump to another application while it is open. It should be in Visual Basic. For example, if my application is open (running) and the user tries to open any other windows application like "media player" then it shouldn't open. The app should not even allow "task manager" to run. The application should completely block the windows environment while it is running.
View 2 RepliesI've got a lose focus textbox which when data in entered and the tab key is hit the code is executed as expected and a message box appears informing the user of the outcome. However when I used a barcode scanner with a tab function embedded, the code is executed and the data is inserted into a database but the textbox to say if the request was successfully completed or not does not show as expected.
View 1 RepliesI have a serializable Message class that has a Data As Object property that I'm using as a generic holder for information to be sent via a system that uses a combination of push technology and/or IPC to communicate with any other programs that are interested in the information. This allows the communication piece to be agnostic of the information it transmits.
I was serializing this Data As Object as a Byte[], since I was worried about how an Object being serialized and transmitted across the network would behave on the other side. However, when deserializing I get errors about being unable to find the assembly for the types stored within my Data As Object property, because I'm deserializing in the assembly that contains the Message class... not the assembly that contains the type that Data As Object originally was.I was wondering if I'd lose the type information and be unable to cast it back to the type I want at the other end. Perhaps it's not possible to pass a type as an Object via another assembly without it knowing about my type?
I have an about form which I hope it can close by itself if I move the mouse to somewhere else. I try form_lostfocusevent but unfortunately this can NOT be done
View 8 RepliesI have this rather annoying problem when printing in VB.NET. I use the PrintDocument object and after it has done its job, the form gets minimized to the taskbar. I tried to force the focus on the form but to no avail. I was just wondering if someone else has encountered this problem and maybe has a solution for it?
View 6 Repliesi want my form to save to the database every time a control lose focus. can i make it global or do i have to code it for each and every control i have?
Private Sub TextBox10_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox10.LostFocus
Me.Validate()
[Code]......
I have 2 forms. I want to close Form1 without closing the entire application but it doesnt work. It closes the whole application even though i say Form2.show()[code]When it reaches the End Sub then it closes the application.
View 6 RepliesIf I declare my object at the beggining of my page class, and instantiate it in a dropdownlist selected_index change event. Shouldn't this object be available thru out the entire page and also persist thru a postback? I lose the object in my selected date change event in my calendar.
[Code]...
I made a change to a project and hve induced a major problem. I have warnings and errors now, but I can still debug the project with the "last successful build" Iwould like to just revert everything to that build but I can't find a way to eliminate the problems I induced or find a way to go to a earlier build. Hopefully I can get back to an earlier version or I will loose the entire project as I can no longer get to the designer.
View 5 RepliesI have a Access 2003 backend db and I'm using vb 2005 to connect to the db via conntection string. It works ok! I can see all the tables but only some of the queries. Why should some queries be absent? In 1 query I have a user define function which cuts up a string. I've created a new VB project with a new connection but the same result. I've compacted the database with not change.
View 2 RepliesI am trying to UNION the two queries below without success.
Dim
ds1
As
New
DataSet
Dim
MyConnection1 As
New
OleDb.OleDbConnection(GetPOWERConnectionString())
[Code] .....