|
Hi All,
How to export the data into excel file
Manoj Bisht
|
|
|
|
|
There is Article in CP Export Data into Excel[^] by Rama Krishna Kolluri.
Hope this article will help you.
Regards,
Satips.
|
|
|
|
|
How can I pass the value from texbox.text as parameter in my SQL query?
Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim txt As Integer
Dim updateCMD As SqlCommand
Dim query As String
txt = TextBox1.Text
query = "UPDATE [Temp] SET [value] = '??????' WHERE [name] = 'temprature'"
updateCMD = New SqlCommand(query, SQLconn)
updateCMD.CommandType = CommandType.Text
SQLconn.Open()
updateCMD.ExecuteNonQuery()
SQLconn.Close()
End Sub
Thanks
|
|
|
|
|
Modify query like this:
query = "UPDATE [Temp] SET [value] = @text WHERE [name] = 'temprature'"
Add this:
updateCMD.Parameters.AddWithValue("@text", Textbox1.Text);
|
|
|
|
|
Have you tried this :
----------------------------------------------
query = "UPDATE [Temp] SET [value] = '" + txt + "' WHERE [name] = 'temprature'"
Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India
|
|
|
|
|
The first method by szukuro worked...
When I use this I get a error about converting data from char to integer probably because the data type in database is a Integer.
query = "UPDATE [Temp] SET [value] = '" + txt + "' WHERE [name] = 'temprature'"
Thanks guys.
|
|
|
|
|
When I use this I get a error about converting data from char to integer probably because the data type in database is a Integer.
query = "UPDATE [Temp] SET [value] = '" + txt + "' WHERE [name] = 'temprature'"
--------------------------------------------------------------------
Then you had to just reomve quotes.
Like :
query = "UPDATE [Temp] SET [value] = " + txt + " WHERE [name] = 'temprature'"
--------------------------------------------------------------------
Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India
|
|
|
|
|
Hi Chaps,
Having a double request problem. I'm trying to figure out WHY it's double posting.
Checked the IIS Logs, and there are two almost identical records running a GET at the same time. The difference is in the very last number of the logs:
2007-04-27 09:04:32 192.168.0.12 GET <URL> 80 - 192.168.0.25 Nokia6600/+UP.Browser/7.0.2.3.119+(GUI)+MMP/2.0+Push/PO 302 0 0
2007-04-27 09:04:32 192.168.0.12 GET <URL> 80 - 192.168.0.25 Nokia6600/+UP.Browser/7.0.2.3.119+(GUI)+MMP/2.0+Push/PO 302 0 64
Note the "302 0 0" and the "302 0 64"
The 302 should mean a redirect, but i don't know what the 64 means, and i've spent far to long trying to find out.
Could anyone explain what it means, and what might cause such a double post in Asp.Net.
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
This is the common problem happens with ASP.NET. If I understood your question properly then I think you might have pressed Refresh button after the first postback. When you press refresh button form will be again posted and data will be added again. You can solve this by redirecting to the same page after doing the process. Assume you have a button click event some think like
button1_click()
{
Redirect("currentpage.aspx");
}
This will add data and redirect to the same page. All postback data will be cleared and data won't be replicated on refreshing. 
|
|
|
|
|
Hi
Cheers
It's a stand alone page that is redirected too, and then redirects out once complete.
The second 'GET' is a ghost.
Cheers
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Obvious question: are you calling Response.Redirect two times?
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe
|
|
|
|
|
Is it something to do with authentication - you can get multiple requests if you are using integrated windows authentication.
|
|
|
|
|
when database is changed corresponging .php also changes but it does not reload the .swf file and on browser refresh, it shows the old .swf file only.
I am using asp.net 2.0
yog
hui gfgh kgdgrt njjn hjgkn
|
|
|
|
|
The only thing you can do is clear browser's history and delete offline content.
Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India
|
|
|
|
|
I want to keep each feild in particular width. How should I do this.
I set width property , but not working
|
|
|
|
|
Set width of ItemStyle,
<ItemStyle Width="10px"></ItemStyle>
|
|
|
|
|
|
Hi,
Can u tell us exactly how u r setting the width of columns in the datagrid?
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
The text has come to the width which I set now but the column width has not changed.
|
|
|
|
|
Hi,
Not getting the problem.
You want your columns to be with fixed width or u want them to be resize as per the length of content?
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
I have a description column in my data grid. In the datagrid I don't want to show full description. only I want to show full description in details view.
|
|
|
|
|
Hi,
Then you should explicitly trim you description value coming from the database. This you can do in the ItemDataBound event of the datagrid.
private void dg_ItemDataBound(object sender, DatagridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternateItem)
{
if(e.Item.Cells[2].Text.Legth > 50)
{
e.Item.Cells[2].Text=e.Item.Cells[2].Text.Substring(0, 49) + "...";
}
}
}
Here column 2 in the datagrid is bound to the description field of the datasource.
I hope this will help you.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
Thanks, I am very new to this field can u help me if I am giving this in codebehind and should I do anything in source code(Template feild).
|
|
|
|
|
Hi,
Put this is in codebehind and replace "private" with "public" and u have to do one thing in the .aspx file.
set "OnItemDataBound" property of datagrid to "dg_ItemDataBound".
I hope this will help you.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
