I've read the article that tells u how to make a setup... and the database it was talking abt was a MS Access Database which they copied in the application folder but in case of MSSQL, I think this will not suffice coz you need to restore that Database in the SQL Server on the end user machine. or whatever ur network configurations are. So just install the application on the end user and restore the Database on the End user machine so that it can work properly. hope it helps Rocky

Thank you Sir, yes it is working now :-) Regards Nekshan.

Damn - for some reason, I thought he said a combo box. I must have been tired... Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

An executable is made whenever you compile your application. It resides in the Debug or Release folder of your project.

Sounds like you want to store a cookie on the local machine. You can't identify someone to store something local, because their IP address is likely to change the next time they connect. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

How are the two tables related? You are missing a part of your where clause, the part where you must specify a.[Some Column] = b.[Some Column]

Christian Graus wrote: Your post is illegible. I second Christian Graus wrote: Try keyvalue is null instead of keyvalue = NULL This one I also second. WHERE keyvalue IS null should fix your problem. Visual Studio can't evaluate this, can you? public object moo { __get { return moo; } __set { moo = value; } }

which query u r using for fetch min date from database.

conn.Open(); SqlCommand cmm = new SqlCommand("select url, sitehit, survey, tellafriend, addtooutlook from tblsummary", conn); SqlDataAdapter ad = new SqlDataAdapter(cmm); DataSet ds = new DataSet(); ad.Fill(ds, "tblsummary"); string str Dim ds As DataSet1 if (ds.Tables(0).Rows.Count != 0) { string str =""; Str = ds.Tables(0).Rows(0)(0).tostring() str += ds.Tables(0).Rows(0)(1).ToString(); str += ds.Tables(0).Rows(0)(2).ToString(); str += ds.Tables(0).Rows(0)(3).ToString(); str += ds.Tables(0).Rows(0)(4).ToString(); } MessageBox.Show(str);

Strictly speaking, the C# version would be DataSet ds = null; because you haven't instantiated it in your VB version, but you may want to consider this version if you want it instantiated DataSet ds = new DataSet(); Deja View - the feeling that you've seen this post before.

You can simplay conconate the output fild in sql query like select field1+field2+....+finldn as newfieldname from tablename now you get only one value per row then as same as you have done Check it I have not try but soure about it.

ok bye.tc

' convert it onto c# this code is i writen in vb ' this answer is the question u ask how to get value in dataset through function ' now u bind that as Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 'write this code place at which u want data. Dim ds As New DataSet ds = RmaSearchByDays("0065xyz", 10) ' if u want to access ds data then write For i = 0 To ds.Tables(0).Rows.Count Dim str As String = ds.Tables(0).Rows(0).Item(0) ' str contain value item(0) means column 0, item(1) means column 1 ok. Next i End Sub Public Function RmaSearchByDays(ByVal ACCOUNT_REF As String, ByVal TotalDays As Integer) As DataSet Dim cn As SqlConnection = New SqlConnection("write here connection strings") Dim cmd As SqlCommand = New SqlCommand() cmd.CommandText = "write here select statement where account_ref='" + ACCOUNT_REF + "'" + "and tdays =" + TotalDays cmd.Connection = cn Dim da As SqlDataAdapter = New SqlDataAdapter() Dim dsResult As New DataSet da.SelectCommand = cmd da.Fill(dsResult) ' Return the dataset result Return dsResult End Function End Class ' this question answer is select top 1 * from tablename order by column_name desc 'column name is column which is unique number columnname ok ' if u not able to understand then replay me.

Happy B'day!! :-) Form2 is execute first,its a login form. After 'login' a 'grid form' opens,it has a logout button, on logout that datetime value must go in a table. Thanx. Take care Enjoy d day!! nekshan.

hi!! i had been refering to article 'passing values betn forms'. I tried from it, but still i cant pass my variable from form1 to form2. I m getting error on passing my variable to the other form's variable. i have used the object approach from that article : http://www.codeproject.com/useritems/pass\_data\_between\_forms.asp Objects of forms are created properly. This i have written in form1 : p = ((form1)log).n; // log is object of form2. //variable 'n' i have to bring from form2,which contains a date from query fired. but i m getting error : 'Object reference not set to an instance of an object.' It would be v.nice if u could help on it. Thanx. -- modified at 6:20 Wednesday 21st February, 2007

My Pleasure :) Thanks and Regards Sandeep

you can set the variable up as a public static property of some class. This isn't the best technique as it is very similar to having a global variable. You could set a property on form2 or pass the value of n into form2 in its constructor, I would rather do one of these depending on how your application is coded. Russell

already replyed see belowed

'private void logout_Click(object sender, EventArgs e) '{ 'conn.Open(); 'string strQury = ""; 'strQury = "insert into dashboarddealerlogin (logoutdatetime) values '(" + DateTime.Now + ")'"; 'SqlCommand cm = new SqlCommand(strQury, conn); 'int n = Convert.ToInt32(cm.ExecuteScalar()); '} 'above query is correct.return value for n is (0 or 1) if n=0 then not row update and n=1 then row updated. error is on something else.