|
Member 13305368 wrote: how can i view the fullname on toolstripstatuslabel You look at it.
Member 13305368 wrote: from the information i use to log on from login form after logging successfully. "insert magic here", eh?
Start with something simpeler.
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.
|
|
|
|
|
OK, so what's stopping you from just getting the username on the login form from the database when you authenticate the user and then passing that data to the main form of your application? This is basic stuff, passing data between classes, and Forms are just classes.
modified 10-Apr-19 16:30pm.
|
|
|
|
|
|
how i can import from a text file also from database to one datagridview
|
|
|
|
|
That's not an import, but simply reading and displaying data. There are multiple articles and tutorials on loading data in a grid.
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.
|
|
|
|
|
any help please for that i have code how to import from database and reading from textfile
now i have difficult in showing data in gridview.
|
|
|
|
|
Show us the code and error-message
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.
|
|
|
|
|
for reading this is my code
Dim ouvrir As New OpenFileDialog
If ouvrir.ShowDialog = DialogResult.OK Then
Dim aline() As String
Dim sr As New StreamReader(ouvrir.FileName)
While Not sr.EndOfStream
Dim ligne As String = sr.ReadLine
aline = ligne.Split(CChar(vbTab))
DataGridView1.Rows.Add(aline)
End While
for import from database this my code
cn.Open()
Dim cmd As New SqlCommand("select * from F_COMPTET", cn)
Using da As SqlDataReader = cmd.ExecuteReader
While da.Read
DataGridView1.Rows.Add(da("CT_Num"))
End While
End Using
|
|
|
|
|
i need help to get my code work for one datagridview.
|
|
|
|
|
I'm having trouble understanding your question; do you want to load from "both" sources into the same gridview and display them as one?
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.
|
|
|
|
|
yes exactly from both to one datagridview
|
|
|
|
|
If you execute one after the other, both would add rows to the datagridview. There is no .Clear() visible in your code, so one would assume it to be appended.
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.
|
|
|
|
|
before i remember i do it like that but now many time trying without a solution
|
|
|
|
|
Dim ouvrir As New OpenFileDialog
If ouvrir.ShowDialog = DialogResult.OK Then
Dim aline() As String
Dim sr As New StreamReader(ouvrir.FileName)
While Not sr.EndOfStream
Dim ligne As String = sr.ReadLine
aline = ligne.Split(CChar(vbTab))
DataGridView1.Rows.Add(aline)
End While
cn.Open()
Dim cmd As New SqlCommand("select * from F_COMPTET", cn)
Using da As SqlDataReader = cmd.ExecuteReader
While da.Read
DataGridView1.Rows.Add(da("CT_Num"))
End While
End Using
There's only "adding" done to the rows, so both should be visible if you execute this.
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.
|
|
|
|
|
thats not work and as i told you before i tested it and didnt work
it show the data above eatch other always
because of comun selected
in
DataGridView1.Rows.Add(da("CT_Num"))
|
|
|
|
|
In the first block of code, you add an array of String s. You should add a string-array of similar size in the second block.
DataGridView1.Rows.Add(Convert.ToString(da("CT_Num")).Split(CChar(vbTab)))
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.
|
|
|
|
|
its always takes first column
like this datagridview.rows.add(column1,column2,column3...)
in first place when read textfile with split it take many column but when with database it take always first column
|
|
|
|
|
Yes, because that's the only column you read from the database.
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.
|
|
|
|
|
but its filled from textfile
|
|
|
|
|
It is filled with an array of strings from the first text-file. Then you only select one column from the database.
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.
|
|
|
|
|
If it's not "delimited" (for columns), your best choice is to load "lines", one line at a time, into a column templated as a TextBlock, with TextWrapping turned on.
Load the strings into a list and assign the list to the grid's data source.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
my problem not in import or reading
my problem is i can manage to add a column for importing data from database always take same column in datagrid that occupied from textfile
i need something like this (column1 from textfile,column2txt,column3txt,column4 from database)
or (column1 from database,column2txt,column3txt,column4txt)
|
|
|
|
|
Then, how are the 2 related?
You can read one "data source" then "link" to the other via "something in common"; e.g. a "key".
Then the 2 can be combined.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
how i can do that , this the idea i looking for
import from text file link it to something datatable for exemple
after import from database link it to same that linked before from textfile
after add it to datagridview
please help me this the idea i looking for
|
|
|
|
|
You're implying you don't know the contents of your data and how they relate.
That's like saying you don't know your own name or color of your eyes.
You need to "study your data" or ask some one why you are doing what you are doing.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|