ninelg

I have a csv file that needs to be imported into sql server using vb.net. I got it working with the following code with one exception: [code] Private Function ImportLeadFile(ByVal projectfile As String, ByVal sLeadFile As String, ByVal DATABASE As String) As Boolean Dim objConn As nsSqlClient.SqlConnection Dim ds As …

I have an xml file that looks like this: <messageBody> <customerDetail> <accountId>123</accountId> <custId>ABC</custId> <customer> <custFirstName>Jane</custFirstName> <custLastName>Smith</custLastName> </customer> </customerDetail> <customerDetail> <accountId>246</accountId> <custId>DEF</custId> <customer> <custFirstName>John</custFirstName> <custLastName>Johnson</custLastName> </customer> </customerDetail> <customerDetail> <accountId>357</accountId> <custId>GHI</custId> <customer> <custFirstName>Amy</custFirstName> <custLastName>Gordon</custLastName> </customer> </customerDetail> </messageBody> I need to loop through each customerDetail to get the values of all of it's …

We have a 3rd party company that created 3 dlls for us that I need to use in my code. My app is written in vb.net, but it is a web page. I referenced all 3 dlls within my application (there were no exclamation points near the references in the …

I create a report by allowing users to select certain criteria from dropdownlistbox. Dropdowns: site, project, startDate, endDate, reporting level (summary or agent detail) I have the following datagrid with 7 columns: [Code] <asp:datagrid id="grdResults" runat="server" Height="50px" Font-Names="Tahoma" Width="900px" Font-Size="XX-Small" BorderColor="Silver" ForeColor="Black" PageSize="1" adding="1" AutoGenerateColumns="False" BorderStyle="Solid" CellSpacing="1" HorizontalAlign="Center"> <Columns> <asp:BoundColumn …

I got as far as being able to execute a dts package from vb.net. The dts package passes a global variable to a stored procedure. How can I capture the returnValue of the stored procedure in vb.net? I'm stuck and can't figure it out. Can anyone please help me? Thanks, …