Arjun_Sarankulu

I have GridView which contain four columns(PAN No. , Member ID, Client ID and Client Name) In the Edit Mode it shows all the value in TextBox On the change of Pan No., It should Populate the new data in TextBox of Member ID, Client ID and Client Name . …

I have created a application which connection to sql server database as well as oracle database The application is working fine at my end And to connect to oracle i used following namespace using Oracle.DataAccess; using Oracle.DataAccess.Client; But when i run the application on user end It gives following exception …

In our Company i have developed the application which starts the Outlook and emails to all clients. As it is manual process to send the same, sometime user might forget to run the application. To avoid the same we have planned to run the Application using Task Scheduler from Window …

I have created login application using spring in my local machine using Apache + Eclipse. I exported WAR of the same without setting the target server as i am deploying the same on sun web server. Application successfully deployed on sun web server. Successfully opens welcome page when click on …

I have done RND on Spring Application development on Apache Server at home which works fine. Now we are about to start the development of web application using Spring in my company. Is Spring deployment is feasable with **sun java system web server** And which tool to prefer for development …

I have developed a web appication for Hospital which manages Patient Information. When the web application is simultaneously opened on more than one machine. While filling data on one machine it redirect to next page which autogenerates SID. but when user at the same time try to fill data from …

For Security Concern, I am using mssql_execute(). I am not getting way to get the recordset return from procedure. Below is my sample code $query = mssql_init("USP_GET_ICIN_DATA",$mssql_link); mssql_bind($query, '@ICIN_NUMBERS',trim($icin_data), SQLVARCHAR, false); mssql_bind($query, '@FROMRECORDNUMBER', $start, SQLINT4, false); mssql_bind($query, '@LIMIT', $limit, SQLINT4, false); $result = mssql_execute($query); while ($row = mssql_fetch_assoc($result)) { $icin …

I have String. Var Str = "INC300051546,INC300051553,INC300051561,INC300051579" I want to check there should not be seperator other than comma in the string. And Comma Seperated String should contain INC as 1st three character and after that 9 digits followed by comma. Is there any regular expression to validate the string.

I have a crontab job in which data from csv file get insert into mysql table at regular interval. Now i want the same table data to be inserted in ms sqlserver database. I know i can write code again to take data from csv to ms sqlserver database. But …

I am developing Window Application in C#. In which i need to Send email using Outlook And to read the unread mails from Outlook and to get the undelivered mails from Outlook. I am able to send and read the unread mails from Outlook. But not able to read the …

In C# i need to read the Excel File using Interop. I am using : **using Excel = Microsoft.Office.Interop.Excel;** And i am able to read data from Excel File. Problem is in my Sample Excel File there are only 6 rows and it also reading more than six rows. It …

I have a csv upload utility for my company. When user run the application in the drop down user get the table name in which insert the data (data from file browse) when table column type is date it gives error "source type of string cannot be cannot to destination …

I have created Following Function which takes 2 parameter [CODE] CREATE OR REPLACE FUNCTION Inst_Param_Desc(constant_Val IN varchar2(2), display_name1 IN varchar2(40)) RETURN VARCHAR2 IS Front_Display_Name VARCHAR2(40); Enum_Id number(4,0); BEGIN select b.enumeration_id into Enum_Id from xyz b where b.display_name = display_name1; SELECT a.front_end_display_name INTO Front_Display_Name from abc a where a.enumeration_id = Enum_Id …

I have html page(Main_Frame.html) which contain two frames. 1)abc.php 2)xyz.php How can i auto refresh abc.php without refreshing the whole.

I have developed the html Frame. Which contain two php pages First show the data in the table which is comming from database and refresh after 30sec and click on the tr it shows the data in the second frame as in graph(candle chart). Everything is working fine. But Problem …

I was succesful in reading csv file and writing to txt file But am facing problem while writing to database. Can any one help me for the same Thanks for your support

I have main page as contain the frameset In that there are three frame 1)html page as 1.html 2)which shows the chart data as chartdata.php 3)the combox box with submit button click.php I want the combox box selected value in chartdata.php Can anyone say how can i achieve the same. …

I have developed the Server client application(TCP) which works fine. I need to start the server and the client do request and get the desired ouput. I want the server application to run on client machine some what like windows service(when the system boots the services starts). Can anyone suggest …

i have two column in table select Col1 + ' ' + Col2 from test It gives output as Arun Kumar But i want output as Arun Kumar Can anyone help me out

create table test2 (Roll_ID int ) insert into test2 values(1) insert into test2 values(2) insert into test2 values(3) insert into test2 values(4) insert into test2 values(5) i want output as RollId

Procedure is created on SQL server inserting the data from sql server to oracle databse When individually run the query it executed in 10 sec When run through procedure it takes sometime 1.5min and 5min [CODE] CREATE procedure sp_Trade_Book as Begin SET NOCOUNT ON BEGIN TRY --Begin of TRY BLOCK …

I m running the Sql job as background thread and at the same time showing data from sysjobhistory table in gridview. While debugging the code its shows the data in old and new rows affected from table in gridview but when i put the application in debug or release mode …

I have data in the column '4.00504572690003' when i use select round(4.00504572690003, 2) it gives 4.01000000000000 How can i achieve 4.00 from the same. I tried a lot but didint get.

Have you install the .Net Framework on the machine you are runing your application and check all the connection you have open you puttin in try block and handled catch and finally block and accroding to me close the connection in finally block. If you get your Answer mark this …

