Comments by joseph k - CodeProject

joseph k 19-Jan-12 3:18am View

Its just complicated when it comes to a user interface that used to manage such kind of data. (add, edit , delete)

joseph k 3-Jun-11 2:46am View

This worked! Thanks , it was null

joseph k 2-Jun-11 9:00am View

SOLVED
I just used :
If dsStreets.Tables("tbl_streets").Rows.Count > 0 Then
to get the number of rows on the dataset

joseph k 1-Jun-11 1:57am View

yes , that is true. I dont want to get rid of the first mapping because it is required when the form loads. My problem is Not the mapping, My problem is , how do i refresh the data grid without compromising the mappings. This is after i do a search and mapping details change and i need the data grid to reflect the new search results

joseph k 31-May-11 9:27am View

I would like to refresh this at this point:
<pre> DGVCompanies.DataSource = Nothing
DGVCompanies.DataSource = dsCompanies.Tables("companies").DefaultView
Me.DGVCompanies.Refresh()</pre>

joseph k 31-May-11 6:34am View

Great i managed to nail it properly... Thanks

joseph k 31-May-11 6:33am View

Yes i got the answer , Thanks very much

joseph k 31-May-11 5:00am View

Yes, i want to use a selected item as a value to search for a record in another table called Regions, Am using its 'id' as Foregn key in table Regions , Then i load the results on another combo box

Thanks

joseph k 27-May-11 3:30am View

Thanks, will work on that

joseph k 27-May-11 3:29am View

Thanks , working on all options

joseph k 25-May-11 8:01am View

You meant "Stored Procedures"?

joseph k 25-May-11 5:32am View

Tell me about parametrized query. Where to start...

joseph k 25-May-11 4:26am View

Ok I got it This is the code in VB, C# is different.
Dim frm As New frmLogin
frm.ShowDialog()
It works very well

joseph k 25-May-11 4:17am View

the forms you create in VB are WinForms? Well
am using this code:
Dim frm As New frmLogin
frm.MdiParent = Me
frm.ShowDialog()
When i add frm.ShowDialog(DialogResult.OK) it says it cant be converted to win32 forms

joseph k 24-May-11 9:50am View

Yes it is my solution and i have been here alone while i asked questions and read the tutorials. I think you are wondering why am asking about the white pane... ehehe.... Yes i added the Crystal Report Viewer and definitely it comes with that section AND i was just wondering what is the the use of it because when i open the report it is blank white, it has nothing and i want to know everything so that i don't come back to the same questions again.. I want to make my report look nice since i have learnt the various ways of putting data to it, i want to make more useful to the user. For your information, i only have a basic knowledge in MsAccess Programming. I have never used this .NET before and Crystal Reports, I have just heard of them and now was my time to learn it by myself.

joseph k 24-May-11 8:55am View

This is getting sweeter:
I followed instructions on this page for C#
http://www.codeproject.com/KB/database/MySQLCrystal.aspx
When i reached the title "Display Report in the Form"
I could not figure out how to do that and you gave me the link above : http://vb.net-informations.com/crystal-report/crystal_report_from_sql_query_string.htm
and i got the code just the last four lines of the sub routine.

joseph k 24-May-11 4:03am View

Great help, i have completed the tutorials and currently using ODBC Mysql Connector to connect to DB and get report data.
Now, what if i want to place a search BOx on my form so the report can show that record only.

joseph k 24-May-11 3:07am View

Let me go through it, Can i mix C and VB codes?? I hope its going to be easy to translate to vb.net

joseph k 24-May-11 3:04am View

Well, i just placed the report viewer inside the form. I have never done this before, please guide me to design the report first.

joseph k 23-May-11 2:20am View

Thanks, this was a very good lead to my problem, i solved it.

joseph k 23-May-11 1:34am View

Ok, Thanks for your response: check the code below as i have initialised dt to get data from a table:
<pre lang="vb">
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim dt As DataTable = cnGetData.Tables("tbl_permits")

If txtbname.Text = "" Or txtbname.Text = "" Then
MsgBox("Please fill up Company Name Information.", MsgBoxStyle.Critical)
Me.txtbname.Focus()

Exit Sub
End If

Try
If State = gModule.FormState.adStateAddMode Then
' add a row
Dim nRow As DataRow

nRow = dt.NewRow()</pre>

and I have also set the: Dim cnGetData As New DataSet()

Comments by joseph k (Top 21 by date)