|
i want to synchronize two databases having the same schema at different locations. any body help me.
Aman
|
|
|
|
|
hi All
I want to send print to the printer port in vb.net character by character (one character at a time ), not the whole file.
the purpose is like :
for i = 1 to 15
next
value of i shloud be transferred to the printer port at each execution of the FOR LOOP:
the value of i of the for loop that is executed 15 times should be printed.
print should be in this format:
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15 (means value of i)
any body help me please. i need it urgently.
thanks in advance.
Bye
|
|
|
|
|
|
I have been killing myself with this and getting nowhere.
I have an Access DB with a table for clients, among others. I am trying to use a stored procedure (query) to insert a new client. Here is my code for this part:
Public Sub addCustomer()
'Grab the contents of each field
Dim CustNumVal As String = Me.tbxCustNum.Text
Dim CustNameVal As String = Me.cbxCustName.Text
Dim CustContactVal As String = Me.tbxCustContact.Text
Dim CustAdd1Val As String = Me.tbxCustAdd1.Text
Dim CustAdd2Val As String = Me.tbxCustAdd2.Text
Dim CustCityVal As String = Me.tbxCustCity.Text
Dim CustStateVal As String = Me.tbxCustState.Text
Dim CustZipVal As String = Me.tbxCustZip.Text
Dim CustPhoneVal As String = Me.tbxCustPhone.Text
Dim CustFaxVal As String = Me.tbxcustFax.Text
Dim CustEmailVal As String = Me.tbxCustEmail.Text
'Create Command Params
objCommand = New OleDb.OleDbCommand
objCommand.Connection = objConnection
objCommand.CommandType = CommandType.StoredProcedure
objCommand.Parameters.Add("@CustNum", OleDb.OleDbType.Integer, 50, CustNumVal)
objCommand.Parameters.Add("@CustName", OleDb.OleDbType.Char, 50, CustNameVal)
objCommand.Parameters.Add("@CustContact", OleDb.OleDbType.Char, 50, CustContactVal)
objCommand.Parameters.Add("@CustAdd1", OleDb.OleDbType.Char, 50, CustAdd1Val)
objCommand.Parameters.Add("@CustAdd2", OleDb.OleDbType.Char, 50, CustAdd2Val)
objCommand.Parameters.Add("@CustCity", OleDb.OleDbType.Char, 2, CustCityVal)
objCommand.Parameters.Add("@CustState", OleDb.OleDbType.Char, 60, CustStateVal)
objCommand.Parameters.Add("@CustZip", OleDb.OleDbType.Integer, 50, CustZipVal)
objCommand.Parameters.Add("@CustPhone", OleDb.OleDbType.Char, 50, CustPhoneVal)
objCommand.Parameters.Add("@CustFax", OleDb.OleDbType.Char, 50, CustFaxVal)
objCommand.Parameters.Add("@CustEmail", OleDb.OleDbType.VarChar, 50, CustEmailVal)
objCommand.CommandText = "EXECUTE usp_AddCustomer"
objConnection.Open()
objCommand.ExecuteNonQuery()
objConnection.Close()
'Change the style of the drop down list
Me.cbxCustName.DropDownStyle = ComboBoxStyle.DropDownList
'Revert the controls back to read only
Me.tbxCustAdd1.ReadOnly = True
Me.tbxCustAdd2.ReadOnly = True
Me.tbxCustCity.ReadOnly = True
Me.tbxCustContact.ReadOnly = True
Me.tbxCustEmail.ReadOnly = True
Me.tbxCustNum.ReadOnly = True
Me.tbxCustPhone.ReadOnly = True
Me.tbxcustFax.ReadOnly = True
Me.tbxCustState.ReadOnly = True
Me.tbxCustZip.ReadOnly = True
'Hide the buttons
Me.btnAction.Visible = False
Me.btnCancelNew.Visible = False
'Clear and fill the Data Set
DsCustInfo.Clear()
daCustInfo.Fill(DsCustInfo)
'Set the record number to the new record
Dim newRecID As Integer
newRecID = Me.BindingContext(DsCustInfo, "custinfo").Count
Me.BindingContext(DsCustInfo, "custinfo").Position = newRecID
'Cleanup
CustNumVal = Nothing
CustNameVal = Nothing
CustContactVal = Nothing
CustAdd1Val = Nothing
CustAdd2Val = Nothing
CustCityVal = Nothing
CustStateVal = Nothing
CustZipVal = Nothing
CustPhoneVal = Nothing
CustFaxVal = Nothing
CustEmailVal = Nothing
objConnection.Close()
End Sub
The variables, strConnectionString, objConnection and objCommand are delcared at the top of the form as global variables as such:
Inherits System.Windows.Forms.Form
Public strConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\user\My Documents\Visual Studio Projects\" & _
"OnBase Configurator\db1.mdb;"
Public objConnection As New OleDb.OleDbConnection(strConnectionString)
Public objCommand As New OleDb.OleDbCommand
No matter what I do, I keep getting the following error:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
Someone please help me or shoot me. Either one is fine right now.
Jay Davis
|
|
|
|
|
just use
objCommand.CommandText = "usp_AddCustomer"
|
|
|
|
|
I tried that to no avail.
I also put the execute in a try...catch block and got a more precise error.
An unhandled exception of type 'System.ArgumentException' occurred in microsoft.visualbasic.dll
Additional information: Argument 'Prompt' cannot be converted to type 'String'.
Is this a dbtype mismatch?
Jay Davis
|
|
|
|
|
More Info....
Here is the query in Access
It is named usp_AddCustomer
INSERT INTO CustInfo ( CustNum, CustName, CustContact, CustAdd1, CustAdd2, CustCity, CustState, CustZip, CustPhone, CustFax, CustEmail )
SELECT [@CustNum] AS Expr1, [@CustName] AS Expr2, [@CustContact] AS Expr3, [@CustAdd1] AS Expr4, [@CustAdd2] AS Expr5, [@CustCity] AS Expr6, [@CustState] AS Expr7, [@CustZip] AS Expr8, [@CustPhone] AS Expr9, [@CustFax] AS Expr10, [@CustEmail] AS Expr11;
Jay Davis
|
|
|
|
|
More Info....
I have modified the structure as follows
Try
objCommand = New OleDb.OleDbCommand
objCommand.Connection = objConnection
objCommand.CommandType = CommandType.StoredProcedure
objCommand.Parameters.Add("@CustNum", OleDb.OleDbType.Variant, 50, "99999")
objCommand.Parameters.Add("@CustName", OleDb.OleDbType.Char, 50, "Test1")
objCommand.Parameters.Add("@CustContact", OleDb.OleDbType.Char, 50, "Test User")
objCommand.Parameters.Add("@CustAdd1", OleDb.OleDbType.Char, 50, "123 Your Street")
objCommand.Parameters.Add("@CustAdd2", OleDb.OleDbType.Char, 50, "Apt C")
objCommand.Parameters.Add("@CustCity", OleDb.OleDbType.Char, 50, "Your City")
objCommand.Parameters.Add("@CustState", OleDb.OleDbType.Char, 2, "OH")
objCommand.Parameters.Add("@CustZip", OleDb.OleDbType.Char, 50, "99999")
objCommand.Parameters.Add("@CustPhone", OleDb.OleDbType.Char, 50, "1234567890")
objCommand.Parameters.Add("@CustFax", OleDb.OleDbType.Char, 50, "1234567891")
objCommand.Parameters.Add("@CustEmail", OleDb.OleDbType.VarChar, 50, "test@test.com")
objCommand.CommandText = "usp_AddCustomer"
objConnection.Open()
objCommand.ExecuteNonQuery()
Catch OleDbExceptionErr As OleDbException
MsgBox(OleDbExceptionErr.ToString)
End Try
I am now just trying to do hard coded strings, and when I run it with the try...catch block, I get teh following error:
System.Data.OleDb.OleDbException: Parameter [@CustNum] has no default value.
Jay Davis
|
|
|
|
|
Just to add my 2 cents...
First, forget everything you know about real SQL. Access/Jet doesn't support a lot of it.
Access/Jet doesn't support named parameters. You CAN name them for a bit of clarity when you read the SQL statement, but the names are not used. There parameters you add must be supplied in the same order that they appear in the SQL statement. This also means you can't skip parameters. If a parameter in your statement can be blank, you have to supply it as a blank, null, or 0 value.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Is there some sample code?
Thanks!
|
|
|
|
|
Just don't do it. Direct Show is incredibly buggy. USe the Windows Media Player control instead.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Hello,
Any ideas on how i could dynamically add a detail section to a crystal reports object at run-time, the new details section would also need to have a sub report in it, but that is another matter.
any help much appreciated.
Thanks,
Kristian
|
|
|
|
|
Down the line of code i get one error (EventArgs.pPacket.Data(I)) pPacket is not a member of system.eventArgs
thispacket = ""
For I = 0 To e.pPacket.DataSize - 1
thispacket = thispacket & Chr(EventArgs.pPacket.Data(I))
Next
-----------------------------------------------------------------------------
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
With lvpackets
.Columns.Add("Form", .Width / 3, HorizontalAlignment.Left)
.Columns.Add("To", .Width / 3, HorizontalAlignment.Left)
.Columns.Add("Size", .Width / 3, HorizontalAlignment.Left)
.View = View.Details
End With
End Sub
Private Sub btnStart_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnstart.Click
Me.AxPacketXCtrl1.Start()
End Sub
Private Sub axpacketxctrl1_OnPacket(ByVal eventsender _
As System.Object, ByVal e As _
AxPacketXLib._IPktXPacketXCtrlEvents_OnPacketEvent) _
Handles AxPacketXCtrl1.OnPacket
Dim I As Short
Dim thispacket As String
Dim sourceip As String
Dim destip As String
Dim item As New ListViewItem
thispacket = ""
For I = 0 To e.pPacket.DataSize - 1
thispacket = thispacket & Chr(EventArgs.pPacket.Data(I))
Next
If e.pPacket.Data(14) = 69 And e.pPacket.Data(23) = 6 Then
sourceip = e.pPacket.Data(26) & "." & _
e.pPacket.Data(27) & "." & + _
e.pPacket.Data(28) & "." & + _
e.pPacket.Data(29)
destip = e.pPacket.Data(30) & "." & _
e.pPacket.Data(31) & "." & + _
e.pPacket.Data(32) & "." & + _
e.pPacket.Data(33)
item.SubItems(0).Text = sourceip
item.SubItems.Add(destip)
item.SubItems.Add(e.pPacket.DataSize)
lvpackets.Items.Add(item)
End If
End Sub
End Class
|
|
|
|
|
Delo wrote:
i get one error (EventArgs.pPacket.Data(I)) pPacket is not a member of system.eventArgs
Should not the line be e.pPacket.Data(I)?
Charlie
if(!curlies){ return; }
|
|
|
|
|
|
I have to agree with Charlie that EventArgs.pPacket definitely cannot be right. That is a type, NOT an argument. I feel certain it should be e.pPacket, like Charlie said.
But this line also looks suspicious:
AxPacketXLib._IPktXPacketXCtrlEvents_OnPacketEvent
Should that period underscore (._) be there?
Changing the line to either:
AxPacketXLib_IPktXPacketXCtrlEvents_OnPacketEvent
or
AxPacketXLib.IPktXPacketXCtrlEvents_OnPacketEvent
both look more like legitimate event signatures to me.
Maybe that's why the changes Charlie suggested did not work.
Also, this is obviously either a custom control or a 3rd party control. There's not much way anyone can helkp you with a control they have no information on ...
Good Luck,
Robert
|
|
|
|
|
sorry charlie you were right and robert you put it in a way that made me see it more clearly
thank you both
|
|
|
|
|
Hi,
I have created a number of form for user input, as they are more or the same I created a routine that creates the form in runtime (adding all the controls at runtime). What I now want to do is to have the save button to get enabled as soon as one of the controls has been changed. As I don't have the controls on the form during design time I am having problems using a eventhandler, basically I don't know how. So what I am asking is how do I create an eventhandler, or something else, in the controls I am adding that trigger an event on the form so that I can enable the Save button. Any pointers would be much appreciated.
DJ
Think, try, think, think, try, think, think, think, try, ASK, think, try, advance on step and start over...
|
|
|
|
|
Well, you did not specify VB6 or VB.NET, so I will not give much detail.
Basically the approach is:
VB6 - you have to already have a placeholder control of every type you want add at runtime and add then as a control array. So you just write a single handler and enable the the save button when anyone changes. Or you could process each control in a different way if you know in advance what their array indexes will be.
VB.NET
Create event handlers and add them to the dynamic controls using the syntax:
AddHandler <control name and event> AddressOf <event handler method>
Robert
|
|
|
|
|
Hello,
I want to know that how can i move the Recordset to end of file in VB.NET. In vb6, i use that code.
Do While Not Category.EOF
Combo2.AddItem Category(0) & " " & Category(1)
Category.MoveNext
Loop
but in Vb.net there is no function of 'EOF'
Kindly tell me that how can i reuse this code in VB.net. What changes i can make in this code.
Regards,
Eshban
EsHbAn BaHaDuR
|
|
|
|
|
Recordset? That's an ADO object, not a VB.NET or .NET Framework object. EOF doesn't move the cursor to the end of the set, it just checks to see if the cursor is AT the end of the set.
What is "Category" defined as? Could you show us the code that defines "Category"? Is it an ADO Recordset or a .NET Framework DataSet, or what?
If it's an ADO Recordset object, then call its MoveLast() method to move the cursor to the last record in the set.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Category is an ADO Recordset.
EsHbAn BaHaDuR
|
|
|
|
|
Category? Whatever....
Then just call .MoveLast() on your RecordSet object and the cursor will be on the last record in your set... Simple.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Can someone help, I'm having a brain fart (new to vb.net)?
Have a form with multiple radio buttons. When a user selects a radio button, then clicks submit, a form based on the selection will open.
What is the simplest 'select case' code to do this?
Thanks 
|
|
|
|
|
i think in that situtaion u cannot use SElect Case, ElseIf more efficent
if RadioButton1.Checked then
'Open Form1
dim _frm as new Form1
Form1.ShowDialog
ElseIf RadioButton2.Checked then
'Open Form2
ElseIf RadioButton3.Checked then
'Open Form3
Else RadioButton4.Checked then
'Open Form4
End If
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
