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

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 one time,so I think if I can use combo box then user can select ID which …

Hi I think Error is in Microsoft.Office.Interop.Excel.Range column = [COLOR="Red"](Microsoft.Office.Interop.Excel.Range)workSheet.get_Range("C11", "I1");[/COLOR] If u change it into C11 then it works,just use like this (Microsoft.Office.Interop.Excel.Range)workSheet.get_Range("C11", "C11");[/COLOR]

Hi what is Error Message you got. Thanks Tank50

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 compile it in second time because its giving error massage "your Test10.Exe is already running",but there …

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 exception.so i want to create another application that check null ,how do I find …

HI Check this web site.I think it may be helpful to u. [URL="http://www.codeproject.com/KB/cpp/BackgroundWorker_Threads.aspx"]http://www.codeproject.com/KB/cpp/BackgroundWorker_Threads.aspx[/URL] Thank Tank50

HI How I generate Meassage once my array is full? Thanks Tank50

HI Iam created project in visual studio 2008,and once I compile coding,it give me error meassagee.The Error Meassage is [COLOR="Red"]Error 1 The type 'Microsoft.Office.Interop.Excel.Workbook' exists in both 'c:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.Excel\11.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll' and 'e:\Test\Test\Test\obj\Release\Interop.Microsoft.Office.Interop.Excel.dll' E:\Test\Test\Test\Test.cs 13 67 Test [/COLOR] So what I did is I delete the Excel.dll in (\obj\Release\Interop.Microsoft\Excell.Dll,but once I complie it …

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 code which I used. [CODE] xlApp = new Excel.ApplicationClass(); DataSet ds = new DataSet("DataSet"); xlWorkBook = xlApp.Workbooks.Open("C:\\Test.xls", …

What is error Messages?

HI Can I join two data tables without any database connection,Please let me know if there way to do this.Iam using C# Thanks Tank50

HI I am join two tables without any database,what iam doing is create two datatable from reading excel file and join ad "outer join",I got the coding from internet,and that artical shows how to join two table with "euqi join",So I want to know how to join two tables as …

Hi Once I wrote below coding it give error meassage.Error meassage is "Member not found".I wrote red color that show the error meassage is occur. [CODE] Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.Application(); Excel.Workbook xlWorkBook = (Excel.Workbook)xl.Workbooks.Open("D:\\Test\\VOIP_X.xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); [COLOR="red"] …

HI I want to read Excel file from C#,below I menation the coding I use, I add Microsoft Excel 12.0 object library ,but Once I complie the coding it gave me error Meassage.The Error Meassage is 1."Type of Namespace for Application class Doesnt exsits" 2.Excel.Application.Workbook(object) is a method,which not given …

Hi I wrote below coding ,and last Message "Test" never appear in my project ,it means while loop never works.Plase tell me what is problem in my coding [CODE] public partial class Form1 : Form { public static int Number_Records; public static DataSet ds; public static DataTable dt; public static …

Hi guys I have a problem in my project.Below I mention the coding I wrote it for testing purpose. In below coding the second while loop never run,only [CODE] SqlDataReader reader = DbCon.Get_Invoices(); int x = 0; while (reader.Read()) { x++; [B][COLOR="Red"] 1[/COLOR][/B] } MessageBox.Show(x.ToString()); chart2.DataBindCrossTable(reader, "ExecutiveCode", "Date1", "Total", ""); …

Hi Once I complie below coding part,it give me error meassage.The Error Meassage is Error . [COLOR="Red"]The name 'CurrentOutLet' does not exist in the current context[/COLOR] BelowI write my coding [CODE]. public SqlDataReader Current_outletReport(string code, string startdate, string enddate) { try { SqlDataReader CurrentOutLet; SqlConnection con; string str = "SELECT …

HI Iam using MSChart for one of my project ,and in Microsoft site it mention that MSChart only support for visual Studio 2008 and Dotnet framework 3.5 SP1,SO i f I create Exe for that project then if I install it another compurter then is there DOTNET framwork 3.5 install? …

HI I installed Visual Studio 2008,but I only installed C#.I want to create new database connection,so what I did is in Database connection->Add connection->select Data source But MS Sql server compact 3.5 and MS sql server database File are avaliable in here I cant find the sql native client,only MS …

Hi I have dropdown list in my asp.net page.I wrote a below coing coidng in the `SelectedIndexChanged`, protected void cmb_Se_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con=new SqlConnection("Data Source=20.1.2.58;Initial Catalog=Customer;User ID=test123"); string str = "select ExecutiveName from Executive where TeCode='"+cmb_Te.Text+"'"; con.Open(); SqlCommand command=new SqlCommand(str,con); SqlDataAdapter adpter=new SqlDataAdapter(command); DataSet data=new DataSet(); adpter.Fill(data); …