i am using MS ACCESS DATABASE for data processing in vb.net, so i need to change the "connection string" while re-compile in another machines ,so i want to make connection string as stable(unchanged for all environment)
View 3 RepliesI have this code:
[Code]...
am using vb 2005 with an access database 2003 vb.net website (aspx page) i am try to put contact details in to the database with six text boves and one button (Button1) to submit the informaton in run time (aspx page) when i run the page no problems then i click submit no error but it does not send the information to the dadtbase.i put the code when i double click on the button here is my code could you plz tell what i am doin.
HTML
Imports System.Data
Partial Class accessall_NewCustomer
[code]...
I am using the following connection string to connect to a sql server on my network but having all kind of problemhere is the connection stringosqlconn.connectionstring="server=xxx.xxx.xxx.xxx,1433;" &"Database=LOS;" & "Integrated security=SSPI"I dont know if the problem is that there is no ";" at the last parameter like the others but I get the following error that shows in the file
View 24 RepliesHow to make Dynamic Connection string for VB.Net 2008 & Sql Server 2005 database
View 1 RepliesHow do I assign a My.Settings.Item connection string to cmd.Connection connection string value?
Dim cmd As New SqlCommand()
cmd.Connection = My.Settings.Item("csStaffHoursWorked")
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "spSaveDeltekImport"
Ok I have a question about connection string in vb.net. Im using the string [Code] but here I am specifying the serverName by its name, now if I deploy my application and send it to another person to use it I see that server name is changing according to the name of the computer. Is there any way where by I can make my application to detect itself the Name of the server present in that computer and use it in connection string?
View 2 RepliesI got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
Here is my dataset.xsd code
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)"
[code]....
i could make a 3d environment in VB.net which i could in the future make into a game environment or could i only do this with a language such as C++?
View 2 RepliesI was wondering if anybody knew how to stable sort an array in VB.NET using a key.Basically, I am reading 2 CSV files and populating 2 arrays in parallel. The first array (asLines) holds the entire lines read from both files, and the second array (aiTrans) holds only the transaction #'s from those lines (the 2nd field of the line).What I want to then do, is stable sort asLines using aiTrans as the key.url...How can I sort asLines using aiTrans as the key and keep the order?
View 4 RepliesI am chasing a strange error at a customer site and was wondering if it is possible that Environment.MachineName could return a zero length string. The docs say this is read from the registry but doesn't specify where. I can't imagine that a machine cannot have a netbios name but just wanted to ask.
EDIT
After some investigation, it appears that this was not returning a zero length string, but I was just interested if it is feasible.
Environment.GetCommandLineArgs() splits string with spaces in it sometimes but not others, want to avoid this.
[Code]...
P.S. This was a VB6 command line app that I just converted to VB.net & the behaviour only occurs in the VB.net version. It's being called in many places at the moment, so don't really want to have to manually go through all calls & add double quotes around the whole argument.
I am currently reading Pro LINQ c# 2008, and in page 87 the guy says OrderBy and OrderByDescending are stable. But he says exactly the opposite in page 96. It looks to me as he is referring to exactly the same functions, so I don't get it. Are they stable or not?
View 2 RepliesDoes anyone have experience of rapidly translating an access application into a standalone windows application? My current thoughts are to create an SQL database and a gui in c# and vb, or adobe flex 3.As with acces, the GUI would mainly comprise of controls such as radio buttons, combo box (populated from a table), check boxes, text boxes, text areas and data grids. It will also need the ability to create reports as access does.
View 2 RepliesIs there a way to display the connection properties dialog for connection string browsing(for database) in run time?
As I want the user to be able to connect to various database using the GUI.
I understand the possibilities for encrypting a connection string in .net v4. I have a win forms application that will be used by multiple people on different machines. I understand that I need to protect the connection string at time of the app being first run on the target machine. However I am concerned that for a period of time my connection string will be unencrypted. I am looking for advice in how to deploy my app with the connection string already encrypted or encrypted during installation. encrypting the connection string in a secure way?
View 1 Replieshow to create a stable plugin architecture. Stable because I plan on opening up plugin creation to the public but I dont want a sloppy coded plugin to take down my whole application.
So I thought of using an AppDomain per plugin and I did a little seaching. But it seems that even using a temp AppDomain to load plugins and then unloading it once all assemblies have been inspected raises complexity allot and I was planing on using an AppDomain per plugin.
I feel the gained stability (if there is any at all) may be raising the complexity so much the app will never be done..
Is there another way to both create a stable application and at the same time making it extensible?
I cases where the host calls a defined function via say IPluginInterface I guess I can pack a whole lot of try catch blocks around that call but what if a plugin insisted of a timed routine that would run continously without being invoked from the host other that a starting call to StartPluginService or something like that?
If I include a plugin like that in the default AppDomain and it blows up I sure will blow my own foot off right?
I'm developing an app in vb.net (visual studio 2008). I have a Teradata back-end that will be supporting multiple users in a production environment. I need to use variables in the connection string as the user/pass will be changed every 3 months.
For the gist of the application:
In it's most basic form - I have a search form which works correctly - it pulls results into a listbox and the user then double clicks the list box which will then open a form that is bound via table adapter to the back-end table (Teradata). My connection string is fine everywhere in the application. My problem is using a modified connection string for the "fill" function of the table adapter once the form is opened.
I'm using the code below for the on-load event and keep getting an "invalid connection string" - again, the connection string works fine everywhere else in the app, and the variables etc... are working correctly.
Private Sub adaptertest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DBConnStr As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security
[Code].....
I'm facing a problem after installation any software setup that has a database in access(mdb file) How to I transfer file path in our connection string.
View 3 RepliesI have VB6 Dll which I am referencing in vb.net ,I am calling the following function in it. It working fine in developemnt environment but not in deployement environment.
Error Method not found: 'Boolean MyUtils._MyUtils.LoadMyObjectRecords(ADODB.Stream ByRef, System.Array ByRef)'.
I am trying to connect DSN from my VB 2008 project. When i try using myoledb.connectionstring="DSN=myDNSname" I get the following error message An OLEDB provider was not specified in the connectionstring.
View 1 RepliesI have the following datatable with the ordering of DataClassIndex column before editting:
DataclassIndex
0
1
[code].....
I have a datagridview bound to a datatable via a dataview. The user is allowed to edit cells in the datagridview, thereby editing cells in the datatable. I recently found that if the user editted a cell, then closed the form without ever clicking on a different cell (thereby causing the current cell to commit), the change was vanishing because the editted contents of the cell were not being saved back to the datatable.
This was only happening if the user closed the form. Clicking on any other control on the form also caused the cell changes to commit. After rooting abut in the DGV properties, it appeared that all I needed to do is add the following code to the Form Closing event handler:
If Me.dgvCurrentRedds.IsCurrentCellDirty Then
Me.dgvCurrentRedds.CommitEdit(DataGridViewDataErrorContexts.Commit)
End If
Sure enough, this caused the change to be registered in the underlying datatable. However, it was then getting obliterated by a different process, so I went looking for the source of that problem, and eventually tracked it down to this:
While the preceding code is causing the datatable to receive the new information, the datarow that has been changed still has the status Unchanged, even though it should have the status Modified since it actually has been modified. The fact that it appears unchanged causes some other code to obliterate the change, but that's irrelevant.
The question is, why is the row status UnChanged when it certainly has been Changed, and is there any sound way to force the row status to update?
I have a form with textboxes for input. I have coded the Exit button to display a message box that asks the user if they want to save any data in the textboxes before exiting the program:
Private
Sub btnExit_Click(ByVal
sender As System.Object,
ByVal e
[code]....
The question I have if the textboxes are blank (nothing has been entered), how do I code the Exit button to close the program without displaying the message box asking the user to save the data.' Save the numbers. Call the btnSave_Click procedure.
I've got my code to delete rows out of the database when the user clicks on the Delete button in my GridView, but the GridView isn't updating to reflect the new data changes.
Here's my code:
<asp:GridView runat="server" ID="grdQuestions" AutoGenerateColumns="false" Width="100%" CellSpacing="10"
PagerSettings-Visible="true">
<HeaderStyle CssClass="aspNetHeader" />
[code]....
EDIT 1:Did some stepping through the code and found that e.CommandArgument is not getting a value in grdQuestions_RowCommand
EDIT 1 (Revised):The fact that e.CommandArgument wasn't getting a value was my mistake. I'd changed the way it's value was being assigned without removing the previous method.The code runs through grdQuestions_RowCommand and then goes into grdQuestions_RowDeleting and then executes GetModuleData.I have a feeling that to view changes to the grid, a PostBack might be required, but I've removed all DataBinding to an If Not IsPostBack Then block because the alternative caused problems with the DropDownList whose selection is used as a reference to populate the grid (ddlModules selected the Module whose Questions will display in the grid).
I add a row to the DataSet using the following code:
Dim NewRow as DataRow
NewRow = gds.Tables("TitleDataSet").NewRow
NewRow("Title") = txtTitle.Text
NewRow("Local_number") = nubLocalnumber.Value
NewRow("Number_suffix") = txtNumberSuffix.Text
etc.
This code executes without errors but the bound DataGridView remains unchanged (without including the new row). Obviously I am doing something wrong or I am omitting a vital command. What do I need to do in order to make the new row appear in the DataGridView? I did not choose to bind the DataGridView directly to the database table because the database is selected by the user at execution time. Instead I bound the DataGridView to the DataSet. I included the command:L
dgvTitle.AllowUserToAddrows = True
but that did not have any effect.
Solved. Was missing the final command:L
gds.Tables("TitleDataSet").Rows.Add(NewRow)
Why doesn't an exception get thrown when this function is called when there is no ConnectionString set for the Connection? I just spent 15 minutes debugging and staring at it and finally figured out it needed the connection string. Shouldn't an exception get thrown?
Friend Function GetValues(ByVal TableName As String, ByVal FieldName As String) As DataTable
Dim cn As New SqlConnection
Dim cmd As New SqlCommand[code].....
How can I assign a value to a message box for when the default value displayed in the text box is unchanged. ie. If my default value is 17 and the user clicks ok without retyping a number, the Input value displayed in a textbox will be 0.
Currently I have:
Public Class Form1
Dim MyValue As Double
Private Sub But_EnterInput_Click(sender As System.Object, e As System.EventArgs) Handles But_EnterInput.Click
MyValue = CDbl(InputBox("Input a value", "Data Input", "17", 200, 400))
[code]....
This works however if the user types 17, the textbox will read 0. not what i want.
I've got lots of textboxes bound to a Dataset. When I make changes to a textbox with the mouse/keyboard the rowstate becomes changed - and when I do the .EndEdit and update the row it goes to the DB.
I've got some textboxes that get changed in code. When this happens the rowstate remains UNCHANGED. Updates to the DB never occur.If the textbox is changed in code and I also change another textbox in the UI then both changes make it to the DB.
I've verified that the "in-code" changed field in the dataset is actually changed - but the ROWSTATE is still printing as UNCHANGED.Here I'm showing that field 29 has changed to "blank" - but the RowState still is UNCHANGED. Why would changes to the .Text property of a bound control does programatically not change the row state?
Seems a google for this does uncover issues like this - but nothing that's helped me fix it so far - here's one link I can't make sense of[URL]..
I want to compare differences between two tables in my database with identical schemas.
vb.net
DataTable1.Merge(DataTable2)
Dim changedRows As DataTable = DataTable1.GetChanges
'changedRows is always Nothing. Why???
The DataTable1 is updated with rows from DataTable2 correctly. i.e. missing rows are added and datarows that don't match are updated. But the RowState of each row is still unchanged. I need to have the rowstate (added/modified/deleted) so that I can update the database table.