|
Which grid is faster than for loading 7000 records in vb.net?
1.Jgrid
2.DataTable
3.Flexigrid
|
|
|
|
|
|
A datatable isn't a grid; fastest load/display is with a virtualized datagridview. Examples can be found on MSDN.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
I would like to read the properties of a file on the desktop. However, I do not have the filename but only the location points. Properties of the file with the points X = 500 Y = 320. Can anyone help me how I could do that.
Tooli
|
|
|
|
|
Had a problem hoping you can help
An external program sends via OutputDebugString messages that I can read correctly with the program Dbgview.exe.
But would like to further process these messages, if possible read the same in VB.net. eg to display these messages in a text or label field.
Could someone give me food for thought as I do that.
|
|
|
|
|
|
Write a debugger.
There's some tutorials on starting an application and catching those messages. Google knows where 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
have you a example for me (Vb.net)
|
|
|
|
|
|
1) Create Sql Dtabase in single Table exp. Table name Abc and column(Srno, Name1, Name2,
Class1,Class2)
2) Vb.net in Create a windows Form
i) Create a TextBox
ii) Create a 2 GridView exp. (GridView1,Gridview2)
iii) Fill TextBox in "Srno" On form load
iv) Data Fetch in GridView1 ( Name1,Name2) And GridView2 (Class1, Class2)
|
|
|
|
|
And your question would be .....?
A proper description of the problem would help.
|
|
|
|
|
Ah homework I presume!
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Public Sub llenaCombo()
Me.cmbCodigoInternoEDC.Items.Clear()
sql = "Select CodigoInterno from [Equipos de Computacion]"
cmd.CommandType = CommandType.Text
cmd.Connection = conn
cmd.CommandText = sql
dr = cmd.ExecuteReader
If dr.HasRows = True Then
While dr.Read()
Me.cmbCodigoInternoEDC.Items.Add(dr.GetValue(0))
End While
End If
dr.Close()
End Sub
Public Sub llenaCombo1()
Me.cmbCodigoInternoVH.Items.Clear()
sql = "Select CodigoInterno from Vehiculos"
cmd.CommandType = CommandType.Text
cmd.Connection = conn
cmd.CommandText = sql
dr = cmd.ExecuteReader
If dr.HasRows = True Then
While dr.Read()
Me.cmbCodigoInternoVH.Items.Add(dr.GetValue(0))
End While
End If
dr.Close()
End Sub
Private Sub BtnBorrar_Click(sender As Object, e As EventArgs) Handles btnBorrar.Click
Dim CodigoInterno As Integer
Dim CodigoInterno1 As Integer
CodigoInterno = Me.cmbCodigoInternoEDC.Text
CodigoInterno1 = Me.cmbCodigoInternoVH.Text
cmd.CommandType = CommandType.Text
cmd.Connection = conn
If sql = "Select * from [Equipos de Computacion]" Then
sql = "delete [Equipos de Computacion] where CodigoInterno= " & CodigoInterno & ""
cmd.CommandText = sql
ElseIf sql = "Select * from Vehiculos" Then
sql = "delete Vehiculos where CodigoInterno= " & CodigoInterno1 & ""
cmd.CommandText = sql
End If
Try
cmd.ExecuteNonQuery()
Me.cmbCodigoInternoEDC.Text = ""
Me.cmbCodigoInternoVH.Text = ""
llenaCombo()
llenaCombo1()
MsgBox("Registro eliminado correctamente")
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub>
|
|
|
|
|
The SQL statement is simple:
DELETE FROM tableName
You're already executing SQL statements against the database. This is no different.
|
|
|
|
|
Is not working please help.
|
|
|
|
|
HOW?! Look at what you gave me to work with: "It doesn't work".
What am I supposed to do with that information? I have no idea what code you wrote for this, what you expect the code to do, what the code is actually doing, any error messages, ..., nothing.
Stop typing as little as possible and start explaining EXACTLY what the questions and problems are. Without that, everyone is just guessing at what you want.
|
|
|
|
|
System.InvalidCastException
HResult=0x80004002
Message=La conversión de la cadena "" en el tipo 'Integer' no es válida.
Source=Microsoft.VisualBasic
StackTrace:
at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)
at Activs_Fijos.Reporte.BtnBorrar_Click(Object sender, EventArgs e) in C:\Users\Augusto\source\repos\Activos Fijos\Activos Fijos\Reporte.vb:line 41
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
at Activs_Fijos.My.MyApplication.Main(String[] Args) in :line 81
Inner Exception 1:
FormatException: La cadena de entrada no tiene el formato correcto.
|
|
|
|
|
at Activs_Fijos.My.MyApplication.Main(String[] Args) in :line 81
Inner Exception 1:
FormatException: La cadena de entrada no tiene el formato correcto.
The message is telling you what is wrong, and what line number the problem occurs on.
|
|
|
|
|
You haven't told us which line of your original post is line 41, but I'm guessing it's one of these:
CodigoInterno = Me.cmbCodigoInternoEDC.Text
CodigoInterno1 = Me.cmbCodigoInternoVH.Text
The error is telling you that the value in one of those textboxes cannot be converted to an Integer.
Specifically, the textbox is empty. An empty string cannot be converted to an Integer.
Use Integer.TryParse[^] to attempt to convert the user input to an integer. If it fails, report an error to the user.
If Not Integer.TryParse(Me.cmbCodigoInternoEDC.Text, CodigoInterno) Then
Me.cmbCodigoInternoEDC.Focus()
MessageBox.Show("Please enter a valid number")
Return
End If
If Not Integer.TryParse(Me.cmbCodigoInternoVH.Text, CodigoInterno1) Then
Me.cmbCodigoInternoVH.Focus()
MessageBox.Show("Please enter a valid number")
Return
End If
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Im trying to erase Vehiculos and Equipos de computacion with a single button, please help.
|
|
|
|
|
There is no point in repeatedly telling us what you want. Show the code that is failing and explain what happens when you run it. I have already given you a suggestion for your System.InvalidCastException so that is something you can investigate for yourself.
|
|
|
|
|
I changed the sql code for this:
sql = "delete v from Vehiculos v LEft join [Equipos de Computacion] e on v.CodigoInterno = e.CodigoInterno where v.CodigoInterno = " & CodigoInterno & ""<br />
sql += "delete e from [Equipos de Computacion] e Left join Vehiculos e on e.CodigoInterno = v.CodigoInterno where e.CodigoInterno = " & CodigoInterno1 & ""<br />
cmd.CommandText = sql
I want the two tables erased. The queries work for separated i only can erase one table, Im using two comboboxes for each table.
|
|
|
|
|
cmd.CommandText = "DELETE FROM Vehiculos WHERE CodigoInterno = @CodigoInterno; DELETE FROM [Equipos de Computacion] WHERE CodigoInterno = @CodigoInterno1"
cmd.Parameters.AddWithValue("@CodigoInterno", CodigoInterno)
cmd.Parameters.AddWithValue("@CodigoInterno1", CodigoInterno1)
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
Hello,
I have added a DataGridViewComboBoxColumn to a DataGridView and i'm having a little problem.
For testing I am loading one item in the combobox. The item value source is an xml filename without
path or extension; ie. "Foodlion". The xml file has an entry that defines this filename but has a
different case like "FoodLion". After loading the xml file and passing its' value "FoodLion" to the
combobox, I get this context error in DataGridView1.DataError:
Formatting, Display
I'm not performing any formatting on this field since I expect just text.
I get it that the combobox must be performing a FindExact() type search and does not match.
Before I go through the pain staking effort to try an make sure the names match, is there
something I can do change the combobox processing?
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
