thank you

Ramana

HI Friends, I am working on smart device application development using .net compact framework 3.5 (for windows mobile 6.5) . In my mobile UI, used typed dataset to View/Edit/remove etc. I would like to synchronize the data only few selected table data to server using web service. Anyone has how to/best way to synchronize with typed dataset? please help with any link or idea. highly appreciated. thanks in advance

Ramana

OK. then how/what do i configure 32 bit DSN?

Ramana

updated error details..

Ramana

Hi all I am using .net FW 3.5, its desktop applicaiton. MyApplication is fetching data from sybase adoptive server and populating in it. Below connection, code.

connectionString=DRIVER=MERANT 3.60 32-BIT Sybase;UID=test;DB=db1;SRVR=XYZSERVER;PWD=*****

using (OdbcConnection connection = new OdbcConnection(connStringFromConfig)
{
OdbcDataAdapter adapter = new OdbcDataAdapter(query, onnection);
connection.Open();
adapter.Fill(dt);
connection.Close();
}

above code works fine in windows xp. where as same code is not working in windows 7. I am executing in 64bit machine. i got error while opening connection.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Anything i am missing ? or do i need to configure anything? appriciated u r quick response.

Ramana

Hi all I am using .net FW 3.5, its desktop applicaiton. MyApplication is fetching data from sybase adoptive server and populating in it. Below connection, code.

connectionString=DRIVER=MERANT 3.60 32-BIT Sybase;UID=test;DB=db1;SRVR=XYZSERVER;PWD=*****

using (OdbcConnection connection = new OdbcConnection(connStringFromConfig)
{
OdbcDataAdapter adapter = new OdbcDataAdapter(query, onnection);
connection.Open();
adapter.Fill(dt);
connection.Close();
}

above code works fine in windows xp. where as same code is not working in windows 7. I am executing in 64bit machine. i got error while opening connection.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Anything i am missing ? or do i need to configure anything? appriciated u r quick response.

Ramana

Hi all, we have My WCF service having one service method, is calling data access layer which is returning the List, here return type is Serializable.class. Data access layer is calling a stored procedure which is returning 170 records from the database. i have invoked the service method from client, getting exception "The underlying connection was closed: The connection was closed unexpectedly". i modified my SP to return top 140 recrods, then its working fine. Here is the my binding config at service. Any thing i have to change?

here is my client config.

Hi all, I have WCF service (Service1) with webservice methods, few of these webmethods are returning custom classes from a library (dll), this library contains all Serializable classes & few typed datasets. for example dll root namespace is ABC.XYZ.BusinessEntities and it has few sub namespaces like .Entities & .Contracts. 1) i have specified the following at IService.cs file

[ServiceContract(Namespace = "urn:ABC.XYZ.WSTT")]
[XmlSerializerFormat]
[ServiceKnownType(typeof(CustomDataSet1))] //typed dataset
[ServiceKnownType(typeof(Employee))] //custom class
public interface IService

2. class level i specified as

[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
[ServiceBehavior(Namespace = "urn:urn:ABC.XYZ.WSTT")]
public class Service : IService
{
//fun1 returns typeddataset1
public CustomDataSet1 GetDataSet1() {}

  //fun2 retuns employee1
  public Employee GetEmployee(int empID)
  {
      return XYZDataManager.GetEmployee(empID);
   }

}

3. i confirgured as bindingConfiguration="basicHttpBindingWindows and now WCF service is working fine. i have generated proxy using svcutil.exe http://localhost/WSTT/Service.svc?wsdl /r:..\..\BusinessEntities\bin\Debug\ABC.XYZ.BusinessEntities /ser:Auto /out:ServiceClient.cs /noConfigand finally if i build my client project, GetEmployee return type should be "ABC.XYZ.BusinessEntities.Employee" instead i am getting just as Employee. How do i get the fully qualified custom return types in proxy? please help any thing wrong i did?

Ramana

Hi All, I have one web application which is having asmx web service files(created using 2.0). Now i have added few svc files to the same web application. Anyone please tell me, how do i convert this application to ASP.NET Web Service Application (3.5) I have seen a option, where you can "Convert to web Application" option for Web Service Applications. But I need vice versa procedure. pleeeeeeeeeeeeeease help me.

Ramana

Hi, I am using VS 2008. My Datagridview is having bounded columns. Datasource is using as DataSet with Binding source. I wanted to show these as vertical view ( swaping columns to rows) how can i do? please help me

Ramana

Hi all, i created database.dbml file along with table1, table2. now i wanted to fill result set of table1 into a DataTable (ex: select * from table1 where table1Id=100) please help me

Ramana

I have sql (sql server 2005) table which is having StartDate and EndDate datetime columns.

StartDate value inserting as 2009-08-11 00:00:00.000,
EndDate value inserting as 2009-08-11 23:59:00.000 (End of the day

This DB Server is located at london. in my winforms(2.0) appliction i have typed dataset, is having same table schema. Typeddatasset StartDate and EndDate DateTimeMode property set to UnspecifiedLocal. i am populating this dataset with SP. SP is functioning properly. returned data i am binding to DataGridView. when its biinding to datagridview,

StartDate is showing as '8/11/2009 4:30 AM' instead of '8/11/2009 12:00 AM' and
EndDate is showing as '8/12/2009 4:29 AM' instead of '8/11/2009 11:59 PM'

it seems problem is with databinding to dataset. any sounds?

Ramana

yes, if you have any other way to do. please help me

Ramana

I have sql (sql server 2005) table which is having StartDate and EndDate datetime columns. <code>StartDate value inserting as 2009-08-11 00:00:00.000, EndDate value inserting as 2009-08-11 23:59:00.000 (End of the day).</code> This DB Server is located at london. in my winforms(2.0) appliction i have typed dataset, is having same table schema. Typeddatasset StartDate and EndDate DateTimeMode property set to UnspecifiedLocal. i am populating this dataset with SP. SP is functioning properly. returned data i am binding to DataGridView. when its biinding to datagridview, <code>StartDate is showing as '8/11/2009 4:30 AM' instead of '8/11/2009 12:00 AM' and EndDate is showing as '8/12/2009 4:29 AM' instead of '8/11/2009 11:59 PM'</code> it seems problem is with databinding to dataset. any sounds?

Ramana

modified on Wednesday, August 12, 2009 4:15 AM

hi, in my project we are using asp.net 2.0 GridView in so many places. Through out the project we are using GridView derived control.

public class GridView : System.Web.UI.WebControls.GridView
{
//logic
}

i have added code to maintain seleced checkboxes state, DataKey value ID of selected rows if user selects multiple rows from multiple pages navigation. i am storing the 1) ID, 2) Selected in the ViewState in the form of List. For this i have 2 methods

StoreCurrentViewState() //Here i am adding, removing the entries into the ViewState list
RestorePastViewState //Here i am resetting the checkedboxes.

this code i have used at...

protected override void OnPageIndexChanging(GridViewPageEventArgs e)
{
      StoreCurrentViewState();
      base.OnPageIndexChanging(e);
      RestorePastViewState();
}

also added at

protected override void OnDataBinding(EventArgs e)
{
      StoreCurrentViewState();
      base.OnDataBinding(e);
}

protected override void OnDataBound(EventArgs e)
{
      base.OnDataBound(e);
      RestorePastViewState();
}

it is maintaining selected checkboxes states during the gridview page naigation. my query is ... in one aspx page i have 4 grids and for all page it is storing in single ViewState object. i wanted to store these values in sepearate viewstate for each gridview && i need to reset the ViewState object if gridview loads first time. How can i do? please provide ur inputs...

Ramana

There are two tables, NAMES (ID INT IDENTITY (1,1), NAME VARCHAR(255)) and RELATIONSHIPS ( NAMEID INT , PARENT _ NAMEID INT ) linked via NAMES.ID = RELATIONSHIPS.NAMEID and where top-most name has a PARENT _ NAMEID = 0. Show a nested list of names including LEVEL , NAMEID and NAME , where LEVEL indicates the nest level (or depth) from the top, as indicated in the expected output (below). NAMES table content: ================== ID NAME 1 Frank 2 Jo 3 Mary 4 Peter 5 Amy RELATIONSHIPS table content: ========================== NAMEID PARENT _ NAMEID 1 0 2 1 3 2 4 1 5 2 Expected Output: =================== In the expected output, please note The sequence of the output, in which child elements appear immediately beneath their respective parent elements. LEVEL ID NAME 0 1 Frank 1 2 Jo 2 5 Amy 2 3 Mary 1 4 Peter any sounds please...

Ramana

These are the versions 1) Vista Home Basic 2) Vista Home Premium 3) Business 4) Ultimate which version is better?

Ramana

Hi, I am using VS 2005, SQL Server 2005 in windows XP. I wanted to used all these in windows vista anybody please tell me which windows version is better for .Net developers.

Ramana

Hi, I am using VS 2005, SQL Server 2005 in windows XP. I wanted to used all these in windows vista anybody please tell me which windows version is better for .Net developers. thanks Ramana

Ramana

Hi using asp.net 2.0, i wanted to display some text in Hyperlink mouseover event. any body plz tell me how to do? thanks

Ramana