No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
programmer
34 Posted Topics
Hi everyone, I have database which has data of past 2 years. I want to get that data for current financial year. [COLOR="Green"](Here financial year is 1st april to 31st of March)[/COLOR] This query returns data for current calender year i.e. [Jan-to-Dec] [COde=sql] SELECT DATENAME(MONTH, DATE) AS MonthName, SUM(NetAMOUNT) AS … | |
Hi folks, I have an ASP page. I have a label and button on that page. label shows data from database. lets say i have 100 rows in database Now when I run my page i want to see first row data on my page label... and when user click … | |
I have a silverlight application with one report. It builds and runs fine in visual studio 2013. I deployed that web application on my localhost and it is throwing "The remote server returned an error : NotFound" error. I tried following things...none of them worked out - Build x86 and … | |
Hello All, I have a web application with master page. master page has accordian (vertical) menu with favorites section where user can drag menu items dynamically. user has to press 'save' button to save these newly dragged items. My problem is after pressing 'save' button, these control's do not render … | |
Hi Folks, I am new to java programming. I have an xml file <File> <XMLFile> <Type = "TypesFirst"> <myI>17</myInt> <myS>Type one</myS> <myD>3.14</myD> <myL>1212121</myL> <myC>D</myC> </Type> </XMLFile> <XMLFile> <Type = "TypesSecond"> <myI>17</myInt> <myS>Type two</myS> <myF>7.14</myF> <myL>121456</myL> <myC>D</myC> </Type> </XMLFile> </File> So I have to deserialize this file in such a way … | |
Hi, I am new to oracle. I have this following query : SELECT TYP_CD, SUM( INVC_AMT), trunc(ALLOC_RUN_DT) as "Alloc_Date", MIN(ALLOC_RUN_DT) as "Minimum_Time", MAX(ALLOC_RUN_DT) as "Maximum_Time" FROM allocation_header group by TYP_CD, ALLOC_RUN_DT order by TYP_CD, "Alloc_Date" and the sample output I get is : TYP_CD INVC_AMT ALLOC_RUN_DT Minimum_Time Maximum_Time 01 20520232.31 … ![]() | |
Hi all, I have some data in the file, which I want to store in the following format : 23 345 9.8 25 457 9.0 11 237 8.3 86 32 2.3 and so on..... I want to store this data in in some data structure, and later I want to … | |
Hi All, I have a binary search tree (consider following structure). struct bst { void *value; struct bst *left, *right; }; I want to save this unbalanced binary search tree in a file. And when I read this file, I don't want to recreate the tree from these nodes. So … | |
Hi guys I am writing an application in c# I want to create a dynamic log file which would contain all the errors or exceptions occurred during execution of the Component. Log file simply has to append all the errors or exceptions generated with error details and time and date. … | |
Hi everyone, I have Javascript function (say hello()) in page (abc.aspx) I want to call this function from (abc.aspx.cs) In .cs file I have a function say fun1() { - -- if (var==1) call javascript function here } how can I call javascript function from IF condition?? I dont want … | |
Hi folks, I had mysql database with English+Chinese data in it...I had to migrate that database from mysql to MSSQL 2005. Now I cant view any chinese character..It shows '?' symbol in place of chinese characters. How can I set the collation in MSSQL that I can view chinese data … | |
Hi folks, I have a web page...which has a drop down box. whichever value is selected from that drop down certain number of labels and text boxes have to be created accordingly. [Actually database drives this...] Can anyone tell me, how can I achieve this ???? One more thing...I wanna … | |
Hi Folks, I have a test.aspx page, which creates dynamic text boxes according to some condition, in following way.... TextBox t1; //Declared at class level button_click(...) { .. . . while(someCondotion) { t1 = new TextBox(); t1.ID = "TextBox" + count; ProductPanel.Controls.Add(t1); } . . } //button click ends now … | |
HI folks, I have a page..on top of it there are few textboxes, dropdown and 2 buttons. whenever I click search buttons A grid is displayed on screen with data in it.... But this grid disturbs whole alignment of my textboxes and buttons which are at the TOP of the … | |
Hi folks, [COLOR="Green"] I have a MySql table...which has 4 columns say sid pid tid data 1 abc 2 def 3 ghi 4 jkl - - 10 xyz 1 dfsf 2 sdfs [/COLOR] I want to convert column name 'data' into multiple rows i.e. 1 2 3 4 5 --- … | |
Hi everyone, I have been writing a .dll in C#.net I have to write a function in that which would create a small window, accepting uname and pwd. Is there any provision in Components(.dll's) to create a small UI. which would be used by external applicaton. I mean I am … | |
Hi everyone, I get a string in XML format from front end. I write that into a file, and later I parse that file to get tokens/values. is there any way..that I can parse the string Instead?? which is in XMl format and fetch the tokens there. Coz writing on … | |
hi folks, I have a big C# component, which has reference to many other .dll's. I am facing a strange kind of problem when I compile my code or in between all folders in my /bin/debug directory get deleted automatically. So I get an error saying reference not found for … | |
Hi folks, I need ur help, view the following code snippet public xxxx func1() { -- -- return xx; } This is a sample function in C#. which may return string/Datetime/Datatable. Is there any way by which same function return different data types at different times. please reply asap. | |
hi everyone I have a website which was deployed by some one a year back...now I have to make some changes to it. So I downloaded entire source code of that website and opened it on local machine asp.net But it is read only..I can't drag and drop controls on … | |
hi everyone, is there any way that I can programatically tell the user weather he/she is successfully connected to the database(SQL Server 2005). or connection failed. Code is written in C#. [code] string Connectionstring = "...."; sqlConnection con = new sqlConnection(Conncetionstring); con.Open(); [/code] how I can check programatically weather con.Open() … | |
Hi everyone...([COLOR="Green"]read carefully[/COLOR]) I am Developing an application in C#. In which First I create two text files say a.text and b.text. and then fetch data from them ...... Now every day when I run my code for the first time I want to delete these files and recreate new … | |
Hi everyone, I have a query as - [COLOR="Red"]select DateName(Month,Date), avg(NetAmount) as AverageCustomerBill from salesmaster group by DateName(Month,Date)[/COLOR] which gives result as follow - [COLOR="Green"]April 451.5664 August 432.6227 July 441.1437 June 429.9915 May 423.7198 November 407.4123 October 425.1684 September 416.3678[/COLOR] As u can see here Months are not in proper … | |
Hi Everyone, I have a query as - [COLOR="Red"]select top 10 bm.name, sum(sd.Amount) as bd from brandmaster bm join lobattributevalue lob on bm.brandid = lob.valueid and bm.lobid = lob.lobid join salesdetail sd on sd.productid = lob.productid where lob.attributeid = 3 group by bm.name order by bd desc[/COLOR] Now In this … | |
Hi I am Rohit.. I want to design a website in asp.net. I am just university passout. I was thinking to buy VISUAL WEB DEVLOPMENT TOOL 2008. Can somebody tell me whats the price of it ? and weather they provide any special discounts to individuals or students or beginners. | |
Hi everyone I am executing a query on sqlreader object i.e. rdr = cmd.executereader(); now I get a value rdr[0] = 100; but this value is in reader object. I want to transfer that value rdr[0] to integer variable how can I do that? I tried int.parse, int.tryparse, convert.int32..etc it … | |
Re: As all living organisms have evolved from single cell. The age of earth has to be billion years old. As scientist says 4.5 billion. | |
Whenever we implement any Interface in C# or JAVA why is this compulsory to implement all the methods insight that Interface? | |
I have a huge database which contains certain categories of products and their sales figures. I want to find CATEGORYWISE sale per Month. I have written a query for that. but I had to write 12 queries for 12 months. This is a sample Query for Month April I am … | |
Re: 1] In SQL server use SQL server authentication mode and set your own username and password. 2] In C# u provide connection string to the database of the following form. [COLOR="Red"]Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;[/COLOR] 3] now here instead of giving hardcoded values of uid and password set some variables and … | |
What is the best way to parse the string in C# In java u have a class like Scanner. Is there any equivalent class in c#. | |
Re: [QUOTE=JayOne;1093850]Ok, at university we did a lot of Java. And I can remember the tutor saying "Exceptions are great for debugging applications, but shouldn't be used in deployed applications for error handling". Now I'm kinda confused, because I feel they provide a lot of flexibility in handling errors. So why … | |
The End.