ramone

hello, what db engine (access, berkeley, etc) can i use for a single desktop app with VB.net 2003, the only requisites i need are the hability to store images, and to store the entire database in a single file so i can copy and transmit it over the internet in only one step, i don't want to install a service like mysql, and i don't want to use access because it doesn't support limits and ofsets in a select query thanks for your advise

i have a table with a lot of columns, is there a way to copy a row without selecting and reinserting it again? i'm using ms access thank you

thank you1

hello, i want to call the click event handler of a button when the user hits the enter key after typing some text in a textbox, but the keypress event of the text box only works with characters keys, what can i do? thank you

thank you that was very helpful!!! :D

hello i have a loop that creates controls with info from db, this controls are pictureboxes, after being created and configured they are added to a panel control, how can i set event handlers for click and double click events to this controls as they are created?? here is my code: Private Sub fotos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim dt As DataTable = selectDatos(Me.cnxStr, "select id_foto,ext from fotos where id_paciente=" + idpacientecur) Dim dr As DataRow Dim foto As PictureBox 'loop to create pictureboxes For Each dr In dt.Rows foto = New PictureBox foto.Size = New Size(90, 90) foto.SizeMode = PictureBoxSizeMode.StretchImage foto.Image = Image.FromFile(Me.path + "fotos\" + Me.idpacientecur + "\" + cString(dr.Item(0)) + "." + dr.Item(1)) 'add to panel control panelFotos.Controls.Add(foto) foto.Location = New Point(Me.refx, Me.refy) foto.Cursor = Cursors.Hand Me.refx = Me.refx + 100 'here i want to add the event handlers for click and double click events Next End Sub thanks for your help

hello i want to copy an ms access database file (.mdb) from a dir to another, simple, but my program throws an excpetion NotSupportedException saying "Given path's format is not supported", how can i copy my file??, here's my code: Dim path As String = "" 'target filename will contain today's date Dim hoy As String = Today.ToString hoy = hoy.Replace("\", "-") Dim path1 As String = selPath.SelectedPath + "\udm_" + hoy + "_" Dim ext As String = ".mdb" Dim num As Integer = 1 'generate target path path = path1 + num.ToString + ext 'check if not exists, else increment the number While File.Exists(path) num = num + 1 path = path1 + num.ToString + ext End While Dim source As String = Me.path + "db\db.mdb" 'exception thrown around the next lines Dim fs As FileStream = File.Create(path) fs.Close() File.Copy(source, path) thanks for your help

thank you!!!!!!!!1 :D :D :D :D :D

is there support in .net for creation and handling of zip compressed files? thank you

hello, how can i get the value of the autonumeric key field for the last inserted row in an ms access database using odbc (something like mysql's mysql_insert_id() function)?? thank you

thanks for this and for the past one :D ;)

how can i make a method to wait n seconds and then resume execution?? public sub blah() 'statements 'wait one second or two... 'resume execution end sub thank you =)

hello how can i block users from entering special sql characters in textboxes, like # ' \ " and -- ? i know it can be done with the keypress event of the textbox but i don't know how exactly thank you

hello i have a datagrid, the first time i bind it to a dataTable it shows the rows and cols correctly, but after updating that table in the db and binding again to a new datatable it still shows the old records, i have no building/runtime errors, i use odbc and an access 2000 db, what can i do to bind the datagrid to a new datatable and force it to show the new data ?? thanks for your help

i think the problem is the update of the datagrid, it has only one datatable and it doesn't update with the new datatable, how can i update it?? thank you

the dialogbox has a me.close, it closes and then it is supposed to resume the execution and update the datagrid

hello i have a button in my main form that shows a modal dialogbox, the user inputs data in the dialogbox and then click ok to save the data, but the execution doesn't resume after the form.showdialog() line, heres my code: Private Sub verBotonAgregarCita_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles verBotonAgregarCita.Click Dim acitas As New aCitas 'new dialogbox acitas.idpacientecur = idPacienteCur acitas.ShowDialog() 'nothing after this line will be executed 'code to update a datagrid Dim query As String Dim citas As New DataTable query = "select id_cita,tratamiento,anticipo,fecha from citas where id_paciente=" + idPacienteCur citas = selectDatos(Me.cnxStr, query) verTablaCitas.DataBindings.Clear() verTablaCitas.SetDataBinding(citas, "") estilo1.MappingName = citas.TableName colSaldo.MappingName = citas.Columns(2).ColumnName colTratamiento.MappingName = citas.Columns(1).ColumnName colFecha.MappingName = citas.Columns(3).ColumnName colId.MappingName = citas.Columns(0).ColumnName End Sub what can i do tho resume the execution after the showdialog call?? thank you

hello, how can i bind a group of textboxes to the fields of a datatable with only one record?? i whant they to fill automatically when the datatable is filled and to update the database when changed (vb.net 2003) thank you

thank you it works very well :D

how can i know the index number of the tabpage currently shown in a tabcontrol??? i have searched for a 'current' property, or something alike, in both TabControl and TabPage but i've failed to find a property or method get the current tab thanks :p

thank you i'm trying to get a workaround :D

i'm sorry bri189a but i don't know how to do that :confused: i have the name of a control in a string, i want to use that name to call a method of that control, i'm looking for an eval()-like function but anyways thanks for your advice :)

hello is it possible to execute code in a string in vb.net, for example dim codeStr as string codeStr="controlname.method" 'execute controlname.method here thank you

how can i change the image of a picturebox control at runtime when mouse hovers it?? heres my code Private Sub hoverDiente(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles d1.MouseHover, d2.MouseHover sender = CType(sender, PictureBox) Dim tempStr As String = sender.name tempStr.Replace("d", "") MsgBox(Me.path) sender.Image = New Bitmap(Me.path + "\\path\\" + tempStr + ".jpg") End Sub so far i have an 'invalid argument' error when calling sender.image=new bitmap() thanks for your help

first of all thanks for your help i have two questions for your solutions. first, where to save the manifest file or how to link it to my project?. second, i don't have a main sub for the techmanbd's solution sorry but i'm not experienced with vb.net thanks again =D