Hi

I need a help in SQL,There is table called sales.Its contains the day,sales quantity.If I write sql like below

select day,Sales_quantity from Sales.

Then result should be
Day ...

Hi
Thanks for qucij reply.It works sknake.I need another help.I want to add sql statement like this
Select FriutID from Friut where friutName like' App%' or friuteName like 'or%' or etc...

Hi

I developed report using sql server reporting service.I used parameter to assign value for sql query.I want to use "LIKE" keyword in using parameter,How i do that?i wrote coding below what u...

Hi

I developing application using C#,and user name and password save in database.Only few users can access to certain forms and admin can access to all forms.How do I do this?

Thanks
Tank50

[/QUOTE]

I using Visual studio 2008 to connect to SQL server 2000,while I run the application there is exception,but sometime there is no exception is generating.Below I mention the exception.

Exception...

Hi

No iam using Winodws Xp I dont what is service pack,I think it may be service pack3,but sql server 2000 install in windows server 2003.And  anti virus is Kaspersky Anti-Virus 6.0

Thanks...

Hi

In my Project I used to connect to sql server2000,which is not in local computer.I use visual studio 2005 to develop the windows application.Once I run the apllication it gave me error message...

Hi

I already Install the MS Sql server 2005 into my machine,but I want to install the Sql server 2008 into my machine.I want to install the sql server into "D:" Drive, because of few space...

Hi

I am not good at thread.is there another way to do this.

Tank50

Hi

I Create service using C#.I use the coding part of test to create servicee.Once I start the service it gave me message saying

"Myservice on local computer started and then stoped.Some...

HI

yes.I need While loop.I didnt use that coz In my datareader only one record avaliable ,So I thought no need of while loop.Now I fix it.

Thanks
Tank50

Hi

I got a error message once ,I read datareader.The error message is"Invalid attempt to read when no data is present".
Previously I go this error,coz I missed the sqldatareader.Read()...

Hi

Thanks guys.I was in greate trouble coz of this error meassage.Now it ok ,I miss datareader.Read() part.

:)
Tank50

Hi

I want to read the content in datareader.So I use below coding to do that
if (dataReader4.IsDBNull(0)){

}
but I run above coding it gave me an error meassage.The error Meassage is ...

Hi

I really want how to do that kind of application.Thanks Mick.

Hi

I Want to develop the application ,that use for get how much data I download from the internet.Please give me idea.

Thanks
Tank50

Hi

Thank you Ramy,It works.:)

Hi

Thanks Ramy,but yes I have to use it as a parameter,but there is distinct ID like 1,2,10,20,etc ,So i want to select the several Id at one time,like "1","2","10".So cant I create combo box?...

Hi

I think this link will help

http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/b6e8a28c-6760-4e86-a1aa-e2ce9ec36380

Thanks
Tank50

Hi

I use the reporting services to generate the report.I use query like
"Select Distinct(ID) from Table1".In that query Its generate the number of ID ,So In report user able to several "ID" at...

Hi

I think Error is in Microsoft.Office.Interop.Excel.Range column = (Microsoft.Office.Interop.Excel.Range)workSheet.get_Range("C11", "I1");

If u change it into C11 then it works,just use like...

Hi

what is Error Message you got.

Thanks
Tank50

Hi

I did what adatapost is saying ,now it working properly.

Thanks
Tank50

Hi

Thanks adatapost for quick reply.I will try that.

Tank50

Hi

Here is coding.Column and SheetFormat are class.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;

Hi

I created C# project ,but there is problem,the problem is if I click on close button in right side upper corner in windows application while program is running ,then it's close,but I cant...

HI

Thanks serkan.I got the way how to do that,here is coding

Excel.Range cell1 = (Excel.Range)xlWorkSheet .get_Range("A20", "A20");

if(cell1.Value2==null){
...

HI

Check this web site.I think it may be helpful to u.

http://www.codeproject.com/KB/cpp/BackgroundWorker_Threads.aspx

Thank
Tank50

Hi

I use C# to read excel file.So user has to enter path of the excel file into application.However problem is, if there is null value in excel sheet for particular column then it generate the...

Hi
Ancient Dragon delete my original post,Anyway I have to write my question here again.

I have List and I used save employee objects into list,first user has to select how many employee objects...

HI
Thanks adatapost for ur reply.By mistake I post this question two time.Please refer to second one.

Thanks
Tank50

HI

How I generate Meassage once my array is full?

Thanks
Tank50

Hi

I want to create text box array at desing time.It means i want to create text box like Text box1[1],TextBox[2],TextBox[3].How do u create it in desing time in C#.

Thanks
Tank50

Hi

yes your right,I removed it from reference ,now its working

Thanks
Tank50

HI
Iam created project in visual studio 2008,and once I compile coding,it give me error meassagee.The Error Meassage is

Error 1 The type 'Microsoft.Office.Interop.Excel.Workbook' exists in both...

Hi
Thanks for reply.now it ok I got the coding that realase unwanted variables from memeory

if (xlWorkBook != null)
{

...

What is error Messages?

Hi

Nowdays Iam developing application that use for read excel .So Once I run and close the application there are more than 5 excel.exe process are running.How to stop these process.Below I mention...

Hi

I did what is adatapost is mentioned but problem its equi join,I want to join it as outer join ,coz if thre is no match record in dt1 table for dt2.Columns[0] then it give me exception.I want...