Tank50

Hi I used below coding for create a excel sheet.I got from on web site. In below coding there is no problem.Its create the excel file.If i run second time,its ask to overwrite the current excel file.If I said "Yes" then it ok ,but If I select cancel button,its generate …

Hi Guys I want to crete the SQL Tigger.There is table called Fruits.In fruits table it contain ITEM_CODE,ITEM_NAME and PRICE.So there is application that used to insert the values into fruits table. So I want once ITEM_Name or ITEM_CODE is update then sql trigger execute and It insert the update …

HI Guys These days I am checking whether amount is correctly upload into one of our table its located in oracle database below query used to check this . Select * from Amount_Paiad where CusID IN ('34343','34343','090094') There is no issue in query.Problem is how many values I can enter …

Hi In my office there is an application ,and database is Sql server 2000.Using ODBC connection application connect to database.Recently database move into sql server 2005.Now application is not working,Its generate error message error message is "Connection failed".I tested the ODBC connection its okay. *I dont know what is language …

Hi In my compnay we use web based application and backend as sqlserver 2005.recently this backend is move into another new server.I restore database backup in new server.Issue is after 4 days I saw transaction logs file size is more that 16GB in new server .In old server transaction log …

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 I want to create new sql account in sql server 2005,and user only able view sql agent job history details only.How do I do this.Please help. Thanks Tank50

Hi I am developing windows application using C#.There is combo box in the windows application ,once user select value it automatically generate pop window.I want to appear the new window at the right side lower corner in combo box.I tused below coding ,but it never works,please let me know how …

Hi Guys I have an application that developed using ASP.net.There is cancel option,user can select number of item code and cancel it,but there is isssue.The issue is once user select more than 200 item code to cancel then it generate the error messsage.Error message is "Time Expird or server is …

Hi guys I want to join two tables and executive the sql statement.I mention what is code i wrote ,Once Complie the code it says Error1 The left-hand side of an assignment must be a variable, property or indexer [CODE]SqlConnection Con3 = new SqlConnection("Data Source=IT;Initial Catalog=Test;Integrated Security=True"); Con3.Open(); string str1 …

Hi I created the web project using Asp.net.In that web site It read from database and show result in data grid.There is save button using that I can save it into excel file.the problem if I selected data with one month(20010-01-01 to 2010-01-31) ,then there are more data,but in data …

Hi There is application that created from C# or vb.net not sure about that.In application I can generate the report ,and its crystal reports.My default printer is network printer.I want to generate the report in custom page.In network printer custom page is selected as default page.Once Problem is I have …

Hi I create web site using asp.net,It publish in windows server 2003.when I type URL in internet explore its sows all the aspnet file(.aspx) file,after that I click on default.aspx file,but it wont works,its generate "page cannot found".I tried it in my local machine and server machine,but its that didn't …

Hi I am using C# to connect to mysql database that install in my local machine.After I complete the project I want to publish it in another server.So I change the mysql connection string.Here I mention the connection string that I used in local machine String MyConString = "SERVER=localhost;"+"DATABASE=IPG;"+"UID=root;"+"PASSWORD=Test;"; Before …

Hi I Create the tigger when update process happen in database.When the after update process happened ,tigger instert the new record into another table about that table locate in different server.I create linked server also ,once tigger execute it generate the Error message .Below I mention the error Message I …

HI I use Reporting Service to generate the report and it generate report in aspx extention.I think its an ASP.Net page. Anyway Problem is once I log into those reports from server which I host these pages,Its works fine,but onceI log into those reports from another computer then its takes …

I am using Below SQL commands at Crystal Report as command [CODE]SELECT count(id) FROM Content WHERE CONVERT(varchar(10),ImportDate,101) between '{?Para1}' and '{?Para2}'[/CODE] but its generate message value as '0',But When I run in sql server it give result as 23454.Please Help me Sort this problem Thanks Tank50

Hi I want to write asp.net page with crystal reports.I pass parameter to reports.Once I press submit button its ask database user name and password.How I stop asking user name and password in every time. Thanks Tank50

HI I wrote below coding part,but its generate the exception.Below I mention the code and error Error [COLOR="red"]Data type mismatch in criteria expression.[/COLOR] [CODE] DataSet Serach_sumbitdata=new DataSet(); OleDbConnection conn7 = this.getconnection(); conn7.Open(); string str = "Select * from Customer where SubmitDate between '" + str1 + " 12:00:00 AM'" + …

I use SQL Server 2005 and I create function.Below I mention the Function that I created. [CODE] CREATE FUNCTION dbo.udf_GetCountryID(@Name varchar(50)) RETURNS VARCHAR(1000) AS BEGIN Declare @Description varchar(4000) select @Description = coalesce(@Description + ',' , '' ) + countryCode FROM dbo.Test_Table where CommonName='Japan' Return @Description END[/CODE] After creating function I …

Hi I need a help in SQL,There is table called sales.Its contains the day,sales quantity.If I write sql like below [CODE]select day,Sales_quantity from Sales.[/CODE] Then result should be Day SalesQuantity Monday 20 Monday 302 Monday 50 Tuseday 30 etc.. The problem is I want to get result like below Day …

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 wrote before.I used @con as parameter. [COde=sql]Select FriutID from Friut where friutName like'@con'%.[/COde] Once I write above …

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

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. [COLOR="Red"]Exception Error at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, …

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 ,below I mention the error meassage I got [COLOR="red"] A network-related or instance-specific error occurred while …

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 available in "C:" drive. 1)Can I install sql server 2008 into "D:" drive? 2)If …

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 services stop automaticaly if they have no work to do,for example ,the performance logs and alerts service" below …

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() method.once I put the datareader.Read method still I got the same error. String str_string1="select ID,renew,reminder,heading from dbo.StockModifications"; ContractID_Reader2 = db.getdatareader(str_string1); …

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 "Invalid attempt to read when no data is present". then I use below coding dataReader4["Email"]==null but It …

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