You searched for the word(s): userid:779058

More Search Options

RSS Available

• Re: join cells in datatable

  Hi cortezzz, As I know, there's no direct way to complete it in a datatable. Thus I think whether you can do it manually, which I mean to merge the cell values and add it in a new cell. Thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/27/2009

• Re: BOs issue

  Hi tauseef81, [quote user="tauseef81"] i just want business entities in my UI layer not their datacontext methods and also i want seperate class for each my datatable. [/quote] For the entity classes generated by LINQ to SQL/Entities, I think you have to refer the DAL in both BLL and UI. Although the 3-tier structure recommends us not to refer DAL in UI, but in this case, I think you have to since the classes in auto-generated in DAL rather than in BLL. Thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/27/2009

• Re: Bulk Insert into table - How to manage the transaction?

  Hi bonusnet, [quote user="bonusnet"] My question is, 1. How ADO.NET can control the Atomicity for this Bulk Insert (12 insert into the table)? 2. Did i need to check the sum of the 12 ticket <= $125.45 first, then perform the transaction? [/quote] 1) You just need to change the command text within the single transaction. 2) A transaction is used for all the database operations, and if there's any sql exception, the transaction will be rolled back. Thus I think checking the sum of

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/27/2009

• Re: Export data in excel not in excel spreadsheet

  Hi mamtagupta, Please check this sample on MSDN: http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.applicationclass(office.11).aspx Thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/27/2009

• Re: Using db xsd - need to change the connectionstring dynamically

  Hi purell, [quote user="purell"] I need to change the connectionstring of the web.config dynamically. But I don't know how to do it in the db xsd. Is there a way to dynamically change the connectionstring through the code behind (like the password, etc?) [/quote] As I know, you can't change it dynamically. Also, I don't think you have to change it dynamically. You just have to change the connection string in web.config if you want to change another database. Thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/27/2009

• Re: OleDB excel import character limit

  Hi supradip_d, Did you read this article and try it? http://www.dicks-blog.com/archives/2004/06/03/external-data-mixed-data-types/ Thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/27/2009

• Re: Export data in excel not in excel spreadsheet

  Hi mamtagupta, You can open a download dialog like this: http://www.west-wind.com/weblog/posts/76293.aspx http://support.microsoft.com/kb/260519 Thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/27/2009

• Re: Export data in excel not in excel spreadsheet

  [quote user="mamtagupta"] how can i add my workbook in this response.write(). [/quote] You just need to set the response header like this: Response.AppendHeader( "Content-Disposition" , "attachment; filename= sample.xsl " ); Thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/27/2009

• Re: Sql Multiple Filters Depend on Each Filter

  Hi Eisenheim, Based on your description, I think you can do it in this way: 1) If you have 10 criterias, for example, you have to add all of them in select parameters. 2) Set the DefaultValue property so that if there's no value selected, it'll not impact filtering. 3) Set the PropertyName property to get the selected value. For example: <SelectParameters> <asp:ControlParameter ControlID="DropDownList1" PropertyName="SelectedValue" Name="ID" Type="Int32"

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/26/2009

• Re: Property evaluation failed - Error in .XSD Page

  Hi srkvellanki, Are you sure there's no problem with the type or the length in both XSD and database? Also, did you check and update the queries? Please check it again and if you still can't resolve the problem, show us more details so that we can help you better. Thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Wencui Qian - MSFT on 11/26/2009