Hi, I have a table like Sno ReceiptNo CustomerId Amount Date commissionAmount AgentId 1 10 C96 5000 02/02/2009 500 A20 2 10 C96 5000 02/02/2009 300 A46 3 10 C96 5000 02/02/2009 200 A37 4 11 C50 3000 02/03/2009 300 A35 5 11 C96 2000 02/03/2009 200 A43 here one receiptid have multiple records with same customer. this table contains multiple records with the same receiptno and customer id.but i want to add distinct amount of each receipt of perticular custimer. means here customer C96 total paid amount is 5000+2000 i.e 7000. I want query for this.If any one give the answer it will be very useful for me . Thanks in advance. Haritha.

Haritha

Hi I have craeted one table in sql server 2000. The table have one one date field inserted as mm/dd/yy format.now i want to update all records date as dd/mm/yy format .how to make it.please help me.Its very urgent.

Haritha

Hi I need query to insert image directly to table field please send me the answer Thanks in advance.

Haritha

Hi i wrote the code to convert any video file to flv format as below Dim outfile As String = _mediahandler.Convert_Media(filename, _ffmpegpath, InputPath, OutputPath, "320x240", 32, 22050, True) here i am taking the converted flv file name into outfile my requirenment is how to save this file name into folder and how to execute it??? plzz send me the code plz help me its urgent for me Thanks in advance

Haritha

Hi I am using vs.net 2005 and asp.net 2.0 . In aspx design code i wrote the code as <% dim i as integer i="images/ga.jpg" %> now i dont want to provide src prpperty value directly. i have to give variable value how to give this plz help me ...... Thanks in advance

Haritha

Hi I have created one table in sql server as sno name desc 5 suma dckdfjdskfldkf;dsf 3 suma lklkjdkjfkjfdjbbbbb 8 suma jsakdksladksadks 4 manu nsdskdjsdsadl 2 manu klswkqewr 1 manu shdjsdksd like this.... now i want to dispaly one record fro each user (i.e the record which is having max sno for each user) i.e 8 suma jsakdksladksadks 4 manu nsdskdjsdsadl how to write query for this plz help me Thanks in advance

Haritha

HI How to use insert and update query in a single stored procedure if u know plz let me know too Thanks in advance

Haritha

Hi I created two tables in my database as topcs(topicid,topic,createdate,authorname) posting(postid,content,postcreatename,postdate,topicid) now i want to display all records in topics and( number of posts ,last post name, last post date) of each topic how to write query for this plz help me -- modified at 1:38 Thursday 5th July, 2007

Haritha

Hi In my database i created two tables . One table contains topicid as primary key and another table contains same field as foreign key . Now i want to count the records of each topic in second table and i have to display first table information in grid along with count of corresponding topic . how to write query for this .....plz help me Thanks in advance Haritha

Haritha

Hi In my database i created two tables . One table contains topicid as primary key and another table contains same field as foreign key . Now i want to count the records of each topic in second table and i have to display first table information in grid along with count of corresponding topic . how to write query for this .....plz help me Thanks in advance

Haritha

Hi I am using hyperlinks in one aspx page when i click that link it redirects another page with some parameters. But now i want to display that dynamic page in the same page as somepart of the page in which i had used hyperlinks. how to do this ??? Is it possible by using frames??? plz help me... Thanks in advance

Haritha

