|
thank u
very much..
|
|
|
|
|
Haii..
Camne erk sy nk cetak maklumat dlm database melalui vb??
|
|
|
|
|
Please use English language. Not all can get what you have posted.
|
|
|
|
|
Credo che sia possibile, devi consultare la documentazione...
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
i need code for printing the contents of labels and text box in printer by manually setting the page oriantation as landscape or potrait in vb .net
|
|
|
|
|
First you need to understand this[^].
|
|
|
|
|
I'd recommend buying a book, learning at your own pace, and not accepting paid work until you have some sort of skill set.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
hi there, im creating a windows form where it will read data in a file n extract the data into the database.. the data in the files are in this format :
<date> <runno><coop>
20090301,C4933,ASB02
20090301,C4933,BL689
20090301,C4933,BL707
20090301,C4933,BL714
my app will read the data and will put into the table "portal" - date, runNo, coop.. but when i try, theres no data inside the database. But if i try to display all the data from that file, it can be display. so the problem must be insert the data to the database.. pls check my coding if there's a mistake.. TQ..
Private Sub SEMAK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SEMAK.Click
Dim fileName As String = "X:\COOPAYPC1\01032009\C4933"
Dim lineNumber As Integer = 0
Dim sr As StreamReader = New StreamReader(fileName)
Dim conn As New SqlClient.SqlConnection("Data Source=MISKPI;User ID= sysadm;Password=sysadm;Initial Catalog=SPGA_Latihan;Persist Security Info=True")
Dim date As String = ""
Dim runNo As String = ""
Dim coop As String = ""
Dim line As String = ""
Do
line = sr.ReadLine()
If line <> Nothing Then
Try
date= line.Substring(0, 8).Trim()
runNo = line.Substring(9, 14).Trim()
coop = line.Substring(15).Trim()
Catch ex As Exception
Console.Write(ex.ToString())
End Try
Dim strSQL As String = "INSERT INTO portal (date,runNo, coop) VALUES (@date, @runNo, @coop)"
Dim cmd As New System.Data.SqlClient.SqlCommand(strSQL, conn)
conn.Open()
cmd.Parameters.Add(New SqlClient.SqlParameter("@tarikh", SqlDbType.Char, 8))
cmd.Parameters("@date").Value = date
cmd.Parameters.Add(New SqlClient.SqlParameter("@runNo", SqlDbType.Char, 20))
cmd.Parameters("@runNo").Value = runNo
cmd.Parameters.Add(New SqlClient.SqlParameter("@coop", SqlDbType.VarChar, 100))
cmd.Parameters("@coop").Value = coop
conn.Close()
End If
Loop Until line Is Nothing
sr.Close()
End Sub
|
|
|
|
|
well you need to execute your command, don't you?
cmd.Parameters("@coop").Value = coop
cmd.ExecuteNonQuery()
conn.Close()
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
yup, tq for the info.. but still after i did the correction there's an error msg come out..
connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
what does this mean?
|
|
|
|
|
It means you can't connect to your DB, probably because the connection string is wrong, or because your SQL Server does not allow remote connections.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
i dont think its bcoz of sql server does not allow remote connection.. iv been copied this coding from my previous web app.. but the one that im doing currently is windows form.. will it cause a problem? bcoz in web app i will put the connection inside the web.config but in this windows form i put in the coding area as i posted b4. if there's no problem using the coding from my web app, that's why im confused.. my web app can connect to the database, can add, update..
|
|
|
|
|
This is for Visual Basic 6 prof.ed. not .net
What code can be used to format numbers in a listbox so that zeros show after the decimal point e.g.
show 5.000 not 5.
Thanks for your help.
nmib
|
|
|
|
|
Use the Format() function.
Example:
Format(5, "#0.000")
will produce 5.000 in a ListBox
|
|
|
|
|
You could convert each number to a string using either String.Format or its ToString property, specifying a format that you like. If you do that, you'll have to convert the string back to a number when somebody selects an item; the conversion back to a number may not be exact.
Alternatively may could define a class which holds a number but defines a 'toString' function that formats numbers the way you want (indeed, the numeric format may be defined as a property of the class). Doing this would allow you to easily determine the exact (rather than represented) value of whatever the user clicked on. You could also store any other desired information in your class. If you define iComparable within your class, you could also take advantage of the ListBox's ability to sort its items (which you could not do very well if the ListBox just held strings.
Public Class numThing
Implements IComparable(Of numThing)
Public myVal As Double
Public Overloads Function toString() As String
Return myVal.ToString("0.0000")
End Function
Public Function CompareTo(ByVal other As numThing) As Integer Implements System.IComparable(Of numThing).CompareTo
Return myVal.CompareTo(other.myVal)
End Function
End Class
|
|
|
|
|
That will only work in VB.NET. Besides, there's a better format string which adds commas (or substitutes) - "N5"
|
|
|
|
|
hi,
I have 2 web pages(text.aspx and pic.aspx) that can navigate to one web page(all.aspx). In all.aspx, there is a "Back" button, i need to get the URL from previous webpage in order to know which page i should back to.
anyone has any ideas?
|
|
|
|
|
Take a look here[^]
I are troll
|
|
|
|
|
I think i found the solution....
Request.ServerVariables("HTTP_REFERER")
|
|
|
|
|
quelle est les etapes pour installer un programe capture picture from webcam sur visual studio 2008 /win vista .
please send me message on orsal_2008@hotmail.com
|
|
|
|
|
Use English language and do not repost.
|
|
|
|
|
Parlez Anglais, svp. It's considered rude to post in French, and it will limit the amount of answers you'll get - since not everybody is able to read French.
Bye
I are troll
|
|
|
|
|
And your thread title is dumb which matches the message content well.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
My French is really bad, but to save some time for those who feel like ending the day with a little gentle mockery with Google Translate, the question is along the lines of "What is the process for installing a program to capture a picture from the webcam using Visual Studio 2008 and Windows Vista?" The answer of course, is to download the program from the Internet, then double-click on the installation program
|
|
|
|
|
quelle est les etapes pour installer un programe capture picture from webcam sur visual studio 2008 /win vista .
please send me message on orsal_2008@hotmail.com
|
|
|
|