I have the application In which i am ruuning the procedure which runs the Sql Job and at the other end i need to show the job history in grid whose query is [B]select job_id, step_id, step_name, message, run_date from sysjobhistory where run_date = replace(convert(varchar(10), getdate(), 121),'-','')[/B] the job which …

I am developing the tcp client and tcp server application Client is connected to server But on server said i am getting following exception [B]unable to read data from transport connection[/B]. I am working on network programming first time. I googled it a lot but didnt get. Can anyone Escape …

hi debasis do you any idea about Gridview insert update and delete using Ajax if you dont mind i know normal insert update delete

Update spot_price set location = ‘PATAN’ where symbol = ‘CASTORP’ and polling_date between ‘20110730’ and ‘20110806’ Giving sql syntax error. Same query i am using to update another table in sqlserver its working but not in mysql

I am new to Asp.net How can i do insert, update , delete on gridview using Ajax I have search a lot but didnt find

I have a table customer in ms sql and i have same table in Oracle. I want to insert data from ms sql to Oracle. I am not getting the solution.

[CODE]insert into mst_report_dtls(report_name,url_path,login_id,pwd,domain,amd_date,amd_user_id) values ('Contractwise_statistics','http://192.168.22.11/ReportServer?/TradingReport/Contractwise_statistics','dbadmin','1nPrPgqv5UIpU4SYnGddJw==','ace',getdate(),1) [/CODE] Above statement i used to run from backend. Now i have developed a front end While running the code it gives me SQL Exception Following is my code [CODE] namespace Ace_System_test { public partial class Admin_CRMReport : Form { SqlConnection connstr = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["database"]); …

I have commented the dll reference in the config file still it give error couldnot load file or assembly I am not getting where i am going wrong

I have Following Procedure [CODE] alter PROCEDURE GET_REQUEST_FOR_LEAVE_N_ATTENDANCE @ENAME VARCHAR(100), @FR_DT DATETIME, @TO_DT DATETIME AS BEGIN SET NOCOUNT ON SELECT B.CEMPLOYEE_NAME,A.* FROM TRN_EMPLOYEE_ATTENDANCE_REQUEST A INNER JOIN MST_EMPLOYEE B ON A.EMPLOYEE_ID = B.EMPLOYEE_ID WHERE B.CEMPLOYEE_NAME LIKE '%' + @ENAME + '%' AND ABSENT_DATE BETWEEN @FR_DT AND @TO_DT SELECT B.CEMPLOYEE_NAME,A.* FROM TRN_LEAVE_REQUEST …

I am storing date from datetimepickercontrol in variable using [CODE] string s = ""; s = dateTimePicker1.Value.ToShortDateString(); [/CODE] Output = 7/13/2011 But i want 2011/7/13 How can i achieve the same

I am developing desktop application in there are two textbox(From date and to date) I want when click on textbox MonthCalendar Control to appear and selected date to be appear in textbox. I googled a lot but i am not getting

I have an application in which user will put the query in text box and will get the output in gridview and i need to keep track that which user has run which query. for that i will be taking query from textbox and store in one variable I need …

I have develop an application in which i am taking the data from one table which contain only 1 column which contain the table name. Motive of the application is if this table contain 2 records(fetch 2 table name) then i have to fetch the records from these table then …

I am installing the application on user end And when i run the exe Its gives the following exception [B].Net Framework Initialisation Error[/B] To run this application you must first install one of the folloeing version of the .net framework But i have install few application previously and it was …

I have application which contain textbox, 2 button and datagridview In text box user will enter query button1 click to display query result in gridview and Button2 to export data to excel My application is working fine But problem is when i again click button1 it also show the previous …

I have a application contain 1 text book for Multiple line 2 Button(Query and Export) and 1 DataGrid View If user enter the query in textbox and click on Query Button i want to prompt for use input to get key for validating purpose My application is working fine But …

I am using windows username and password to authenticate user for login following is my code [CODE] namespace Test1 { public partial class Login_Form : Form { string emp_code = ""; public static string temp_emp_code = ""; string s = WindowsIdentity.GetCurrent().Name.ToString(); private string _path; private string _filterAttribute; public Login_Form(string path) …

I am not getting a proper help regarding this . I have search on google Can any one suggest something for the same

I have a application which take data from CSV and dump to the respective table using SQLBULKCOPY I am using the same connection string for truncating data from the same table and while writing to server SqlBulkCopy bc = new SqlBulkCopy(connection_string1.ConnectionString, SqlBulkCopyOptions.TableLock); bc.WriteToServer(dt);//Its giving exception on this line I am …

Can i insert data from mssqlserver to oracle using select statement

I have an application which use SqlBulkCopy to copy data from csv to respective table in SQlserver which works fine but the same i have to do to dump to oracle which cant be done by sqlbulkcopy class Is there any similar way to dump into Oracle table

How to Connect oracle database using C#.

I have varchar value 4890 And i am casting it to decimal and dividing by 100000 Its output is 0.0489000 But when i calculated the same on calculator it gives 0.04890 And i think it should be 0.04890 Please help me out Thanking in Advance

I am new to SSRS, I need to to know basic concept of SSRS in PPT. Kindly help in this. Thanking in advance

To check file present in FTP server everytime file is kept if yes then send automatic mail to be send to the respective user

I have a application in which i am taking the csv file and dumping to data base in the respective table. Problem is if column data does not match Then it gives the following error [B]Column in the source data doesnot match with destination columns[/B] For this i am handling, …