- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
I was working on a project in my VB.NET Express and suddenly my code that was working fine and starting up as normal gave me this error: {"An error occurred creating the form. See Exception.InnerException for details. The error is: Format of the initialization string does not conform to specification … |
|
Re:
i want to connect the sql dabase to vb.net form. can anyone tel me how to do it. i tired google. but it only says about ms access database. please help me |
|
I've been scouring the Net trying to get my head around using VB.NET to save information entered through text boxes on my form into an Access database. Most of what I see so far shows me how to display records already entered into the database and update the table, but … |
|
I've created an SSIS package where I have an FTP Task inside a ForEach Loop container. I am trying to loop through each file in the particular folder and send it to the FTP site. I am sure that I got the For Each Loop working, as the error message … |
|
The code snippet below is the beginning of a script I've been working on. What I need to figure out is make sure that I can generate the corresponding day last year. The business logic is such that I am supposed to compare sales data from the last business day … |
|
What I need is the SQL code to display the last business day - usually will be one day prior, but I want that if I run this code on Monday that, instead of Sunday's date, I get Friday's date. This is what I started with [CODE] - Automatically generate … |
|
My manager has just asked me to research whether it would be possible to restore a previously fully backed up database into two or more filegroups, with each filegroup being on a separate drive using SQL Server 2008. I know that if I were backing up the database to begin … |
|
This set of code below shows all SQL Server Agent jobs that have failed for the date 200.03.29. The run_date column is an integer, but I want to run the code in such a way that the resultset is automatically generated for the day before the current date. The code … |
|
I'm trying to create a *.csv file using the records stored in a table. Searching the Net, I came across a code snippet that I modified for my use. The relevant code is [CODE] If dlg.ShowDialog = Windows.Forms.DialogResult.OK Then conn.Open() csv = dlg.FileName tw = New StreamWriter(csv) Dim sql = … |
|
I'm trying to use VB.NET to insert the data in the current row of my datagrid into a table. I wrote the following code: [CODE] Dim vCustomer, vBulkQty, vItem, vBaseUnit, vEachQty, vEachUnit As String vCustomer = dgCustomers.CurrentRow.Cells(0).Value vItem = dgItems.CurrentRow.Cells(0).Value vBulkQty = dgItems.CurrentRow.Cells(3).Value vBaseUnit = dgItems.CurrentRow.Cells(4).Value vEachQty = dgItems.CurrentRow.Cells(5).Value vEachUnit … |
|
Now that I can see the data in the datagrid, I realize that the size of the fields is too small - the customerid and customer name fields both could use expanding so that I can see all of the text. Is there a way to programmatically extend the length … |
|
I've read up on attaching a dataset to a datagrid and followed all the code snippets I can, but I am still having problems viewing data. Have a look at this code: [code="VB"] Private Sub ViewCustomers(ByVal vRegion As String) conn.Open() Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" & vRegion … |
|
Hi guys! I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to them. When I run the function in SQL Server Query Analyzer, it works, but when … |
|
I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to them. Below is a code fragment for one of the functions. [code="SQL"] CREATE FUNCTION ViewCustomers(@Region varchar(6)) returns … |
|
I realize that the response time of my GUI is extremely slow! I have three combo boxes - I want the user to select a template from one drop down list, which will populate the second drop down list with customers related to that template. When a customer is selected, … |
|
How do I get a textbox to automatically update with information when I select an item from a combobox? [icode] txtCustID.Text = Custds.Tables(0).Rows(cboCustomer.SelectedIndex).Item("custno")[/icode] is what I came up with, and it populates properly when the combobox is first loaded up, but if I select another item, the text boxes don't … |
|
How do I stop a combo box from firing the SelectedValueChanged event when the DataSource property is added? |
|
Hi guys! Long time no see! I'm trying to get a datagrid to work, but although when I run it there is no error, nothing appears on the datagrid. Yet, there seems nothing wrong with my code: [code=VB.NET] SQL = "select * from upload " & _ "where field003 like … |
|
I've been trying to run an SQL script using an Excel macro. There are hundreds of records (one coumn - Item numbers) returned, and I would love to have the results start at C3 in the Excel worksheet and propagate down until all of the records have been added to … |
|
Just a quick question... Where would I post a question on running an sql script from Excel and storing the results within an Excel worksheet? |
|
I had created an application that worked, was deployed and used for a while before someone asked for an addition. When I tried to run the completed executeable file, I got a System.InvalidOperationException error immediately. When I opened the source code and tried to run it before making any changes, … |
|
I need to pull the Customer numbers from this string, where IDCUST is the fieldname and the customer code is in the brackets. How would I be able to pull all the customer numbers from it and store them elsewhere? [code] (CODECURN = "BDS") AND (SWACTV=1) AND (( IDCUST = … |
|
I have a button that when pressed displays all the customers in the table. Other buttons are used to add or delete a customer record, or upload a batch of numbers. How can I fire the Click event of the View button after the Add or Delete buttons code has … |
|
I've found that my application does not find my mdb file anymore! I have used a open file dialog box to select the mdb file that I want my app to use and add it to my connectstring via a variable, but although the variable has the correct path to … |
|
How do you test a record to see if it is the last record? I want to append one string to the end of my script string if the record is the last one, and a continue string if it is not. I'm showing the entire procedure below so that … |
|
I want to stop users from being able to save a duplicate record in my Access database. I thought of using RecordsAffected, but I can't figure out how to get it to work. [code] SelectSearchString = "SELECT * FROM Breakdown WHERE BFrom = " & txtFrom.Text ' & " AND … |
|
Re:
I like the new format for each forum index. Compact is good! Thank you, Dani |