|
In my scenario, I need to group the products based on category. The "main" header has columns Product name, Description, Unit and Unitprice. I am programatically adding "secondary" / "sub" header for each cateogry and list the respective product underneath.
I overrode the render function like this
GridViewRow NewHeader = new GridViewRow(rowIndex + 1, rowIndex + 1, DataControlRowType.Header, DataControlRowState.Normal);
GridView1.Controls[0].Rows.AddAt(rowIndex + 1, NewHeader);
The gridview is created as wished - First appears the main header. And Comes the first sub header followed by the related product rows and then comes the next subheader followed by the corresponding product rows at it goes on.
I want to know how can I access these dynamically created "sub header"s. Gridview1.rows collection has only the data rows and the Gridview1.headerrow has only the default headerr row. Is there a way to access my "sub"header rows?
Thanks
Kit
|
|
|
|
|
sallam 2 all
this is a search query bt i got an exception at column S_No
i.e
Select ROW_NUMBER() OVER(ORDER BY pcpd.Cpt_Code, pcpd.Cpt_Description ASC) AS 'S_No', Provider_Cpt_Plan_Detail_Id, Provider_Cpt_Plan_Id, pcpd.Cpt_Code, isnull(pc.Proc_Description,'') as cpt_description, pcpd.Cpt_Modifier, Non_Facility_Participating_Fee, Non_Facility_Non_Participating_Fee, Facility_Participating_Fee, Facility_Non_Participating_Fee, pcpd.Deleted, pcpd.Created_By, pcpd.Created_Date, pcpd.Modified_By, pcpd.Modified_Date From Provider_Cpt_Plan_Details pcpd left outer join procedures pc on pcpd.Cpt_Code=pc.proc_code Where ORDER BY( pcpd.Cpt_Code, pcpd.Cpt_Description ASC) LIKE '4%' And pcpd.Cpt_Code LIKE '00%' And pcpd.Provider_Cpt_Plan_Id ='100ALLALLALLALLALL' And pcpd.Deleted ='0'
the prob is that i use
Select ROW_NUMBER() OVER(ORDER BY pcpd.Cpt_Code, pcpd.Cpt_Description ASC) AS 'S_No' in select statement im confused what i give in search where clause if i give S_No it gives me error if i give the whole ROW_NUMBER...etc etc it says it is used only in select statement
now it gives me exception Incorrect syntax near the keyword 'ORDER'.
when i used ORDER BY( pcpd.Cpt_Code, pcpd.Cpt_Description ASC) LIKE '4%'
any suggestions what i should do?
|
|
|
|
|
Its better if you post your question in databse section.
|
|
|
|
|
hi iam using asp.net with c#
iam saving two images in database but while retreving only one image is displaying
saving code
==========
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile && FileUpload2.HasFile)
{
img1.ImageUrl = imgc.ImageUrl;
img2.ImageUrl = imgo.ImageUrl;
FileUpload1.SaveAs(MapPath("~/images/" + FileUpload1.FileName));
imgc.ImageUrl = "~/images/" + FileUpload1.FileName;
FileUpload2.SaveAs(MapPath("~/images/" + FileUpload2.FileName));
imgo.ImageUrl = "~/images/" + FileUpload2.FileName;
con.Open();
SqlCommand cmd = new SqlCommand("Addimgproc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Shop", "Alsafa");
FileInfo imageinfo = new FileInfo(FileUpload1.PostedFile.FileName.Trim());
byte[] content = new byte[imageinfo.Length];
FileStream imagestream = imageinfo.OpenRead();
imagestream.Read(content, 0, content.Length);
imagestream.Close();
FileInfo imageinfo1 = new FileInfo(FileUpload2.PostedFile.FileName.Trim());
byte[] content1 = new byte[imageinfo1.Length];
FileStream imagestream1 = imageinfo1.OpenRead();
imagestream1.Read(content1, 0, content1.Length);
imagestream1.Close();
cmd.Parameters.AddWithValue("@imgc", content);
cmd.Parameters.AddWithValue("@imgo", content1);
cmd.ExecuteNonQuery();
con.Close();
}
}
retreving code
================
protected void Page_Load(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("select imgc,imgo from images where Shop='Alsafa'", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Response.ContentType = "image/gif";
Response.BinaryWrite((byte[])dr["imgc"]);
Response.BinaryWrite((byte[])dr["imgo"]);
}
}
i want to display both the images from data base side by side but it is displaying only one image
|
|
|
|
|
See Images are calls from img tag to the server. So for each img tag it will receive one Request. You might write the Image bytes directly on the Response stream using Response.BinaryWrite.
So I think you either need to write the images to some location accessible from outside and set the url to the img tags Or you create one HttpHandler for images, and access the individual images from the client and write each image individually to the response.
Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution. Visit My Website-->www.abhisheksur.com
|
|
|
|
|
Please put a break point inside While statement and check what goes wrong. What is the record count ?
Cheers !
Abhijit Jana | MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Hi all..
I have grid view row commad propery
I can get current index using the follwing
object o = e.CommandArgument;
Int32 rowindex = Convert.ToInt32(o);
but i want to read data from cell
int orgId =Convert.ToInt32(gridClientBasePlan.Rows[rowindex].Cells[0].Text);
This is giving exception how to solve this
|
|
|
|
|
|
I am developing an e-commerce site, as part of my academic project. I want to integrate the Paypal. I am not familiar with it. Can we see and learn about transactions without having money in accounts? I want to simulate the transactions. Is there any option for that??
|
|
|
|
|
|
I have a few web applications that I maintain and I find myself very often writing the same block of code over and over again to bind a GridView to a data source. I'm trying to create a Generic method to handle data binding but I'm having trouble getting it to work with Repeaters and DataLists.
Here is the Generic method I have so far:
public void BindControl<T>(T control, SqlCommand sql) where T : System.Web.UI.WebControls.BaseDataBoundControl
{
cmd = sql;
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
control.DataSource = dr;
control.DataBind();
}
dr.Close();
cn.Close();
}
That way I can just define my CommandText then make a call to "BindControls(myGridView, cmd)" instead of retyping this same basic block of code every time I need to bind a grid.
The problem is, this doesn't work with Repeaters or DataLists. The error shown says "There is no implicit reference conversion from 'System.Web.UI.WebControls.Repeater' to 'System.Web.UI.WebControls.BaseDataBoundControl'." I can't seem to find the right base class that is in common with all 3 controls.
For now I have overloaded the method specifically for Repeaters and DataLists, but does anyone know what I could use instead of "BaseDataBoundControl" that would work for all three control types?
- Dave
|
|
|
|
|
Try implementing an Interface.
|
|
|
|
|
I think that might be a little outside of my comfort zone, but I'll do some research on it. It might be a good learning experience if nothing else...
I was really hoping there would be some base class that I had just overlooked that would be inclusive of all three control types...
- Dave
|
|
|
|
|
You must "overload" your method.
In words, you write a method
with the same name several
times each taking differrent
args, something like
public void inABind(Gridview gv, DataSet ds)
{Put you code here}
public void inABind(DropDownList ddl, dataset ds)
{Put you code here}
public void inABind(WhateverControl wc, WhateverDataSource weds)
and on and on like that till
you cover all bases
|
|
|
|
|
That's what I've already done in my current solution. I was just looking for a common interface that would allow me to cover them all in one Generic method...
- Dave
|
|
|
|
|
overtech06 wrote: That's what I've already done in my current solution.
OOps sorry, I missed that in your original post.
|
|
|
|
|
overtech06 wrote: one Generic method...
Well you could use GetType() then a switch ...
protected void inaBind(Object a, Object c)
{
switch (a.GetType().Name)
{
case "GridView":
(a as GridView).DataSource = c as DataSet;
break;
case "Repeater":
(a as Repeater).DataSource = c as DataSet;
break;
}
}
|
|
|
|
|
I'm doing the following in a web page, and returning the results to a silverlight app:
Bitmap bmp = new Bitmap(60, 30);
MemoryStream ms = new MemoryStream();
bmp.Save(ms,System.Drawing.Imaging.ImageFormat.Gif);
Byte[] buffer = new Byte[ms.Length];
ms.Read(buffer, 0, (int)(ms.Length));
Response.ContentType = "image/jpeg";
Response.BinaryWrite(buffer);
bmp.Dispose();
g.Dispose();
In the client, I'm doing this:
string url =
WebClient client = new WebClient();
client.OpenReadCompleted += new OpenReadCompletedEventHandler(client_OpenReadCompleted);
client.OpenReadAsync(new Uri(url));
<br /><br />
void client_OpenReadCompleted(object sender, OpenReadCompletedEventArgs e)
{
BitmapImage bi = new BitmapImage();
bi.SetSource(e.Result); <---- crashes here with a "catastrophic failure"
Image image = new Image();
image.Source = bi;
e.Result.Close();
e.Result.Dispose();
this.testImage.Child = image;
}
The e.Result property contains a 536-byte stream (which seems reasopnable given the size of the image), but it crashes in the indicated position. Does anyone know what I'm doing wrong?
Here's the exception I'm seeing:
{System.Exception: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))<br />
at MS.Internal.XcpImports.CheckHResult(UInt32 hr)<br />
at MS.Internal.XcpImports.BitmapSource_SetSource(BitmapSource bitmapSource, CValue& byteStream)<br />
at System.Windows.Media.Imaging.BitmapSource.SetSourceInternal(Stream streamSource)<br />
at System.Windows.Media.Imaging.BitmapImage.SetSourceInternal(Stream streamSource)<br />
at System.Windows.Media.Imaging.BitmapSource.SetSource(Stream streamSource)<br />
at SLTestApp2.Home.client_OpenReadCompleted(Object sender, OpenReadCompletedEventArgs e)}
.45 ACP - because shooting twice is just silly----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
modified on Friday, April 30, 2010 10:27 AM
|
|
|
|
|
John Simmons / outlaw programmer wrote: Response.ContentType = "image/jpeg";
maybe image/gif would be better
|
|
|
|
|
Beyond the fact that it shouldn't matter, I'd already tried that...
The stream is getting back to the silverlight app, but it crashes when I call BitmapImage.SetSource() ...
.45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
I think somehow the Bytestream is corrupted or the Encoding is not perfect. Catastropic failure means somehow the bytestream cannot be set in the BitmapImage source.
I never used Silverlight, but in WPF I have used this, and it works correctly.
I think this would help you :
http://forums.silverlight.net/forums/p/94817/276293.aspx[^]
Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution. Visit My Website-->www.abhisheksur.com
|
|
|
|
|
Nope, I'd already seen that...
.45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Another thing if you need to show animated gif images you can use MediaElement to do that.
I think Animated gif can work only with mediaelement.
Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution. Visit My Website-->www.abhisheksur.com
|
|
|
|
|
No - it's just a static image.
An I actually got it working, but I don't know what I did to make it work...
.45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
SilverLight BitmapImage does not support Gifs:
From: http://msdn.microsoft.com/en-us/library/system.windows.media.imaging.bitmapimage(VS.95).aspx[^]
The BitmapImage can be used to reference images in the JPEG and PNG file formats.
So the best thing will be to stream them as PNG or JPEG.
MemoryStream ms = new MemoryStream();
bmp.Save(ms,System.Drawing.Imaging.ImageFormat.Jpeg);
Byte[] buffer = new Byte[ms.Length];
ms.Read(buffer, 0, (int)(ms.Length));
Response.ContentType = "image/jpeg";
Response.BinaryWrite(buffer);
bmp.Dispose();
g.Dispose();
Save the image as Jpeg and also change the content type to image/jpeg.
|
|
|
|