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

More Search Options

RSS Available

• Re: exporting data from gridview to excel sheet

  try this http://www.highoncoding.com/Articles/86_Exporting_GridView_to_Excel.aspx http://www.highoncoding.com/Articles/197_Extensive_Study_of_GridView_Export_to_Excel.aspx http://www.highoncoding.com/Articles/202_GridView_Export_to_Excel_Button_Control.aspx

  Posted to Data Presentation Controls (Forum) by etariq on 3/10/2009

• Re: Extracte string

  oh and this select LEFT('abdsfdsc.Rawal.efg',charindex('.','abdsfdsc.Rawal.efg')-1)as lvl1, Right('abdsfdsc.Rawal.efg',Len('abdsfdsc.Rawal.efg')-Charindex('.','abdsfdsc.Rawal.efg',1))as reman, Charindex('.',Right('abdsfdsc.Rawal.efg',Len('abdsfdsc.Rawal.efg')-Charindex('.','abdsfdsc.Rawal.efg',1)))-1 as num, Left(Right('abdsfdsc.Rawal.efg',Len('abdsfdsc.Rawal.efg')-Charindex('.'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by etariq on 3/10/2009

• Re: Extracte string

  you can use this function CREATE FUNCTION dbo.fn_Split(@sText nvarchar (4000), @sDelim varchar (20) = ' ' ) RETURNS @retArray TABLE (idx smallint Primary Key , value nvarchar (4000)) AS BEGIN DECLARE @idx smallint , @value nvarchar (4000), @bcontinue bit , @iStrike smallint , @iDelimlength tinyint IF @sDelim = 'Space' BEGIN SET @sDelim = ' ' END SET @idx = 0 SET @sText = LTrim ( RTrim (@sText)) SET @iDelimlength = DATALENGTH (@sDelim) SET @bcontinue = 1 IF NOT ((@iDelimlength

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by etariq on 3/10/2009

• Re: Help!! Sql connection can not be closed~~could anyone help??

  remove the Conn.Open(); from here and open it from where you use it protected SqlConnection GetConnection() { SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); return Conn; }

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by etariq on 3/8/2009

• Re: clearing vb textboxes on form with tool container

  and if web simply you can use <input name="reset" type="reset" value="reset">

  Posted to Free For All (Forum) by etariq on 3/5/2009

• Re: Get default vale of table field

  yes you can SELECT SO. NAME AS " Table Name ", SC. NAME AS " Column Name ", SM. TEXT AS " Default Value" FROM dbo. sysobjects SO INNER JOIN dbo. syscolumns SC ON SO.id = SC.id LEFT JOIN dbo. syscomments SM ON SC.cdefault = SM.id WHERE SO.xtype = 'U' ORDER BY SO.[name], SC.colid you can get the rest from here http://www.mssqltips.com/tip.asp?tip=1512

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by etariq on 3/5/2009

• Re: VIEW ALL DATABASE PROBLEM

  in your sql select statment in SP should be like this CREATE procedure school_Search @ID int = -1, STATE nvarchar (50) = -1 AS SELECT * FROM COUNTRY INNER JOIN STATE ON STATE.COUNTRY_ID = COUNTRY.COUNTRY_ID WHERE (COUNTRY.id = @ID or @ID = -1) and (STATE.STATEID = @STATEID or @STATEID = -1 ) GO hope you got the Idea

  Posted to Data Presentation Controls (Forum) by etariq on 3/5/2009

• Re: StringUtils

  C# string strorig = "AaaaBbbbEeee" ; string newstr = strorig.Replace( "a" , "?" ); VB Dim strorig As String = "AaaaBbbbEeee" Dim neestr As String = strorig.Replace( "a" , "?" )

  Posted to Visual Basic .NET (Forum) by etariq on 3/1/2009

• Re: Repeater

  i use this http://www.codeproject.com/KB/custom-controls/CollectionPager.aspx

  Posted to Data Presentation Controls (Forum) by etariq on 3/1/2009

• Re: Select Get Unlimited Id's

  You can start here http://msdn.microsoft.com/en-us/library/ms525394.aspx

  Posted to Web Forms (Forum) by etariq on 3/1/2009