|
how to insert data in data grid in vb.net
|
|
|
|
|
Try this...
dim conn = new sqlconnection(connstring)
dim cmd = new sqlcommand
cmd.connection = conn
cmd.commandtype = command.text
cmd.commandtext = "SELECT ...."
dim da = new sqldataadapter
da.selectcommand = cmd
dim ds = new dataset
da.fill(ds, "tblname")
dg.datasource = ds.tables(0)
Feng Screwed, the art of moving to a new place because it would just be too much to clean the old place
|
|
|
|
|
I am making an FTP application that needs to have support for an UploadDir function. And I can't seem to make it work correctly. Does anyone know how to do this, or where I can get some open source FTP Class that supports uploads of Directories? I'm begging you, please help.
~Kc
|
|
|
|
|
It's no different than uploading files one at a time, because, that what you actually have to do. If your going to upload an entire directory, you have to keep track of the list of files you have to upload, the files that you've sent, and if you want, you have to track the directory tree you must create on the FTP server. If you use a simple, recursive, tree-walking algorithm on your source directory, this is easy to do.
Each iteration of the alorgithm will simply upload any files it in the current directory, then iterate through the directories in the source directory, create the folder on the FTP server, then calls itself with the new path to the new souce directory and the destination path on the FTP server.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank you very much Dave! I actually got this working today. The recursion was throwing me off, but I found the problem by stepping into the code slowly with the debugger. Thanks again, your answer is 100% correct.
~Kc
|
|
|
|
|
i currently has an backup of a database (called ybam) in a sql script (called c:\20053131028.sql)...
now i want to create a button where an user can restore the ybam database by click on restore button on the vb .net form....
what should i code in the button.... thank you very much....
|
|
|
|
|
heeheelim wrote:
what should i code in the button
I don't know MySql, but the process is the same for all databases so here are the steps you need to carry out.
* Load the file in to a string
* Create a Connection to the database with sufficient privileges to process your script
* Create a command object with the string of the script and the connection.
* Open() the Connection
* ExecuteNonQuery() on the command object
* Close() the connection
You may have to alter the CommandTimeout if the restore is likely to take more than 30 seconds.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Dear all,
Anyone can hide the tabpages in tabcotrol
Don't tell follows
Me.TabControl1.TabPages.Item(0).Visible = False
This is not working
And also can you draw line on tabpages
rugfy
|
|
|
|
|
On my main form is a series of text controls which are bound to a datasource (Ds1). Also on the form is a datagrid which is bound to a different datasource (Ds2). All works well.
Ds1 and Ds2 look to the same information Table (T1) and contain the exact same records. Ds2 differs, however, in that it Ds2 looks to a joined query of T1 and another Table (T2).
Question:
If I select a row from the datagrid, I want the appropriate record to appear on the main form. How can I do this?
If both the Text boxes and the Datagrid had the same underlying recordsource, the desired result would automatically occur. However, since I have two datasources, it does not happen automatically
In my code, I have successfully identified the unique counter field in T1. All I need to do is filter Ds1 or somehow move to the appropriate record on the main form.
Would I employ a data filter (e.g. Dataview)? There is NO need to clear and then re-fill Ds1 because the record is already part of the recordset. I just want to move to it on the main form.
You help and advice is greatly appreciated.
Pat
|
|
|
|
|
Hello
Have control over in the currencymanager object ,If you have give the both datasource as ds1 ,means you can work with two data source in that case u can give on click event of grid
CurrencyManager.Position = DataGrid.CureentRowIndex
Otherwise you have to explicitely assign get the Bindingcontext of Datagrid which is returned CurrencyManager/BindingManagerBase And you can control it by Move through records
Like
currencyManager.Position =0 //First
currencyManager.Position -=1 //Previous
currencyManager.Position +=1 // Next
currencyManager.Position = CurrencyManager.count - 1 //Last
Befor that You have to get the object of Bindingcontext from datagrid
Dim Cm as CurrencyManager
cm= BindingContext(Datagrid.Datasource,DataGrid.DataMember)
Now you can give that in the Mouseup by getting the hittestinfo Or Click events
private sub myDataGrid_MouseUp(byval sender as object, byval args AsMouseEventArgs )
dim hitTestInfo as DataGrid.HitTestInfo
hitTestInfo = me.myDataGrid.HitTest(args.X, args.Y)
if(hitTestInfo.Type=DataGrid.HitTestType.ColumnHeader)
// Get the CurrencyManager for the bound DataTable
CurrencyManager Cm = me.myDataGrid.BindingContext(Datagrid.DtaSource,Datagrid.Datamember)
// Get the current DataRowView
DataRowView currentRowView = (DataRowView)dataTableCurrencyManager.Current
I hope this helps you
|
|
|
|
|
hai...
everyone who know how to convert the File to String?
Actually, my idea is doing this to transfer the file to another computer. So, i convert the file (.text file or .exe file) to string and then send to another pc.
After this, the pc will received this string then convert the string to File...
So, i build up the protocol already but i dont know how to convert the file to string and the convert back from string to file.... anyone can help me.....
thanks....
|
|
|
|
|
This might be a better way. Ignore the bits about saving it to the database. It converts a file to a Byte Array. I am currently saving pictures to a database in this way. It works great.
http://support.microsoft.com/kb/316887[^]
Shawn
|
|
|
|
|
Thanks for ur reply....
Actually i just know the code from BitMapToString, but i dont know how to use this to convert it from FileToString...
So, any suggestion for this function....
Public Function BitmapToString(ByVal sImagePath As String) As String
Try
Dim data As String
Dim ms As MemoryStream = New MemoryStream
Dim bmp As Bitmap = New Bitmap(sImagePath)
' Save as PNG format (IMHO, much better!
// )
bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Png)
data = Convert.ToBase64String(ms.ToArray())
Return data
Catch ex As Exception
Return String.Empty
End Try
End Function
|
|
|
|
|
You might want to try some of the code I have in a project I posted on this board about 2 weeks ago. It is using a MySql file but I think the streamreader code might work.
http://www.codeproject.com/useritems/WavfilesInDatabases.asp
Dim b() As Byte
Try
b = DBSelectCmd.ExecuteScalar()
Dim K As Long
K = UBound(b)
Dim WriteFs As New FileStream(strOutFile, FileMode.Create, FileAccess.Write)
WriteFs.Write(b, 0, K)
WriteFs.Close()
MessageBox.Show("Wav file has been retrieved and written to application folder")
Catch oExcept As Exception
MessageBox.Show(oExcept.Message)
End Try
If this doesn't work, I found some other similar code in MSDN that I think might work but I don't have it on this computer and I will have to wait until Monday to get it from my work computer.
Let me know if this either does or doesn't work.
|
|
|
|
|
hai.. thanks for ur reply...
Actually, i do many testing in filestream, but the results are just can convert the file(.txt file) to string.
my friend told to me that this is can't to convert the (.exe file) to string.
Is true?
|
|
|
|
|
See if this code might work. I don't know if you can "rebuild" data from a table back into a .exe, but I don't know of any reason why you shouldn't. If you FTP a file it is basically being "read" in binary, sent as a binary stream of data and then basically rebuild on the receiving end.
Anyway check this out.
Do While fdRead.Read()
'strTmp = fdRead.GetString(0)
strProgramFile = fdRead.GetString(0)
strOtherData = fdRead.GetString(1)
strOtherData2 = fdRead.GetString(2)
' Create a file to hold the output.
strFileOut = "progrname.exe" 'Me.TextBox2.Text & ".wav"
fs = New FileStream(strFileOut, FileMode.OpenOrCreate, FileAccess.Write)
bw = New BinaryWriter(fs)
startIndex = 0
' Read bytes into outbyte() and retain the number of bytes returned.
retval = fdRead.GetBytes(1, startIndex, outbyte, 0, bufferSize)
' Continue reading and writing while there are bytes beyond the size of the buffer.
Do While retval = bufferSize
bw.Write(outbyte)
bw.Flush()
' Reposition the start index to the end of the last buffer and fill the buffer.
startIndex += bufferSize
retval = fdRead.GetBytes(1, startIndex, outbyte, 0, bufferSize)
Loop
' Write the remaining buffer.
Try
bw.Write(outbyte, 0, retval - 1)
Catch
End Try
bw.Flush()
' Close the output file.
bw.Close()
fs.Close()
Loop
fdRead.Close()
Let me know if this works or not.
|
|
|
|
|
hai,
i have set my program as a .msi window installed file, when i type
the following command in command prompt
msiexec /i xxxxxxx.msi /qn
the .msi file will ran in silent install mode.
So, the problem is i want to start the silent install mode without manually
key in the command like above one.
how to when we start install and then will auto run silent install command....
Thanks....;P
|
|
|
|
|
You must use the command line parameters to get the silent mode install. You can either do this from a .CMD batch file or shell launch the command from another program you create for the purpose, such as your own Setup.EXE.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hello ,
I am writing an application that gets a password and a user name from the user I need to send these information to a web site to check wheter these information is correct or not then the web site should respond to my application with the result.
How can I send these information to the web site and how can I get the result from it.
|
|
|
|
|
Hello Mohsen,
your question is way general. as we don't know are you using web services or simple aspx mechanism. or is your application a windows app that refrences a web service.
I suggest you try the TaskVision sample from the MSDN or download it from http://www.windowsforms.com/[^].
It should give you a great insight on how to use webservices to get what you want done.
Cheers
It is Illogical to define an inventor by his invention
|
|
|
|
|
Hi, got a problem that no search seems to help with. I have a PictureBox control (VB.NET) on a form (181*136 in size) in which I am loading selected pictures from an OpenFileDialog.
The majority of the pictures are going to be the average 3*4 aspect ratio but there are going to be some that are either longer or taller than this.
The Stretch Property is great in the fact that it sizes down the pictures to fit, but the ones that are not to the 3*4 aspect ratio are too stretched.
How can I keep the aspect ratio of a picture and at the same time get it to fit into the PictureBox control?
Many thanks for the help.
Shawn
|
|
|
|
|
Hi, I need to build an application in VB.Net which select the font from one folder in windows exploere and install it to the font directory. I have an idea but I don't know how to start from it. Can any one give me the clue on how to do that???
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
This is some code I found on the internet and it worked fine for me.
Module Main
#Region "InstallFont"
Declare Function WriteProfileString Lib "kernel32" Alias "WriteProfileStringA" _
(ByVal lpszSection As String, ByVal lpszKeyName As String, _
ByVal lpszString As String) As Integer
Declare Function SendMessage Lib "user32" Alias "SendMessageA" _
(ByVal hwnd As Integer, ByVal wMsg As Integer, ByVal wParam As Integer, _
ByVal lParam As Integer) As Integer
Declare Function AddFontResource Lib "gdi32" Alias "AddFontResourceA" _
(ByVal lpFileName As String) As Integer
Const WM_FONTCHANGE As Integer = &H1D
Const HWND_BROADCAST As Integer = &HFFFF
Private Function InstallFontIfNeeded() As Boolean
'
' Check for font
'
Dim bFound As Boolean
For Each ff As FontFamily In FontFamily.Families
If ff.Name = "barcoding" Then bFound = True
Next
If Not bFound Then
' If bFound Then
Dim intReturn As Integer
'
' Copy font to fonts folder
'
Dim fi As New System.IO.FileInfo(System.Reflection.Assembly.GetEntryAssembly().Location)
Dim strWindows As String = Environment.GetEnvironmentVariable("WINDIR")
Dim strPath As String = String.Format("{0}\barcoding.ttf", fi.DirectoryName)
Dim strFont As String = String.Format("{0}\Fonts\barcoding.ttf", strWindows)
System.IO.File.Copy(strPath, strFont, True)
'
'Add font
'
intReturn = AddFontResource(strFont)
Trace.WriteLine(String.Format("Add Font {0}", intReturn))
'
' Tell operating system font installed
'
SendMessage(HWND_BROADCAST, WM_FONTCHANGE, 0, 0)
'
' Store the new font settings
'
intReturn = WriteProfileString("fonts", "Barcoding (TrueType)", "barcoding.ttf")
Trace.WriteLine(String.Format("Write profile {0}", intReturn))
End If
Return bFound
End Function
#End Region
Public Sub main()
If InstallFontIfNeeded() Then
Application.Run(New Form1)
Else
Process.Start("barcode.exe")
End If
End Sub
End Module
Let me know if it works for you or not.
|
|
|
|
|
Thank you very much for your comment. I will try to do it and let you know if it is working or not.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
I am working on a project EL-SOL Solar Energy Project to control the application panel by Stepper Motor through Parallel Port on my PC using Visual Basic 6.0.
Please help me to move the motor forwared reverse and angular direction.
How it can be possible.
Shaikh Zia Ullah alias SHAIKHOO
|
|
|
|