Hi I have created image controls dynamically. when i click that image control someother page should be displayed as a popup window how to do this?? my code is : ImageButton imga; Panel pana; LiteralControl LL1; private void Page_Load(object sender, System.EventArgs e) { string idvalue; idvalue= Request.QueryString["id"]; int cnt; cnt=Convert.ToInt32(Request.QueryString["count"]); Session["impath"]="audio_release/"+ idvalue +""; int cnt1; if (cnt % 3==0) { cnt1=cnt/3; } else { cnt1=((cnt/3)+1); } for (int i=1;i<=cnt1;i++) { imga = new ImageButton(); pana=new Panel(); imga.ID = "img" +i.ToString(); imga.Width=200; imga.Height=150; imga.ImageUrl="audio_release/" + idvalue + "/"+ i +".jpg"; pana.ID="pl1"+i.ToString(); LL1= new LiteralControl("
"); pana.Controls.Add(LL1); pana.Controls.Add(imga); mainpan.Controls.Add(pana); imga.Click +=new ImageClickEventHandler(Imagea_Click); } } protected void Imagea_Click ( object sender, ImageClickEventArgs e ) { ImageButton imga = ( ImageButton )sender; string s=imga.ImageUrl; popup('s'); Response.Redirect("audioimage.aspx"); } here i want to display audioimage.aspx as popup window. plz let me know if u know the ans Thanks in advance.

Haritha

In my aspx page i am displaying images as small size(thumbnails). when i click on any of the image that image should be displayed as large in the same page of another largeimage control.it is working ,but everytime when click on images total page is refreshing .I want to refresh only that image control...how to o that? I am doing this using asp.net 1.1 and visual studio.net 2003 Is it possible using these???? plz let me know. Thanks in advance.

Haritha

Hi I have created one image control and 2 link button controls dynamically and added those controls to panel. when i build the application these 3 controls are appearing side by side but i want to display one below another. my code is protected System.Web.UI.WebControls.Panel p1; ImageButton img; LinkButton links; LinkButton linkb; Label l1; private void Page_Load(object sender, System.EventArgs e) { Session["impath"]="pg/dhee"; for (int i = 1; i < 6; i++) { links=new LinkButton(); linkb=new LinkButton(); img = new ImageButton(); img.ID = "img" +i.ToString(); img.ImageUrl="pg/dhee/thumbs/"+ i +".jpg"; links.ID="ls"+i.ToString(); linkb.ID="lb"+i.ToString(); links.Text="800*600"; linkb.Text="1024*768"; l1.Text=" | "; p1.Controls.Add(img); p1.Controls.Add(links); p1.Controls.Add(l1); p1.Controls.Add(linkb); } } how to do this plz help me Thanks in advance

Haritha

how to convert the following asp code to asp.net code <% Set jpeg = Server.CreateObject("Persits.Jpeg") jpeg.Open(Request("path")) jpeg.Width=Jpeg.OriginalWidth/4 jpeg.Height=Jpeg.OriginalHeight/4 ' Send thumbnail data to client browser jpeg.SendBinary %> plz help me Thanks in advance.

Haritha

i have tried like this it is not working

Haritha

string ppath="'" + k + "'/sample/'" + m + ".jpg"; i have changed like this too but i am getting the same error

Haritha

HI In pageLoad of asp.net app i am getting the variables as string m=strPart ; (m="1" getting this) string k ; k=Convert.ToString(Session["impath"]); (k="pg/photo") now i want to take string ppath as "pg/photo/sample(this is folder name)/1.jpg" my code is string ppath=" ' + k + ' "/"sample"/" ' + m + ' ".jpg; but i am getting the erroe as operator " / " can't be applied for operands of type string and string plz help me thanks in advance Haritha

Haritha

Hi In asp.net page load i used one variable p that contains value as string p="ls2"; now i want to get the "2" from ls2 into another variable how to write code for this? plz help me thanks in advance

Haritha

Hi I created image buttons dynamicaly and i have added click event for image controls. but click event is not working code is as follows ImageButton img ; private void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) { for (int i = 1; i < 11; i++) { img = new ImageButton(); img.ID = "img" +i.ToString(); img.ImageUrl="pg/1212/"+ i +".jpg"; pl.Controls.Add(img); (pl is place holder control id) } } img.Click += new ImageClickEventHandler( img_Click ); ( while debugging showing the error in the above line as "object reference not set to instance of an object) } protected void img_Click ( object sender, ImageClickEventArgs e ) { ImageButton img = ( ImageButton )sender; Response.Write(img.ID + ""); } plz let me know whats that error how to rectify that thanks in advance

Haritha