true

KiranKumar Roy

Exactly true.. :)

KiranKumar Roy

For Changing the Orientation of your Crystal report to Landscape. Right click on your report -> Design -> Printer Setup. There you will find Orientation Option Change it to Landscape.

KiranKumar Roy

Hello, I really dont know this will help you or not.. But still i want to give my try.. you can try to get your solution by sql query.. Below to create test table

CREATE TABLE [ForTest](
[id] [int] NULL,
[id2] [int] NULL,
[vak] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[ForTest] ([id], [id2], [vak]) VALUES (1, 1, N'abc')
INSERT [dbo].[ForTest] ([id], [id2], [vak]) VALUES (1, 1, N'xyz')
INSERT [dbo].[ForTest] ([id], [id2], [vak]) VALUES (2, 2, N'pqr')
INSERT [dbo].[ForTest] ([id], [id2], [vak]) VALUES (2, 2, N'mno')

and below query to get result as per you wish..

SELECT
distinct P.id,
STUFF
(
(
SELECT ',' + vak
FROM ForTest M
WHERE M.id = P.id
ORDER BY id
FOR XML PATH('')
), 1, 1, ''
) AS Models
FROM
ForTest P

Hope this will work for you...

KiranKumar Roy

Use window.open() for more info go through this link

KiranKumar Roy

Go through below link.. Pascal Triangle

KiranKumar Roy

helping hand!! ;)

KiranKumar Roy

I am really very sorry for posting VB code in C# forum.. I just want to give idea to ASPnoob, So he can apply according logic in his code. I will keep in mind that i will not post VB Code in C# form. Thanks.

KiranKumar Roy

use below SQL function to convert DD/MM/YYYY string to Datetime.. Make sure every time u pass "DD/MM/YYYY" format only.

CREATE FUNCTION ChangeDateFormat
(
@STRING NVARCHAR(40),
@DELIMITER NVARCHAR(40)
)
RETURNS DateTime
AS
BEGIN
DECLARE @MM as varchar(5)
DECLARE @DD as varchar(5)
DECLARE @YY as varchar(5)
DECLARE @POS INT
DECLARE @NEXTPOS INT
DECLARE @INT INT
DECLARE @TEMP as varchar(50)
SET @STRING = @STRING + @DELIMITER
SET @POS = charindex(@Delimiter,@String)
SET @INT = 1

WHILE (@POS <> 0)
BEGIN
	if @INT = 1 
		Begin
			SET @DD = substring(@String,1,@Pos - 1)
		End
	if @INT = 2 
		Begin
			SET  @MM = substring(@String,1,@Pos - 1)	
		End
	if @INT = 3 
		Begin
			SET @YY = substring(@String,1,@Pos - 1)	
		End	
	
	SET @STRING = substring(@String,@pos+1,len(@String))
	SET @POS = charindex(@Delimiter,@String)
	SET @INT = @int + 1
END 
SET @TEMP = @MM+'/'+ @DD + '/' + @YY

Return  convert(datetime, @TEMP)

END

KiranKumar Roy

try this one..

protected string FormatDate()
{
string strDate;
strDate = DateTime.Now.ToString("dd/MM/yyyy");
return strDate;
}

KiranKumar Roy

try this one..

protected string FormatDate()
{
string strTemp;
strTemp = DateTime.Now.ToString("dd/MM/yyyy");
return strTemp;
}

KiranKumar Roy

Try this.

protected string FormatDate()
{
string strTemp;
strTemp = DateTime.Now.ToString("MM/dd/yy").Replace("/", "_");
return strTemp;
}

KiranKumar Roy

Dear, May be you need something like below code..

protected void UpdateData()
{
int intQuantity = 0;
SqlConnection con = new SqlConnection("Your Connectionstring here");
SqlCommand cmd = new SqlCommand("update product set quantity=@Quantity where productname=@Product", con); ;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Quantity", intQuantity - 10);
cmd.Parameters.AddWithValue("@Product", "Sugar");
cmd.ExecuteNonQuery();
}

KiranKumar Roy

Hello, You can use below code to fill Combobox on your form load even.

private void Form1_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = FillDT();
this.cmbTempControl.DataSource = dt;
this.cmbTempControl.ValueMember = "ID";
this.cmbTempControl.DisplayMember = "Name";
}

    protected DataTable FillDataTable()
    {
        DataTable dtTemp = new DataTable();
        /\*Write here code to Fill your Datatable form Database \*/
        return dtTemp;
    }

Thanks

KiranKumar Roy

Go Through below link.. MSDN Protect From SQL Injection

KiranKumar Roy

Dear, You can use below function to check if Value exist in array or not..

Function CheckIfValueExistInArray(ByVal strString As String) As Boolean
    Dim animals() As String = {"lion", "turtle", "ostrich"}
    If Array.IndexOf(animals, strString) <> -1 Then
        'if exist will then retrun True
        Return True
    Else
        'if does't exist then will retrun False
        Return False
    End If
End Function

Thanks

KiranKumar Roy

so nice of you Yusuf... Thanks for your rude answer... but i will do the same and decided, not to change my field.. thanks again...

KIRANKUMAR ROY http://www.misc-story.blogspot.com

can you give me some base from where i can start. i dont have any idea.

KIRANKUMAR ROY http://www.misc-story.blogspot.com

have you visited site which i have given on my post... it will explain you all the things.... I need a site which dynamically generate image of T shirts in which i can select the t shirt color, T shirt size text on the T Shirt... Kindly visit the below site.. http://en.tailor4less.com/tailormade/shirts/configure[^] Thans for you reply..

KIRANKUMAR ROY http://www.misc-story.blogspot.com

i want to customize t shirt with asp.net. please refer blow site and please give me some idea how it is possible with the asp.net. http://en.tailor4less.com/tailormade/shirts/configure[^] Kindly Check it and give me right way to do this.. thanks in advance.

KIRANKUMAR ROY http://www.misc-story.blogspot.com