- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
27 Posted Topics
 | 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 …  |
| | In code you can do it this way [code] Imports System.Data Imports System.Data.SqlClient Public conn As SqlConnection conn = New SqlConnection("server = SRVERNAME ;database = DATABASENAME;Trusted_Connection = yes") [/code] Then you can use [icode] conn.Open[/icode] to open the connection and [icode]conn.close [/icode] to close it. |
| | 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: Forum Indicies [quote=cscgal;310668]Regarding color changes, threads used to look like this: [URL="http://www.daniweb.com/techtalkforums/getdaily.html"]www.daniweb.com/techtalkforums/getdaily.html[/URL] And now threads look like this: [URL="http://www.daniweb.com/techtalkforums/forum8.html"]www.daniweb.com/techtalkforums/forum8.html[/URL] Which do yo like better? I think the grey makes the bright yellow less overwhelming so you're more apt to spend more time studying the page. But I do like the yellow too …  |
The End.