|
Dear Friends,,
Please help me
How we can make Excel like Grid in ASP.NEt 2.0 ?
Please Help me..................
Haridas.R
harisofttech@gmail.com
harisofttech@hotmail.com (online)
harizeenet@yahoo.co.in(online)
"Achievement is not a destination, its a journey "
|
|
|
|
|
|
Word Doc from Database
Hi i am creating an application that help the user to upload his word documents to an sql server database
i want to bind a datagrid to the database so the user can see what he uploaded. also, when the user clicks on the document title it will load it in Microsoft Word so he can read it.
any idea how to bind the datagrid to the documents stored in the databse and how to load a document into Microsoft word?
Nina
|
|
|
|
|
Hi,
I appologise for my knowledge of English. I think you be able use table in data base - Name(char(50)), Data(text). Name for document title and Data for Ms Word document. For load document you be able use ASP.NET web handler's. Web handlers are software modules that handle raw HTTP requests received by ASP.NET. I be able send you sample use this handler's.
|
|
|
|
|
Hi,
This is very simple.
1) You store the word document in a specific folder on the server.
2) Store the filename and path details to a database table.
3) Select the files information and assign to a datagrid, on the datagrid make the file name as a hyperlink.
4) onclick of the link open the file by changing the content type.
Ram
|
|
|
|
|
can you show me a code sample of changing the content type?? and downloading the file?
|
|
|
|
|
Onclick event of an linkbuttton (which has file name as text) write this code(change variable names etc...)
sFullFilePath is the file path (Retrieved from database table)
System.IO.FileInfo oFileInfo = new System.IO.FileInfo(sFullFilePath);
if(oFileInfo.Exists)
{
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" +
sOrigFilename);
Response.AddHeader("Content-Length", oFileInfo.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.WriteFile(sFullFilePath);
Response.End();
}
else
{
lblMessage.Text = "The file cannot be found.";
}
Ram
|
|
|
|
|
in code behind pages, and inside ItemDataBound , how i get the data if the datagrid mode is edit mode, that means..
dim a as string
a = xxxxxxxxx
xxxxxxx is the coding to reterive the data from the selected row inside datagrid in edit mode ?
how i write tis xxxxxxxxx code ?
Best regards,
Chee ken
|
|
|
|
|
Private Sub DataGrid1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.ItemCommand <br />
<br />
Dim ID As Int32 <br />
<br />
ID = Convert.ToInt32(e.Item.Cells(0).Text)
There is an example at:
http://www.programmingknowledge.com/simpleDataGrid.aspx[^]
|
|
|
|
|
If you want to check the edit mode then you can put this check for that;
if(e.Item.ItemType==ListItemType.EditItem)
Best Regards,
Apurva Kaushal
|
|
|
|
|
if(e.Item.ItemType==ListItemType.EditItem)
this code put inside ItemDataBound or Editcommand ?
Best regards,
Chee ken
|
|
|
|
|
This has to be put in the OnItemDataBound. So this code(under this condition) will get executed for the which is in edit mode.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanks for your help.
Best regards,
Chee ken
|
|
|
|
|
always welcome..
Best Regards,
Apurva Kaushal
|
|
|
|
|
I was trying to export my gridview to excel.
protected void btnExcel_Click1(object sender, EventArgs e)<br />
{<br />
Response.Clear();<br />
Response.Buffer = true;<br />
Response.ContentType = "application/vnd.xls";<br />
Response.Charset = "";<br />
<br />
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();<br />
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);<br />
<br />
dgDisplay.RenderControl(oHtmlTextWriter);<br />
Response.Write(oStringWriter.ToString());<br />
Response.End();<br />
<br />
}<br />
public override void VerifyRenderingInServerForm(Control control)<br />
{<br />
}<br />
<br />
Can someone explain to me what this error means?
RegisterForEventValidation can only be called during Render();
thanks in advance. Much appreciated.
|
|
|
|
|
|
thanks for the above link.
thanks in advance. Much appreciated.
|
|
|
|
|
Anybody know how to save data from datagrid into dataset?
Best regards,
Chee ken
|
|
|
|
|
Check out this link
http://www.devx.com/tips/Tip/28651
hope it will help u.
Navi
|
|
|
|
|
I have a button on a ASP.NET page. I have some code in the page_load event.
Every time i click the button first the page_load event is firing first and then
the button_click event. How can i make the button_click event to fire first and
later the page_load event.
Thanks
Kal
|
|
|
|
|
hi there,
I think you mean that you want the code in block Page_Load not execute when the button is clicked, right? if so, you just put the code into block if(!Page.IsPostBack) , it'll not execute when user clicks the button
Hope this helps...
<< >>
|
|
|
|
|
I'm sure this has been brought up before, but I just can't seem to locate the answer.
I have an internal application that needs to allow access to an admin to manage roles and users on the ASP.Net 2 Website Administration Tool that we all love so much
My question is, is there a way to provide access to this "site" area to someone who is NOT on the local server?
Any help is much appreciated... thanks
|
|
|
|
|
Ok first, I'll outline my project. It is a web application made to search and display records of archived technical documents. What I have right now is a page that uses datagrids (via drag and drop from Visual Studio 2005) to display columns of data from my SQL Test server.
What I need now is a way to create a simple form text box and create and pass a variable to the SELECT statement within the datagrids. All my attempts at this thus far, using both ASP and C# and MSDN knowledgebase, have ended in frustration.
Here is the code of the datagrid:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="OVERVIEW" HeaderText=" " SortExpression="OVERVIEW" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="
<%ConnectionStrings:trdConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:trdConnectionString2.ProviderName %>"
SelectCommand="SELECT [OVERVIEW] FROM [SUDS_TRD] WHERE [IDENT]='1'">
</asp:SqlDataSource>
What I need to do is where it says [IDENT]='1', is have that "1" be a parameter passed from an HTML form, perhaps looking like this WHERE [IDENT]='"% strIDENT %"', yet I do not know how to pass a parameter from an HTML form into that SELECT statement. Any help would be great as this is a problem holding up my project.
To reiterate, I need to:
A. create an html form text box
B. pass that textbox as a variable
C. place that variable into the SELECT statement for the ASP datagrid.
Any help would be great, example code, whatever it takes; the simpler the better =) Please just don't send me to MSDN's Datagrid Knowledge Base page as 1/2 the stuff there doesn't even work =[.
Thanks for any help in advance!
Jesse Myse
jessemyer06@aol.com
-- modified at 15:55 Monday 21st August, 2006
|
|
|
|
|
Hi,
You can not pass HTML text box and construct an query dynamically. You should go for server side coding. Imagine there is a button control on click of the control you have to construct the query dynamically based on the values entered on the textbox. So onclick event of the button you can construct the query like,
button1_onclick()
{
string strQuery = "";
strQuery = "Select field1, field2 from table1 where field1 like %'" + textbox1.text.trim() + "%'";
then execute the query with adaptor or something....
}
Ram
|
|
|
|
|