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

More Search Options

RSS Available

• Re: Using for xml path in sql Function

  Hi what is " AC1" refered here, Is that different table and what is the relation between to the EDesp table?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by CoolBond on 11/27/2009

• Re: GridView Sorting is not working. ViewState breakup?

  Hi since you have already used session variables I just modified your code to store the changes on your sorting.

  Posted to Data Presentation Controls (Forum) by CoolBond on 11/26/2009

• Re: Problem using PUSH method: Only first page of report loads correctly.

  Hi Since the report does not preserve your data on page_load event, so you have to rebind your data on page load. You can acheive this in 2 ways Just call your report bind method on page load like protected void Page_Load(object sender, EventArgs e) { LoadRepor() } In this maethod you have to preserve your data also, Or simply store your created report in session and on page load rebind the report with the viewer Private Sub RunReport(ByVal ReportName As String, ByVal ContractID As Integer, ByVal

  Posted to Crystal Reports (Forum) by CoolBond on 11/25/2009

• Re: How to get the last updated records primary key value (varchar)

  Hi, If you have any auto increment field in your table, then in your SP write a query like the below after your insert statement INSERT INTO your_table values('PK1'); Select PKfielName from your_table where record_id = (SELECT scope_Identity()) But if you use a varchar field as a primary key field, anyhow you r going to send the value for that field. but why do you want it to read from table, And if my understanding is wrong and you need the primarykey field on update, just use the same query

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by CoolBond on 11/24/2009

• Re: cusrtomize crystal reports

  Hi I dont think is there any link for that but we have functions for every method in the crystal toolbar(you can customize the viewer toolbar, not the viewer itself). I will create a solution to this and will update you soon. Meanwhile if you find any solution update it here

  Posted to Crystal Reports (Forum) by CoolBond on 11/24/2009

• Re: how to use image instead of text in crystal report

  Hi you r welcome If the post helped you, please Mark as Answer , so it will help others Thanks

  Posted to Crystal Reports (Forum) by CoolBond on 11/21/2009

• Re: cusrtomize crystal reports

  Hi You can hide group using the below code, but cant enable/disable the group tree. CrystalReportViewer1.HasToggleGroupTreeButton = false; Removing all options except pdf in export also tedious work. Instead what you can do is, you can create your own crystal report viewer with whatver option you require and hide the existing toolbar and place the crystal reportviewer under your toolbar

  Posted to Crystal Reports (Forum) by CoolBond on 11/21/2009

• Re: extract data from one table to another

  Hi Create a function which will give you the splitted string, then create a SP which will insert the data from splitted funtion SQL function CREATE FUNCTION [dbo].[SplitString] ( @InputString VARCHAR(8000), @SplitChar CHAR(1) ) RETURNS @MyTbl TABLE(_ID VARCHAR(4000)) AS BEGIN DECLARE @LENInputString AS INT DECLARE @x AS INT DECLARE @SingleChar AS VARCHAR(4000) SET @LENInputString = LEN(@InputString) SET @x = 0 WHILE (SELECT @x) < @LENInputString BEGIN SET @SingleChar = SUBSTRING(@InputString,

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by CoolBond on 11/21/2009

• Re: xsl split

  Hi If you use Xmldocument for this, you can use the below code XmlDocument oXdoc=new XmlDocument(); oXdoc.LoadXml("<product><title>Title1</title><link>http://www.homepages.nl/h1/id/OOSTENRIJK/places/test.html</link> </product>"); XmlNode xParentNode=oXdoc.SelectSingleNode("product"); XmlNode xNode=xParentNode.SelectSingleNode("link"); if (xNode != null) { if (xNode.InnerText.Trim().Contains("www.homepages.nl")) { string sData

  Posted to XML and XmlDataSource Control (Forum) by CoolBond on 11/21/2009

• Re: How to preserver search criteria at PageIndexChanged

  Hi I think the gridview does not preserve the selectcommand, so its better set it once again on Page index cheanging event so that the select command will be preserved.

  Posted to Data Presentation Controls (Forum) by CoolBond on 11/21/2009