|
Hi all,
I have datagrid dg1, paging is true and at a time it is displaying 10 records.I want to export this to excel.Whatever the data is displaying the datagrid at a time that will only export to excel.I dont want to display all the data from database.Is there any solutions .
I am using C#.
Thanks is advance
|
|
|
|
|
Just write a CSV, Excel will open that fine.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
|
Here is the coding for to display the gridview items to the excel when the button is clicked.
Using System.IO;
Using System.Text;
Button1_Click()
{
String attachment="attachment;filename=Gridview.xls";
Response.ClearContent();
Response.AddHeader("content-disposition",attachment);
Response.ContentType="application/ms-excel";
StringWriter sWriter=new StringWriter();
HtmlTextWriter htwWriter=new HtmlTextWriter(sWriter);
Gridview1.RenderControl(htWriter);
Response.Write(sWriter.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
|
|
|
|
|
hi.
on my project i need to carry the value of datagrid to next page.
the datagrid i have is edited by me and i want the value of link to next page
(the datagrid contains a linklabel and a imagebutton)
i tried it with sessions but dont know about fecthing value of selected row
|
|
|
|
|
If you want to carry a value to the page you're linking to, just put it on the query string. Don't abuse the session object.
And try posting code when you want help, so we can see what you're trying to do, and where it's broken.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
maybe i dont put the clear message
well i have a datagrid view extracting values name(linklabel) and imagename(imagebutton) from database
the paging is enabled i just want the value of linklabel to get fecthed for use in next page.
|
|
|
|
|
OK, I think you need to drop your tools, buy a BASIC ASP.NET book and READ it. You need to do EXACTLY what I said. Your link to the next page should put whatever you want to pass, on the URL. If you want to pass lots of things, you're better off passing an Id and reading the whole record from the database, in the page.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
hi frnds i am a beginner of ajax controls in asp.net c# .so as it is i am having so much problems in using advance controls like mouserover, accordian etc.....
can youy help me with articles or refer books .
i tried some asp.net books but they are not so much helping for all ajax controls 
|
|
|
|
|
Alok sharma ji wrote: can youy help me with articles or refer books
Look Here[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
thanks this should help me lot, but can you refer something for more to advance skills in ajax so i dont need to put question again. 
thanks again
|
|
|
|
|
Alok sharma ji wrote: but can you refer something for more to advance skills in ajax
First Start from W3School[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
If u r a beginner or not ur question has no urgency for us.It wont get any special attention if u use "urgent" or "i am dying".So b4 posting the question read and learn how to post the question decently.
|
|
|
|
|
Just so you know, you're not learning AJAX at all, AJAX is hidden from you, you're playing with some controls that use AJAX, I doubt you have the remotest idea how that works.
So, look for books like 'Mastering ASP.NET AJAX. If you buy AJAX books, they will just confuse you and will not pertain to the controls you're talking about.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
I want to develop simple antivirus which scan files from pc with virus names and if it found virus then that can be deleted.
So can any one help me for logic behind that and how can I compare files.
Where I have to store virus database.
Thanks in advance.
|
|
|
|
|
is this the topic of asp.net maybe not you should post it to a different forum or
you are wasting your time 
|
|
|
|
|
If u r not able to answer so plz don,t reply. No need to laugh. Don't waste ure time.
|
|
|
|
|
swami samarth wrote: I want to develop simple antivirus which scan files from pc with virus names and if it found virus then that can be deleted
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
All are asking doubts here and sharing their knowledge here ,your question is not important than others ,all will have the same priority.So dont use "urgent".
|
|
|
|
|
This is not an answer of my question.
|
|
|
|
|
If someone is paying you for this, they are more lost even than you are. If you're programming for fun, then choose a more sensible project.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
This is not an answer to my question.
|
|
|
|
|
Hi All,
i have 4 textboxes.
when the length of text in first textbox is equal to 4 then it should "automatically" change its focus to next textbox. i have set the autopostback to true but i need to click on screen to make a postback.
i used onKeyPress, onKeyUp, onTextChanged but nothing is working for me... or is there any mistake in my code..
.aspx page :
<asp:textbox id="TextBox1" runat="server" onkeyup="textLength()" xmlns:asp="#unknown">
javascript code :
function textLength() {
var val = document.getElementById("TextBox2").value;
if (val.length == 4) {
document.getElementById("TextBox3").Focus();
}
}
in .aspx.cs page:
TextBox2.Attributes.Add("onKeyUp", "javascript: textLength();");
is there any way to achieve this..
Thanks in Advance.
|
|
|
|
|
What do you mean by 'not working' ? I'd write a method that takes the id of the textbox you want to move to, the textbox you're in, and the length you're looking for, so you can reuse it. onkeyup="myfunc(this)" would pass the control instance, then you only need to look up the other one.
Make sure that the client side id is 'TextBox2', it probably isn't. You use the ClientID property of the server control to get the client side Id.
Never use a control you got with getElementById without checking first if it's null.
You can also install firebug for firefox and step through your script to make sure it's called, and see how it's working. Or use alerts to tell you when they get called, if you want something less functional but easier to set up.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
thanks for replying...
my javascript is not executing .
i verified my code many times. iam unable to figure it out (why javascript is not executing).
this is my entire code:
protected void page_load(object sender, EventArgs e)
{
if(Page.IsPostBack)
{
TextBox2.Attributes.Add("onKeyUp", "javascript: textLength();");
}
}
]]>
<title>Untitled Page
function textLength() {
alert("its called");
var val = document.getElementById("TextBox1").value;
if (val.length == 4) {
document.getElementById("TextBox2").Focus();
}
}
<asp:textbox id="TextBox1" runat="server" autopostback="true" xmlns:asp="#unknown">
onKeyUp="textLength(this)" >
<asp:textbox id="TextBox2" name="t2" runat="server" ontextchanged="TextBox_TextChanged" xmlns:asp="#unknown">
Is everything is correct ?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
