|
|
Hi All,
I am looking to incorporate the Excel Like Grouping on the columns of my grid view, Can this be done using the standard .net functionalities, if not can anyone recommend a 3rd party component library with features like this.
Thank You.
|
|
|
|
|
|
Thank You for your response Sandeep,
However i cant see any of the images/screenshots posted by Brij.
Can you suggest any alternative link?
Regards
Amit
|
|
|
|
|
Consider I have two fields, userCode and userName. I want to make userCode coloum in hyper link, by clicking that link.. I can view complete details of the particular user in LIGHTBOX.
krishna
|
|
|
|
|
|
Thank you...
krishna
|
|
|
|
|
it is very simple to get value in list box
|
|
|
|
|
|
Hi, can u pls tell me the code for how to set browser compatibility in Asp.Net Web Application?
|
|
|
|
|
|
Thank you for response
|
|
|
|
|
|
Hai Sandeep Mewara,
In my Javascript file i wrote "window.print();" to print entire window. It works fine in Iphone browser, but it is not working in Android mobile browsers. Can you please help me to rectify this problem.
|
|
|
|
|
I use EPplus for Genrate Excel Report and use StoreProcedure To get data from database.
The problem is that I want to remove one of the columns of information in the report file by EPplus
modified 7-Jan-13 9:11am.
|
|
|
|
|
cawboy_iran wrote: Stored procedure should not be changed.
Based on what you say, you need to write code to open excel sheet and then delete the column you don't want. Look into excel programming.
|
|
|
|
|
thanx for your reply...
I leave My Code Here
I would remove the additional Column in and also want to change the page layout direction to (right to left)
Protected Sub btnExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExcel.Click
If "MYcondition is true" Then
GenerateXLSXFile(CreateDataTable())
End If
End Sub
Private Sub GenerateXLSXFile(ByVal tbl As DataTable)
Dim excelPackage = New ExcelPackage
Dim excelWorksheet = excelPackage.Workbook.Worksheets.Add("My_Worksheet")
excelWorksheet.View.ShowGridLines = False
excelWorksheet.Cells.Style.Border.Bottom.Style = Style.ExcelBorderStyle.Thick
excelWorksheet.Cells("A5").LoadFromDataTable(tbl, True)
excelWorksheet.Column(2).Hidden = True
excelWorksheet.View.PageLayoutView = excelWorksheet.View.RightToLeft
excelWorksheet.Cells("A5").Value = "header_1"
excelWorksheet.Cells("B5").Value = "header_2"
excelWorksheet.Cells("C5").Value = "header_3"
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
Response.AddHeader("content-disposition", "attachment; filename=My_ExcelName.xlsx")
Dim stream As MemoryStream = New MemoryStream(excelPackage.GetAsByteArray())
Response.OutputStream.Write(stream.ToArray(), 0, stream.ToArray().Length)
Response.Flush()
Response.Close()
End Sub
Private Function CreateDataTable() As DataTable
Dim dataTable As New DataTable("tbl_Name")
Dim dataAdapter As New SqlDataAdapter()
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("ProvidersCS").ToString)
Dim cmd As New SqlCommand("My Select Command", conn)
cmd.CommandType = CommandType.StoredProcedure
Try
conn.Open()
dataAdapter.SelectCommand = cmd
dataAdapter.Fill(dataTable)
Catch ex As Exception
Finally
conn.Close()
End Try
Return dataTable
End Function
|
|
|
|
|
Hi,
I have installed WoW slider on my ASP.NET project. I don't know why images now showing on the slideshow.
The source is like this when I view the page source:
<li><img src="~/media/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/dc58c410-544f-11e2-a96e-00ffceb1d3b5.png" alt="" title="" width="906px" height="360px" id="9"/></li>
the image url is correct and I can see the image if I copy the above image url after adding the domain like http://localhost:50083
How can I fix this problem?
Technology News @ www.JassimRahma.com
|
|
|
|
|
Jassim Rahma wrote: src="~/media/members
I doubt if you can see '~' in page view source.
Based on what you say, it surely is relative path issue. Do a right click on the not displayed image and see the source - you will get the final URL being used and probably the issue.
Sounds like it is a relative path issue. This is one of the most common issue faced in a structured website.
There is a method exposed to handle URL's. Have a read: ResolveUrl[^].
I would suggest you to use this Tip and resolve the path correctly before setting the control/image source: Resolving Paths in a Multi-Folder WebSite[^]
Doing something like this can also help:
<img src='<%=ResolveUrl("~/Images/Progress.gif")%>' align="absmiddle" />
|
|
|
|
|
this is my error
i change textbox at gridview to dropdownlist (tempaltefield)
Code:
string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DB.mdb";
OleDbConnection con = new OleDbConnection(connString);
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "UPDATE Pay SET pay_sup_name=@pay_sup_name,pay_value=@pay_value,pay_check_No=@pay_check_No WHERE pay_id=@pay_id";
cmd.Parameters.Add("@pay_check_No", OleDbType.VarChar).Value = ((TextBox)PayGridView.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
cmd.Parameters.Add("@pay_value", OleDbType.VarChar).Value = ((TextBox)PayGridView.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
cmd.Parameters.Add("@pay_sup_name", OleDbType.VarChar).Value = ((DropDownList)PayGridView.Rows[e.RowIndex].Cells[4].Controls[0]).SelectedValue;
cmd.Parameters.Add("@pay_id", OleDbType.Integer).Value = Convert.ToInt32(PayGridView.Rows[e.RowIndex].Cells[1].Text);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
|
|
|
|
|
amsedky wrote: Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox
//((TextBox)PayGridView.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
Error in itself is quite straight forward.
You are directly casting controls from Grid cells into a defined type. One of the conversion is not correct. There is a Literal control instead of a textbox. A simple use of Visual Studio debugger will tell the line of code. Once you know, just handle it properly.
|
|
|
|
|
Hi
i need to display animated image while upload or save data into sql database and once finished hide the animated image
please help me how to do that in asp.net
thank's
|
|
|
|
|
|
I want to assign date from datatable format(01 Jan 2012) to excel element ..my prblm is while assigning to excel it changes to other format (01 01 2013)...plz give me solution to this...
|
|
|
|
|
I had similar problem with storing very long numbers in excel. I solved it by putting a single quote (') in front of the number. This way it was able to display the number properly and could also take this number in account in formulas and computations. Perhaps this trick could work on dates too. try putting '01 Jan 2012 in the excel and see if excel could recognize it as date.
Sadly, I don't have excel on this computer otherwise i would have tried it before posting.
Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
|
|
|
|