Hi Bernhard, Yep, i already did that but no luck. I don't understand why it return only 1 row. The work around that I did was like this. DataTable dt = new DataTable(); MySqlCommand command = new MySqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "SELECT useraccess_privileges.MenuName, user_access.* FROM useraccess_privileges LEFT JOIN user_access ON user_access.UserName=useraccess_privileges.UserName"; MySqlDataAdapter da = new MySqlDataAdapter(command); da.SelectCommand.Connection = conn; da.Fill(dt); If the above code was applied then it will return the correct row number. I really don't understand why. Thanks if(you type your code here) { Messagebox.Show("You help me a lot!"); } else { You help me = null; }

Hi Ali, I already sent the code. Thanks for the help. Cheers! if(you type your code here) { Messagebox.Show("You help me a lot!"); } else { You help me = null; }

Hi bVagadishnu, You help me alot. Works perfectly!!! Thanks if(you type your code here) { Messagebox.Show("You help me a lot!"); } else { You help me = null; }

With the Browse Code tab it isn't really necessary to download the code to learn what it does and how it does it. That may explain the low numbers. I know the language. I've read a book. - _Madmatt

Le Centriste wrote: Do you even know C#? Yeah but not that good as in VB6. if(you type your code here) { Messagebox.Show("You help me a lot!"); } else { You help me = null; }

Hi Simon, Thanks for giving sample program. I'll try this one. By the way, Can you look at the code below. That is my clsConnection where i execute my queries. Is it safe? And can you point out in my code if there is something bad code. This is the way i used it. E.g. clsConnection myConn = new clsConnection(); DataTable DT = new DataTable(); string SQL = "SELECT \* FROM tblUsers"; DT = myConn.ExecuteQuery(SQL); using System; using System.Data; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using System.Collections; using System.Windows.Forms; namespace Micromix.Class { class clsConnection { public SqlConnection objConnection; SqlTransaction objTransaction; public bool SqlConnect() { try { objConnection = new SqlConnection(); objConnection.ConnectionString = Connect.ConnString.ToString(); //objConnection.ConnectionString = "Persist Security Info=False;User ID=sa;Initial Catalog=MICROMIX\_PP;Data Source=(local)"; //objConnection.ConnectionString = "Server=" + GetServer("\\\\conn.cfg") + "; DataBase=" + GetDatabase("\\\\conn.cfg") + "; User ID =" + GetUser("\\\\conn.cfg") + "; Integrated Security=false"; if (objConnection.State == ConnectionState.Closed) objConnection.Open(); return true; } catch (Exception ex) { MessageBox.Show("Failed to connect to data source.", "Connect Failed", MessageBoxButtons.OK, MessageBoxIcon.Warning); MessageBox.Show(ex.Message); return false; } finally { objConnection.Close(); } } public DataTable ExecuteQuery(string strSQL) { DataTable objDataTable; SqlDataAdapter objDataAdapter; try { SqlConnect(); objDataAdapter = new SqlDataAdapter(); { objDataTable = new DataTable(); objDataAdapter.SelectCommand = new SqlCommand(strSQL, objConnection, objTransaction); objDataAdapter.Fill(objDataTable); return objDataTable; } } catch (Exception sqlex) {

hi, thanks for the reply. My OS is Windows Vista Home Premium Edition. I read many instruction on how to properly install this, i also follow some KB but no one help me to install the SQL. Thanks and Regards. if(you type your code here) { Messagebox.Show("You help me a lot!"); } else { You help me = null; }

Vuyiswa Maseko, yes your idea in using VB2008 is good, but the program is existing and i just want to update there existing program. And the program is running in a third party software which is a Rockwell Software what they called RS View also the program is VBA not totally VB6. Maybe i will try all your suggestions. Thanks Regards, klaydze if(you type your code here) { Messagebox.Show("You help me a lot!"); } else { You help me = null; }

Hi Khatri, Thanks for giving me the link. Maybe in the future i can use that. But i found no answer in my problem. Any other way? Thank You. if(you type your code here) { Messagebox.Show("You help me a lot!"); } else { You help me = null; }

I can't remember if there is such property but if there is not, you can handle ColumnWidthChanging event of the listview class and cancel the event #region signature my articles #endregion

Simple - the two objects you create in the two methods are different. Anyway, this is wrong on so many levels. Your classes should be nouns, not verbs. Also, you don't even need a new class to store the user name in this case. In your form, just declare private string _userName; Then, in your methods, you can read and modify _userName directly. Cheers, Vikram. "I will put my new found knolage to good use" - Captain See Sharp. "Every time Lotus Notes starts up, somewhere a puppy, a kitten, a lamb, and a baby seal are killed." - Gary Wheeler.

This seems lazy to me. I would have thought it would be a good introduction to C#, converting existing code. Bob Ashfield Consultants Ltd

I don't know, but guess with the use of LINQ, may be you can get this! Please someone answer back if more information related to this is found. thanks, Jwalant Soneji (BE IT) (India) Mobile: +91 9969059127 At Winodows Live Spaces At Yahoo! 360 At BlogSpot

oh yes sir i do understand that. i just explaining my previous code. :) the code is working now. thank you very much. i wish you are open again when i have a difficulties in my code. Thank You. Don't block the drive way of all the newbies in programming. :)

try the same code as you see. paste it in button in vb.net Don't block the drive way of all the newbies in programming. :)

i'm using express. so it means that i cannot import a crystalreportviewer in express? Don't block the drive way of all the newbies in programming. :)

In VB2005 it would be like this: My.Computer.Keyboard.SendKeys(Keys.Home & Keys.End) Trinity: Neo... nobody has ever done this before. Neo: That's why it's going to work.

thx for the Info Dave.:) Don't block the drive way of all the newbies in programming. :)