bajanpoet

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 …

[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 …