Hi all, I have created a COM wrapper component in c#.net. I generated .tlb file out of it. Also I added reference to tlb file in VB 6.0 application and can able to call functions of COM wrapper. In C#, i have declared a stringcollection to collect all the errors.But while mapping,this String collection is converted to Unknown in VB 6.0 and becoz of that i got mismatch error. so i changed the stringcollection to Arraylist in C#. This Arraylist is converted to String in VB 6.0 while mapping. and i got error while i tried to retrive the string. Plz give me suggestions on how to call a Stringcollection/arraylist in VB 6.0. Thanks in Advance,

cheers sangeet

hi all, I am working in sql 2005 migration. when i ran same query in sql 2000 and sql 2005,no of values return are same.But the Resulting data is in different order. In sql 2005 the data returns either in asc or desc order. In sql 2000 the data returns in random order. plz clarify me 1.the reason for the rows order difference.(is it because of execution plan?) 2.The resulting data of sql2005 should be in same order of sql 2000. how to overcome this problem. Thanks in advance,

cheers sangeet

hi, my project was developed in vb 6.0 with sql2000 as backend.now i am working in SQL2005 upgration. when i try to exucte a crystal report(7.0) from a vb component,i get the following error. Cannot connect SQL server .20599 I doubt that the problem exists with CRPEAUTO. Or do i need to add any dlls as references.. Plz give ur suggestions to reslove the problem Thanks in advance

cheers sangeet

hi all, In our code,SQL DMO objects(Sql 2000)are used in the VB components. Now we are doing SQl 2005 upgradation.when i ran the same component in SQl 2005, i got the following error. To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO) .I read in an article that we have to reregister SQL-DMO 2005 version.but i have to change that DMO object to SMO in code. Plz give suggestions on how to convert DMO to SMO. Thanks in advance,

cheers sangeet

hi all i need to find members whose age is greater 75 yrs.how to calculate age from the give DOB. I used the following code. DOB <= Dateadd(yy,-75,getdate()) Plz help me to find out the correct way thanks in advance

cheers sangeet

Hi all, I have an usercontrol where i gave a radiobutton list.(rblTest) I am using this usercontrol in my aspx page. RadioButtonList rblTest= (System.Web.UI.WebControls.RadioButtonList)myControl1.FindControl("rblTest"); I need to handle onselectindexchanged method of radiobutton list in aspx page. How to do that. Plz give ur suggestions. Thanks in advance

cheers sangeet

Hi all, I have number of textboxes on a form and a submit button. the form allows the user to change existing data in the database. when a textbox is modified, i need to capture the changes done by the user and update the collection i've used to populate the text boxes and then to use the updated collection to update the database. How to trace which textbox value is changed.i need to update only the values changed. Plz give suggestions.. Thanks in Advance,

cheers sangeet

Thanks for ur quick response. In my case,am using the dataacces code only in the service and also performance matters. I think its better to use the dataaccess code in the service itself. Thank you.

cheers sangeet

Hi all, I have created windows service which inserts data on timer basis. Right now am using dataconnections,queries in the windows service itself. Instead i can call webservice to insert data. I want to know whether which method works good. 1.using dataconnections in the windows service or Calling webserive for data insertion. Plz give ur suggestions Thanks in advance

cheers sangeet

hi all, I have a Dropdown box(Active/Inactive) in Asp updateform.If the user selects Inactive and updates the form,then SP gives an output message that Inactive is selected. Here i need to keep an confirm box using java script.This should be called only when Inactive is selected. So i wrote code like this //.cs protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e) { if (myCommand_update.Parameters["@out_Message"].Value != DBNull.Value) { Status_Msg.Text = Convert.ToString(myCommand_update.Parameters["@out_Message"].Value); update_btn.Attributes.Add("onclick","return confirm_update();") } } //java script function confirm_update() { if (confirm("Would you like to Inactive the same?")==true) return true; else return false; } but it is not working. If active is selected there will be no ouput meaasge. Plz help me to find the solution Thanks in advance,

cheers sangeet

Hi, I need to show a tooltip on Radgrid Hyperlink on mouseover/Mouseout event. Is it possible to get tooltip for Hyperlink in radgrid. Please give sugestions thanks in Advance,

cheers sangeet

Yes..all the year with same date and time. I got it by just adding Convert.ToDateTime(@"1/1/" + Year_Tbox.Text) thanks for ur reply..

cheers sangeet

hi all, In my page,I have to enter only year(eg 1999) in the textbox.but it should be inserted as datetime format in DB. how to convert year to datetime format in c#. Eg: 1999 to 1/1/1999 12:00:00 AM Plz give ur suggestions thanks in advance

cheers sangeet

thanks for ur reply .. i tired the code. but still am getting the same error. ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'INSRTEVNT' expects parameter '@EventType', which was not supplied. plz give me suggestions

cheers sangeet

hi all, I am workingin a windows where i need to insert data into the Db using ODBC connection.I used stored procedure to insert data. here is the code EventType,Eventdate,vehicle I declared correctly and getting correct values also System.Data.Odbc.OdbcCommand Emp = new System.Data.Odbc.OdbcCommand("DBO.INSRTEVNT", mycon); addEmp.CommandType = CommandType.StoredProcedure; Emp.Parameters.Add("@EventType", System.Data.Odbc.OdbcType.Int).Value = **EventType;** Emp.Parameters.Add("@EventTime",System.Data.Odbc.OdbcType.DateTime).Value = **EventDateTime**; Emp.Parameters.Add("@Vehi", System.Data.Odbc.OdbcType.VarChar).Value = **Vehicle**; Emp.ExecuteNonQuery(); but when i execute the code,the data are not inserting and throwing exception. here it is ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'DBO.INSRTEVNT' expects parameter '@EventType', which was not supplied. but I passed correct data only.. Plz give me suggestions to resolve the problem. Thanks in advance.

cheers sangeet

hi all, I have been using Rad controls for charts.but here i cannot able to get 3d charts. how to get 3d charts in Asp.net ? plz give ur suggestions. Thanks in advance.

cheers sangeet

hi all, I am working on a page where i have a grid to show the data from the table.I want this grid to be refreshed every 5 mins as the data in table updates every 5 mins. how it is possible to refresh the grid.. plz give ur suggestions on this. Thanks in Advance,

cheers sangeet

hi all, i am creating a page in asp.net using c#.To insert the data,i just wrote the sql command for inserting and followed the same for edit and update. for example.. string myinsertQuery = "insert into DriveUnits(SerialNumber,CorporationID,CorporationDivisionID,HWVersion,DateManufactured) values('" + SrNumber_TBox.Text + "','" + Session["corporationid"] + "','" + CorporationDivisionID + "','" + Hwversion_Tbox.Text + "','" + DateMFD_TBox.Text + "')"; SqlCommand myCommand_insert = new SqlCommand(myinsertQuery); myCommand_insert.Connection = myConnection; myCommand_insert.ExecuteNonQuery(); myCommand_insert.Connection.Close(); but instead of writing code in cs file,i just want to call a class so that wherever we need to insert data,we can just call the class and the functions defined. i created a class and a function and pass parameters.but it is showin invalid arguments.. plz give ur suggestions on creating a class and its functions. Thanks in advance,

cheers sangeet

yes i got it..thanks a lot..

cheers sangeet

hey thanks for ur help..i got it.. but the totalspace,totalfree space are in bytes..how do i convert it to MB or GBs. Thanks again for ur help..

cheers sangeet