|
no i am working on windows form
|
|
|
|
|
You can use the DataAdapter to execute a particular query then fill the dataset and use that dataset as a source to fill the DataGridView.
Hope it helps !
AliAmjad(MCP)
|
|
|
|
|
I need to write an application that reads a text file from the mainframe and store the information in a sql table. There's no space, comma or anything that separate the field and content of the field in the text file. I don't even have any idea where to begin. Pls help
|
|
|
|
|
start with being able to get the file off the mainframe. if you can't do that then parsing out the file doesn't come in to play
|
|
|
|
|
So far I have managed to take out the file from the mainframe and stored it as a textfile.
|
|
|
|
|
1) get file off of mainframe - done
2) can you read the file into the program?
|
|
|
|
|
Yes I have written a code to read the file into a program and creates another folder and write the contents of the file
|
|
|
|
|
1) get file off of mainframe - done
2) read the file into the program? - done
3) you say there are no delimiters that you can key off off. that implies these fields are fixed in length. so create your parsing routine for each line read in that breaks it out based on the length of the field.
|
|
|
|
|
Hi all,
I have a C# class with .Cs Extension. Now I want to use these class method in my VB.Net application. How can I do this without creating DLL
Thanks in Advance
Dana
|
|
|
|
|
Translate the code into VB.NET???
|
|
|
|
|
You have two options.
1) Add the C# project to your solution and compile it into a .DLL that your VB.NET project references.
2) Translate the C# code to VB.NET and integrate that code into your VB.NET application.
|
|
|
|
|
You can not mix .NET languages in a single executable (EXE/DLL) file.
Hence, two source languages will result in at least two executable files.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
I think there is an obfuscator that also combines assemblies. I'm not sure if it works directly in VS (meaning it produces output from the other projects in the solution).
ROFLOLMFAO
|
|
|
|
|
hi,
my project was developed in vb 6.0 with sql2000 as backend.now i am working in SQL2005 upgration.
when i try to exucte a crystal report(7.0) from a vb component,i get the following error.
Cannot connect SQL server .20599
I doubt that the problem exists with CRPEAUTO.
Or do i need to add any dlls as references..
Plz give ur suggestions to reslove the problem
Thanks in advance
cheers
sangeet
|
|
|
|
|
|
Dear all,
I need to write a sub procedure to show a specified window form, based on the criteria and options choose by user. But it seems the code is so long and also maybe expand later.
Private Sub CallSubForm(ByVal Criteria As String, ByVal UserOption As Integer)
IF Criteria = "A" Then
IF UserOption = 1 Then
FormMainA1.Show()
Elseif UserOption = 2 Then
FormMainA2.Show()
Else
FormMainA3.Show()
End if
Elseif Criteria = "B" Then
IF UserOption = 1 Then
FormMainB1.Show()
Elseif UserOption = 2 Then
FormMainB2.Show()
Else
FormMainB3.Show()
End if
Elseif Criteria = "C" Then
Elseif Criteria = "D" Then
:
:
:
End if
End Sub
Can I pass the name of specified form to a procedure and show it out ?
Like this:
Private Sub CallSubForm(ByVal FormName As String)
:
:
End Sub
Many Thanks !!!
Leo
|
|
|
|
|
Sure you can
Sub SetForSelect()<br />
Dim oFrm As New Form 'declare an empty object<br />
Select Case CriteraOption 'fill the object according to your rules<br />
Case 1<br />
If OtherChoice - 1 Then<br />
oFrm = New frmBaseDlg<br />
Else<br />
oFrm = New frmBaseDlg<br />
End If<br />
Case 2<br />
oFrm = New frmCheckStatus<br />
End Select<br />
<br />
If Not oFrm Is Nothing Then 'Test the object to see if it was filled<br />
oFrm.ShowDialog(Me)<br />
Else<br />
MessageBox.Show("Unsupported criteria")<br />
End If<br />
End Sub
|
|
|
|
|
I have the following code. I am returning a string. If I use return where I have in this way is there a chance I could have left some database connections open still?
Does it skip the connection "Finish with resources" section?
I believe this is the cause to alot of timeout exceptions. Any help much appreciated.
<br />
'Gets any previosuly create about us text <br />
Public Function GetAboutUs(ByVal ProductID As Int32) As String<br />
' Create Connection<br />
Dim HSConn As New SqlConnection(ConfigurationManager.ConnectionStrings("RemoteSqlServer").ConnectionString)<br />
' Create data reader<br />
Dim dr As SqlDataReader<br />
'Declare Command<br />
Dim HSComm As New SqlCommand()<br />
<br />
Try<br />
HSConn.Open()<br />
' Provide connection<br />
HSComm.Connection = HSConn<br />
' Provide command type and command<br />
HSComm.CommandType = CommandType.StoredProcedure<br />
HSComm.Parameters.AddWithValue("ProductID", ProductID)<br />
HSComm.CommandText = "SP_ProductAboutUsSelect"<br />
<br />
'Execute the command<br />
dr = HSComm.ExecuteReader<br />
<br />
While dr.Read()<br />
'If there is a Tagline return it. Otherwise return nothing<br />
If dr.IsDBNull(0) Then<br />
Return Nothing<br />
Else<br />
Return dr.GetString(0)<br />
End If<br />
End While<br />
<br />
'Return in case value is not found<br />
Return Nothing<br />
<br />
Catch ex As Exception<br />
' Failed to retrieve tagline so return false<br />
Emailer.ErrorEmail(ex, Page)<br />
Return Nothing<br />
End Try<br />
<br />
' Finish up with resources<br />
dr.Close()<br />
HSConn.Close()<br />
<br />
End Function
|
|
|
|
|
Hi,
this does not look OK; everytime you return, the remainder of the function is not executed,
in particular the Close statements at the end.
There are two solutions to this:
1. don't use return except as the last statement; instead store the result value in some
variable (say result), and proceed throughout the function, that ends on return result
2. use a try/catch/finally construct with the Close lines in the finally block; they will
get executed even when you exit the try or catch parts in whatever way (even with return).
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
No. It gave me a headache just looking at it
You should rewrite it a bit.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I am stuck on this handler. I have 16 buttons to increment. Button1.text is the btn_click. How do I make this handle all 16 buttons when they are clicked???
[code] Private Sub Btn_click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If sender.text = "" Then
sender.text = "1"
ElseIf sender.text = "1" Then
sender.text = "2"
ElseIf sender.text = "2" Then
sender.text = "3"
ElseIf sender.text = "3" Then
sender.text = "4"
ElseIf sender.text = "4" Then
sender.text = ""
End If
End Sub[/code] Thank You Very Much!
|
|
|
|
|
Hi,
two remarks:
1.
you can specify an event list, i.e. multiple events, following the handles keyword;
doing so the same sub can serve many buttons.
2.
sender.txt will not compile as long as sender is of type object.
You need to cast sender to a Button, and then its Text property will be available.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Is there a pre defined snippet to attach for an event list in VB 2005? I don't know how to code a list.
Thanks
|
|
|
|
|
I have no details on eventlists; there is an alternative that may suit your needs better,
that's AddHandler, which attaches the handler at run-time rather than compile-time.
I hope MSDN is sufficiently clear on that (I'm not that familiar with VB).
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Thank you for your answers, I'll look at the MSDN site
Much appreciated
|
|
|
|