|
that is for defining more information on the topic. to doing that, i have no problem with the coding its just im usually comfortable with database programming but not integrate it with some analysis modelling so this is first for me. i seek tips from you guys on how this process can be done if it is possible or you guys can share other related information it would be great.
|
|
|
|
|
Read Simons latest reply.
|
|
|
|
|
you started by defining the a brief overview of the system, now define what / how you want the application to behave.
expand on how the ball starts to move?
what information should it take to make the ball move?
how much space does the ball have to bounce in?
what happens if the ball hits the limits of this space?
etc.
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
Hai All,
Here I Used windows.Datagridview in VB.Net. I need third party tool of datagrid because specify cell focus,enter key to choose from list,Date time picker in Etc......so tell about me Name of cheep and best tool or Free datragrid
|
|
|
|
|
Microsoft's DataGridView is the best free one. Google will find you alternates.
|
|
|
|
|
|
Good day friends! I need your help. I and my group have the following task "design and implementation of wireless communication software using visual studio 6.0". The major goal of this app is to send files from one pc(server) to another(client). We created the software using winsock control and tested it in the system and it worked fine. Then we created a ad hoc wireless network then added another pc to this network. We installed the client.exe in the client pc and set the RemoteHost address to the server's IP address. We click on connect on the pc(client). But when we tried to send files from server pc to client pc error always appears saying Runtime Error: 40006. I edit this solution has not be found. Help please.
modified 5-Dec-15 2:51am.
|
|
|
|
|
are you sure its an 'FTP' issue - sure its File Transfer, but, is it using FTP protocol (a bit misleading)
Im assuming you've done the obvious checks in the ad-hoc wireless network
a) client and server are on same tcp/ip segment
b) client can ping server
c) server can ping client
if your ad hoc wireless network is on a different tcp/ip'segment' then you're going to have to use a 'switch' and configure it and/or your client to get to the different 'segment' / address
|
|
|
|
|
Hallo Guys,
I have an old Visual Basic Application that i m trying to incorporate Oracle Database Procedures to increase speed and efficiency. However i have a problem with passing parameters from VB to the Procedure "I keep on receiving an error message of Wrong number or types of arguments". Below is the VB Code calling and passing parameters to Oracle Stored Procedure and the Declaration part of the Stored Procedure. Kindly help where i am going wrong.
---VB Code Here
Quote: Dim Rs As New ADODB.Recordset
Dim cmd As New ADODB.Command
Dim param As New ADODB.Parameter
Dim Str As String
Dim Omwosi, Omwaka, Enyanga, Contp
Dim res As Integer
Enyanga = Day(Now)
Omwosi = Month(Now)
Omwaka = Year(Now)
If Len(Enyanga) = 1 Then
Enyanga = "0" & Enyanga
End If
If Len(Omwosi) = 1 Then
Omwosi = "0" & Omwosi
End If
If Rs.State = 1 Then
Rs.Close
End If
Contp = Omwosi & Omwaka
v_USR_NM = Username
V_ERRR_MSSG = ""
v_Chqno = TxtChqNo.Text
ChqAcNo = TxtAliase.Text
Locator = TxtAcNo.Text
Amount = TxtAmount.Text
V_imageF = TxtFimg.Text
v_imageB = TxtBimg.Text
v_Locator = Locator
v_Amnt_ip = Amount
V_CRRNT_DTNO = Omwaka & Omwosi & Enyanga
TranT = "CHEQCLR"
Call Create_TransactionID
With cmd
.ActiveConnection = ConACExp
.CommandText = "InHseClr_dp"
.CommandType = adCmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("result", adInteger, adParamOutput)
cmd.Parameters.Append cmd.CreateParameter("ChqAcNo", adVarChar, adParamInput, 30, ChqAcNo)
cmd.Parameters.Append cmd.CreateParameter("v_Locator", adVarChar, adParamInput, 30, v_Locator)
cmd.Parameters.Append cmd.CreateParameter("Chqno", adVarChar, adParamInput, 30, v_Chqno)
cmd.Parameters.Append cmd.CreateParameter("v_Amnt_ip", adVarChar, adParamInput, 30, v_Amnt_ip)
cmd.Parameters.Append cmd.CreateParameter("v_USR_NM", adVarChar, adParamInput, 60, v_USR_NM)
cmd.Parameters.Append cmd.CreateParameter("BcodeUser", adVarChar, adParamInput, 10, BcodeUser)
cmd.Parameters.Append cmd.CreateParameter("CompName", adVarChar, adParamInput, 60, CompName)
cmd.Parameters.Append cmd.CreateParameter("Absid", adVarChar, adParamInput, 60, Absid)
cmd.Parameters.Append cmd.CreateParameter("Contp", adVarChar, adParamInput, 20, Contp)
cmd.Parameters.Append cmd.CreateParameter("V_imageF", adVarChar, adParamInput, 200, V_imageF)
cmd.Parameters.Append cmd.CreateParameter("v_imageB", adVarChar, adParamInput, 200, v_imageB)
cmd.Parameters.Append cmd.CreateParameter("V_CRRNT_DTNO", adChar, adParamInput, 20, V_CRRNT_DTNO)
Set Rs = cmd.Execute
res = cmd("result")
If (res = 1) Then
MsgBox "Updated Successfully"
Else
MsgBox "Error Update unsuccessful.", vbInformation, "No update done"
End If
Set cmd.ActiveConnection = Nothing
End With
'
---Procedure Declaration Part
Quote: PROCEDURE InHseClr_dp
( result IN OUT NUMBER,
ChqAcNo IN VARCHAR2,
v_Locator IN VARCHAR2,
v_ChqNO IN VARCHAR2,
v_Amnt_ip IN out VARCHAR2,
v_USR_NM IN VARCHAR2,
BCODEUSER IN VARCHAR2,
CompName IN VARCHAR2,
Absid IN VARCHAR2,
ContP IN VARCHAR2,
V_imageF IN VARCHAR2,
v_imageB IN VARCHAR2,
V_CRRNT_DTNO IN VARCHAR2
) IS
-- variables
Bcode varchar2(5);
v_ACCNO varchar2(30);
v_BCODE varchar2(5);
|
|
|
|
|
Just a guess, but since the result parameter is declared as IN OUT , shouldn't the equivalent ADO parameter be created using adParamInputOutput ?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks. Changed as per your observation but getting same error message Sir.
|
|
|
|
|
Check the names of the parameters you are passing in - there are not all the same as the parameter in the stored procedure.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
Thanks man, it worked. There was one variable in VB that was not exactly as the one in the Stored Procedure.
|
|
|
|
|
Is the following code correct to load table field data to ComboBox? It is working fine but would like to know whether it is the perfect one.
Public Function cboLoadPlants()
Dim dt As DataTable = DAL.LoadData("SELECT DISTINCT Trim(Company) As [Company] FROM CompaniesTable").Tables(0)
cboCompany.ValueMember = "Company"
cboCompany.DataSource = dt
cboCompany.SelectedIndex = 0
Return True
txtSearch.Select()
End Function
|
|
|
|
|
First, there is no such thing as the "perfect code".
Second, you're code is throwing a warning at you that you're ignoring since the line txtSearch.Select() will never be executed.
You're returning a value of True but the function header never defines a return type.
Does the code get data from a database and bind the result to a Combobox? Sure.
Is it the perfect code to do so? There's no such thing. There is only fitness as a solution to a particular problem. Does it work the way to want and does it have the performance you expect? Those are the questions only YOU can answer.
|
|
|
|
|
hi,
can i create sql query in query builder by selecting sql views instead of selecting sql tables??
please someone help me...!
|
|
|
|
|
What does this have to do with writing code in Visual Basic.NET??
|
|
|
|
|
He wants to Visualize the answer in the most Basic way possible?
|
|
|
|
|
Member 12094561 wrote: can i create sql query in query builder by selecting sql views instead of selecting sql tables?? Yes it is possible, just reference the views as you would reference any table.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
In a vb.net 2010 desktop application, I want to use 2 values for rowfilter and sort in a dataset, but I do not know how to accomplish that goal. The 2 values that I want to use for rowfilter and sort are the following: Variables.g_strCatId & CType(sItemEntered, String)
Here is the code that I have so far:
Public Sub FilllstItem2(ByVal sItemEntered As Integer) Dim dtInv As DataTable = dsRpt.Tables("tblItemData") Dim dv As New DataView(dtInv) Dim i As Integer
With dv
.RowFilter = "RecordID = '" & Variables.g_strCatId & CType(sItemEntered, String) & "'"
.Sort = "RecordID"
End With
If dv.Count > 0 Then
For i = 0 To dv.Count - 1
lstboxItems.Items.Add(CType(dv.Item(i)("ItemNo"), String) & " - " & CType(dv.Item(i)("Description"), String))
Next i
Else
End If
dv.Dispose()
ReDim itemArray(lstboxItems.Items.Count)
End Sub
Thus would you show me how to modify the code that I just listed above so that I can pass the 2 values of Variables.g_strCatId & CType(sItemEntered, String) to the rowfilter and sort code that I listed below:
to With dv .RowFilter = "RecordID = '" & Variables.g_strCatId & CType(sItemEntered, String) & "'" .Sort = "RecordID" End With
Is there a way to use a linq statement instead? If so, can you show me the code to use the linq statement?
|
|
|
|
|
OK, so you're already passing two variables to the sort filter. You're combining some value of g_strCatId with whatever value is in sItemEntered into a single string and sending that to the RecordId, as a string.
Your resulting filter looks something like this:
RecordId = 'SomeCarId0000123'
Is that what you want?
Without a much better explanation of how this filter is supposed to work and how it should be using the values supplied, there's little anyone can do to help.
|
|
|
|
|
You are correct on the value passed to the recordid. I did end up using linq to solve my problem.
|
|
|
|
|
how can i code my software to auto start at windows startup?
|
|
|
|
|
|
That's called a "service application". Windows starts services before users get a chance to log in.
|
|
|
|
|