C# - Maintaining A DataSet In WinForm App?
Aug 5, 2009I am in the process of converting an in-house web app to a winform app for disconnected reasons and I hit the following snag.
[Code]...
I am in the process of converting an in-house web app to a winform app for disconnected reasons and I hit the following snag.
[Code]...
Winfom, intellsense remind me configurationManager wrong.This code is from asp.net, how can I change it?
unction GetData(ByVal queryString As String) As DataSet
' Retrieve the connection string stored in the Web.config file.
Dim connectionString As String =
[code]......
I need to build a program that combines many different .doc files based on which check boxes the user selects. At first I was going to use the word.document.open(file) way, but I would rather not have to open 40 different files every time the program runs. I then turned to streamreader, which works great for basic text (after I convert the file to .txt) but I can't figure out a way to maintain hyperlinks. I am now thinking that after the streamreader reads all of the data and combines it into one string, it will paste it into a word doc and somehow search for hyperlinks and make them active.
View 1 RepliesMy program references a specific object that is contained in a list. The references point directly to the object itself, instead of its position (index) in the list, since that might change over time as other objects are added/removed. However, occasionally this object is edited, and (behind the scenes) this sometimes involves replacing it with a newly-created object (so the code looks like ListA.item(i)=new testobject...). In which case, if my understanding is correct, all the program references to this object are no longer correct, since they point to the replaced object instead of the new one. So I'm wondering how to maintain the integrity of the references, since the list index is not permanent, nor is the object reference technically permanent. Should I create some ID number for the object, and maintain and use it for references (so the new object would get the old one's ID)?
View 8 RepliesOne of my programs uses transparency so that the form is the shape of the background image (.png). My problem is that everything works and looks fine on the computer I'm developing on (Win7) but when I run the program on my other computer (XP), instead of the transparency I get the background color (which is the same as the transparency color). Does anyone have any experience this problem?
View 5 RepliesI am working on a new domain model for an application that will have order processing for items built in (well, too keep it simple for this question anyway). I have a class "VendorItem" that represents items that can be ordered. Originally the "Order" class was going to have a list of VendorItems associated with it, but I have come across problems with it so far.
Let's say that the system has been creating orders for some time just fine. One day a user comes along and decides that a vendoritem has changed price or some other detail like packaging size. I wouldn't want the previous orders to be affected by such change. At first wash I was going to make a "OrderLine" class that is basically a copy of the "VendorItem" class, but that just feels (smells?) wrong in the OO sense. Is there a better way to refactor this so I don't have copies of classes and information in the domain model?
I have three radio buttons defined within a frame (optRptType_0, optRptType_1 and optRptType_2). I set the checked value to true on optRptType_2 to use as my default. I have the following checkchanged event defined for these radio buttons
[Code]...
When the form opens the optRptType_0 is checked. I am trying to determine why the optRptType_2 is not checked as that is the default I set up. I tried adding the line "Me.optRptType_2.Checked = True" to the Form Load event but it had no affect and the optRptType_0 is still the entity checked when the form opens.
I am converting decimal to binary by:
Code:
Dim i As Int64 = Convert.ToInt64("2")
TextBox1.Text = Convert.ToString(i, 2)
[code].....
I have the [B] [I] [U] buttons and they work to a point but here is the problem I'm having.In MS Word,I can Hilight text and select Bold and it bolds the text, I can then select Italic and while leaving it bold, it Italicizes it.I can then click the bold button again and it will remove the bold but leave the selected text Italicized. I can't figure out how to get this action to work.I know I can OR the styles to apply multiple styles to the text but I don't know how to remove a style while maintaining any others applied.Here's a section of code that I'm messing with.[code]....btw, I am using for the comments so that the code is easier to read.I have tried (in this specific segment) newFontStyle = currentFont.Style And Not FontStyle.Bold
View 1 RepliesI have an issue with maintaining scroll position.I am almost positive that I have everything set correctly. I have updated my web config...
<pages maintainScrollPositionOnPostBack="true"
and everything seems to work fine UNTIL....When ever my Gridview returns a lot of pages, like more than 50, sometimes upwards of 100 or more, I show 50 records per page. The farther into the Gridview, the more the scroll position is off.So what I am saying is that for the first 20 plus pages or so, if I scroll down the page to the point where the top rows have moved off the screen and I enter Edit Mode, the correct record remains in view on Postback.But if I am over say around 30 pages into the Gridview, the further in the worse it gets, when i enter Edit Mode I have to scroll back down to the location of the record that I selected to edit.
I have made an employee list and linked it to an Access database. The initial problem I was having is that in my program I had to link their ID's and names so if you click on an employee in the listbox, his or her's ID would automatically display in the textbox below. Since I did not know how to do so, I decided to make an array and store the ID and names separately while the listbox is being compiled. And so, the form became linked and adding became easy to code.But my problem came in deleting an employee. When deleting the name should be removed from the list, but this is where the order of the arrays messed me up. How do you maintain the order of the array? Here is the code I used. I dimmed 'count' as an integer and it is responsible for keeping that order.[code]You will see Staff_CodeTextBoxes etc. and info_Staff_CodeTextBoxes. etc.These text boxes (not visible to the user) are responsible for holding the data while the array takes the data from it, or adds it's own data to it.
View 4 RepliesQ1)My ASP.NET VB Script will write long writings - like many thousand words into my Access DB but i have previously had problems with the text containing characts such as '.Is there a way of inserting such?
Q2)When I read a database field in consolidates it into my string variable on a single line. What variable type should I use to have it maintain the line spacing and stuff.
I Have a web form in a asp.net web form 3.5. The listview has a checkbox on the item template, I am trying to retain the state of the checkboxes through pagination . Once I can page through records and preserver this state I need to send this to a print page which takes those ids...I have this working, but it will print only the records on each pagination. [URL]
how can this be done, the code below is not working.
Protected Sub ListView1_ItemCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewCommandEventArgs) Handles ListView1.ItemCommand
Dim myButtonPrint1 As Button = CType(ListView1.FindControl("printButton1"), Button)
If e.CommandSource Is myButtonPrint1 Then
[Code].....
A Form is to Accept User Name and Password from user, after verification the form should display another form that will accept user's full data. When a user press the Ok button, the information entered on this form should be display in another form (Showing the user what he/she has entered)
i have Design the Firs Form and the second form, how can i pass the information entered on the second form to third, and also what will the code look like I need help on this or Code Sample?
NB: i am trying create an instance of the second form in the third form and declare a variable in the third form that will holed the value, but still not working I want to learn .NET Programming in VC#, ASP.NET And VB.NET. I am student and really get excited when it comes to programming
Launch a dialogue window from the main form, and then another dialogue window from that dialogue window. If you close the second dialogue window and call dispose the main form vanishes under any other open windows. This doesn't happen by closing a dialogue window normally, but I am attempting (rightly or wrongly) to stop memory useage creeping up by disposing of it.
So, the question is - what method can be employed to maintain the position of the windows?
I have a picturebox on a form. The image in the picturebox is actually a report. I want it so if the user clicks on it it will zoom larger --- while the picturebox remains the same size. Of course, the entire image will no longer be seen. So I also want to be able to drap this image around with the cursor. The examples I've found for picturebox zooming cause the picturebox itself to get bigger and smaller. I need it to be like an Access report. Click on the report and it gets bigger. Click again and it goes back to the full image. Does anyone know of an example or tutorial in VB.Net for this type of zoom-with-fixed-size picturebox function?
View 2 RepliesWhen the user clicks an "Edit" button on my form, I want a box to come up which allows the user to edit a DataTable in a strongly-typed DataSet. What's the best way to do this?
View 2 RepliesI have code running in the Datatable.ColumnChanging event in my dataset. This dataset underlies a form and conventional drag/drop controls are in place for data entry.when the event triggers and runs, I am running code in the form that checks the dataset.HasChanges property. It is showing False. But this is immediately after the ColumnChanging event has been triggered.Okay, I see by others posts and MSDN that .HasChanges will only be true after moving off the row with the changed column. I have also noted lots of discussion about the advanced binding property of DataSourceUpdate Mode, but that does not address this issue.I guess I can do this by checking the state of the row for the binding source. Just seems odd that the event behind the dataset can be triggered and that does not change the dataset.HasChanges property.
View 3 RepliesI have tried everything I can to get beyond this error which shows below as <<<<< error here. It is trying to fill a dataset from a data adapter. If I change the SELECT statement to just SELECT * FROM xTable I get the correct number of records in each table. But anytime I try with a more complex statement I get the error message shown below which indicates System.Data.Common.DbDataAdapter.Fill(DataSet dataSet. I've completely erased all data and entered a new set of test data so I know there is no problem with relationships. Each table has primary key which is foreign key in other table. IS there something wrong with the Imports section: Imports System
[Code]...
i am trying to copy data from a standard Dataset to a Type Dataset (XSD) of same table structure. i want to use Automapper to do that one. So how can i do that using automapper?
View 1 RepliesI need to pick all data in my application from my database and use it in my form
my question : how to pick all data in my application then i use it
I have two Datagrids, One grid has all the customers garments on it with style number and contact length. The other grid has the users who have garment issued to them. the style number is in both grids. I need to loop through the users grid and say if the contract number is 1 from the first grid then the contract date on the second grid will be todays date + 365 days (year contract) I have looked at using a stored procedure and also a for each command but I am just getting stuck with it all. [Code]
View 1 RepliesI have a problem saving a dataset which contains rows that i have imported from another dataset. i can successfully view the imported rows in a gridview but i cannot commit the rows back to the database.
View 2 RepliesI have multiple datasets that I would like to combine into one. There is a common ID field that can be associated to each row. Calling Merge on the dataset will add additional rows to the dataset, but I would like to combine the additional columns. There are too many fields to do this in one query and therefore would make it unmanageable. Each individual query would be able to handle ordering to ensure the data is placed in the correct row.
For Example lets say I have two queries resulting in two datasets:
SELECT ID, colA, colB
SELECT colC, colD
The resulting dataset would look like
ID colA colB colC colD
1 a b c d
2 e f g h
ok, I've finally got my test database issues sorted out, however now I need to actually modify my existing report to add the two new fields from my test database. I have made a copy of the report so that I am not modifying the original. I have deleted the two old fields and now want to add my two new fields in there. In the Field explorer window, I see an object called "dataset1" and when I expand it, it is using a view that includes fields from the table that I added my two new fields to.
The problem I see here is that I have gone in and modified the view to include these two new fields in my test database - but again, they are not showing up as selectable fields here. I am just assuming that "dataset1" is somehow pointing to the live database again and that I need to change the datasource location.In my solution explorer, I see an object called "dataset1.xsd" but the properties of that do not tell me much about where it is actually pointing to...
[Code]...
I want to access data using both the datasets.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Try
[Code]....
In my code i have dataset name ds and table named Info1,when i write ds after that how tablename is coming,its not possible? How to do that ?
is it possible to use the same database for winform application (with vb.net) and web based with asp.net?
View 4 RepliesI have a winforms app with multiple GUI threads. I want them to be able to access each other's thread objects without having to keep track of that information separately.Is there a function in .NET that I can feed a winforms control or window object, and get back the thread? Or a function in the API I can pinvoke for the threadID?
Edit For those of you who for some reason believed my italicized text, congratualations, you're hired!! Here is the problem: "App is crashing in the wild by locking up totally, that is, it stop responding. Very intermittent, and trying to debug it, it seems to never happen."
So what do do? Install an option in the program that the user can activate under our direction, whereby from another GUI thread in the same app, do a thread.abort on the main GUI thread, then we can look at the call stack in the error log. Viola, found an impossible to debug error in less than a day. (Stop now, it had nothing to do with abusing multithreading:-)
I'll admit I almost didn't ask this, the reason I did was I could see an object reference to the main form, but there wasn't any for its thread. I'm giving Chris Shain the answer a/c it is a quick way, unfortunately when the thread is hanging, I wouldn't be able to do an invoke (it would hang too). A little more digging revealed the GetWindowThreadProcessId API call. But it's an unmanaged thread ID, apparently there are complications turning that into a managed thread ID.
So I bit the bullet and put in a global reference to the main UI thread. Would have posted it to begin with, but hadn't written it yet.In main public module/static class:
Public GUIThread As Threading.Thread
Sub Main()
[code]....
I am trying to put a pdf file on my form using microsoft report viewer, but i cannot find it. where is it?
View 2 Repliesok so i dynamically create a wsf for running an automated telnet session that works great!!(finally!!) but auto executing the script from my code is proving difficult for whatever reason.
I have tried:
Shell("C:shutoffscript.wsf") this produces this result.
also tried setting a bat file that launches the script and launching it as well using shell every time I launch it I get an error in the script that works just fine executed outside my code.
using outfile As New StreamWriter("c:" & "shutoffscript.wsf")
outfile.Write(sb.ToString())
End Using
MsgBox("Script built press ok to execute")
Shell("C:shutoffscript.wsf")
I think this has to be some sort of permissions error right? Since both errors tend to not be able to find the file. Just not sure how to fix it.