|
Hi Kogg_G,
I have the same problem and cannot find a solution. Did you find out how to solve your problem?
If you did, I would appreciate you to telling me what to do or where to find some pertinent information.
Thanks.
|
|
|
|
|
Hi All,
I am developing a website in ASP.Net C#.
On click of a button, i am doing several process, such as creating several files, creating reports etc. I want to display this progress to user
For example
If the file1 is creating, the status will have to show
Creation of file1 in progress...
Please let me know how this can be done.
|
|
|
|
|
AJAX, probably. You'd have to make AJAX calls constantly, and show your progress as new messages come back.
Christian Graus
Driven to the arms of OSX by Vista.
Please read this[ ^] if you don't like the answer I gave to your question.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
|
|
|
|
|
Use AJAX, place an update panel and keep changing text of a label based on the functionality you are doing.
Example, when executing code for creating file1....put label text as creating file1.
then afterwards when saving in database....put label text as saving data etc.
Regards,
Kapil Thakur
(Where's there is Kapil , there is a way) - thakur.kapil@gmail.com
|
|
|
|
|
I do all that function in click of a button.
the code will be some thing like this
Generatereport();
GenerateFiles();
UpdateDatabase();
I created a scriptmanager and then a updatepanel and then added a label into the update panel.
then i changed the code like this
lbl1.Text="Updating reports";
Generatereport();
lbl1.Text="Updating Files";
GenerateFiles();
lbl1.Text="Updating Database";
UpdateDatabase();
This does not work, the code executes completely and the final label value is displayed.
|
|
|
|
|
I've a some TextFields & a asp button in ajax accordion content pane. It doesn't work when I click button; an error arises onClick: button1_Click in C# code.
error:No overload for 'btnBasicInfo_Click' matches delegate 'System.EventHandler'
asp:Button ID="btnBasicInfo" runat="server" Text="Save" OnClick="btnBasicInfo_Click"
modified on Wednesday, June 3, 2009 1:37 AM
|
|
|
|
|
arif.ict87 wrote: an error arises onClick: button1_Click in C# code.
What is the Error ?
|
|
|
|
|
i have datatable in which 2 row,1st column value is null
that column is datatype is DateTime.
wwhen i tried to add data to database..its gives me error as
Object cannot be cast from DBNull to other types.
i have done following..
foreach (DataRow dtRow in dtTrackingData.Rows)
{
SqlHelper.ExecuteNonQuery
(
myConnectionString
, "SP_NAME"
, iWeekNo
, Convert.ToInt32(dtRow["InvCoID"])
, Convert.ToDateTime(dtRow["LatestReportDateConsensus"])
, Convert.ToDateTime(dtRow["LatestReportDateVirtua"])
,dtFromDate
,dtToDate
,CreatedBy
);
}
i tried to add
if (dtRow["LatestReportDateConsensus"] == System.DBNull.Value)
dtRow["LatestReportDateConsensus"] =null;
still its not work..
how i will add value to datarow if its null
modified on Wednesday, June 3, 2009 1:22 AM
|
|
|
|
|
try using the following code :
foreach (DataRow dtRow in dtTrackingData.Rows)
{
SqlHelper.ExecuteNonQuery
(
myConnectionString
, "SP_NAME"
, iWeekNo
, Convert.ToInt32(dtRow["InvCoID"])
, IIF(IsDBNull(dtRow["LatestReportDateConsensus"]), "null" , dtRow["LatestReportDateConsensus"] )
, Convert.ToDateTime(dtRow["LatestReportDateVirtua"])
,dtFromDate
,dtToDate
,CreatedBy
);
}
i have used IIF function; it checks if datevalue is true for dbnull then adds null in database else the datevalue of datatable column
Regards,
Kapil Thakur
(Where's there is Kapil , there is a way) - thakur.kapil@gmail.com
|
|
|
|
|
didnt get that IIF
whts tht??
|
|
|
|
|
IIF is in vb.net
for C# its ((what) ? then : else)
Apologies for the goof up
Regards,
Kapil Thakur
(Where's there is Kapil , there is a way) - thakur.kapil@gmail.com
|
|
|
|
|
my code is in C#..
|
|
|
|
|
google for ((what) ? then : else) C#
Regards,
Kapil Thakur
(Where's there is Kapil , there is a way) - thakur.kapil@gmail.com
|
|
|
|
|
search lottttttt
but no success..
|
|
|
|
|
got the solution...............
SqlHelper.ExecuteNonQuery
(
myConnectionString
, "usp_InsertTrackingData"
, iWeekNo
, Convert.ToInt32(dtRow["InvCoID"])
, ((dtRow["LatestReportDateConsensus"] != DBNull.Value) ? dtRow["LatestReportDateConsensus"] : null)
, ((dtRow["LatestReportDateVirtua"] != DBNull.Value) ? dtRow["LatestReportDateVirtua"] : null)
,dtFromDate
,dtToDate
,CreatedBy
);
|
|
|
|
|
Friends
I had developed an small website in visualstudio 2008
and I had problem in Deployment of that site..
steps:
1.I installed IIS server
2.registered asp.net
3.Created virtual directary and placed in that folder
It is working in One System with
URL:http://localhost/home.aspx
I want that site to be run in the LAN systems
I am using XPsp2
came out of hardwork
|
|
|
|
|
What is your problem exactly ? If it has to run on the LAN, just replace localhost with the name of the machine. You understand what 'localhost' means, right ?
Christian Graus
Driven to the arms of OSX by Vista.
Please read this[ ^] if you don't like the answer I gave to your question.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
|
|
|
|
|
kumarjammula wrote: It is working in One System with
URL:http://localhost/home.aspx
I want that site to be run in the LAN systems
Its means its working in the machine where you have deployed. Now Try to access it from other machine with the IP Address of the deployed system like http://192.192.192.192/home.aspx
Make sure that system should have the same LAN.
kumarjammula wrote: 3.Created virtual directary and placed in that folder
BTW : one question, you have wrote you have create the Virtual Directory, What is your Virtual Directory name? If you have the Virtual directory you should access it from http://localhost/<Virtual Directory>/Home.aspx Or you are redirecting your site from Root to any where?
|
|
|
|
|
Hi all,
Can any one tell me how to export the data from datatable to excel without using Microsoft.office.tools.....
and formating the cells in the excel like in one cell entering 2-3 values etc.
Thanks in advance..
|
|
|
|
|
sarangkhandare wrote: Can any one tell me how to export the data from datatable to excel
Have a look
sarangkhandare wrote: formating the cells in the excel like in one cell entering 2-3 values
I don't understand this point. Can you be please more specific?
Thank you!
|
|
|
|
|
give a linkbutton "export to excel" and do the following code on its click event
Dim Grid As New System.Web.UI.WebControls.GridView
Try
Grid.AutoGenerateColumns = True
Grid.RowStyle.Wrap = True
Grid.AlternatingRowStyle.Wrap = True
Grid.DataSource = [YOUR DATASET]
Grid.DataBind()
-- header style required by you for excel
Grid.HeaderRow.Cells(0).Width = 200
Grid.HeaderRow.Style("font-family") = "Verdana"
Grid.HeaderRow.Style("font-size") = "12px"
Grid.HeaderRow.Font.Bold = True
Grid.HeaderRow.ForeColor = Color.White
Grid.HeaderRow.BackColor = Color.Blue
For Each row As System.Web.UI.WebControls.GridViewRow In Grid.Rows
-- row style required by you for excel
row.Cells(0).Width = 100
row.Style("font-family") = "Verdana"
row.Style("font-size") = "12px"
row.Style("text-align") = "left"
Next
Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename=" & [YOUR PREFERRED FILE NAME] & ".xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.xls"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As New HtmlTextWriter(stringWrite)
Grid.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString())
Response.End()
Catch ex As Exception
Finally
Grid.Dispose()
Grid = Nothing
End Try
Regards,
Kapil Thakur
(Where's there is Kapil , there is a way) - thakur.kapil@gmail.com
|
|
|
|
|
i have windows server 2008 R2 webserver edition, SqlServer 2008 enterprise and PowerShell 2.0. But this is Sql C# code can't connect. But can connect offical components. Exam: SQLDataSource.
cs = "SERVER=.\\SQLEXPRESS;Initial Catalog=arch;Integrated Security=SSPI";
con = new SqlConnection(cs);
querystring = "SELECT user_name, password, user_type FROM [users]";
cmd = new SqlCommand(querystring, con);
con.Open();
I thing block code PowerShell. Help!
battulga
|
|
|
|
|
You say you have SQL Server 2008 enterprise, yet your connection string is for SQLEXPRESS. Is your SQL Server 2008 a named instance, named SQLEXPRESS ?
Christian Graus
Driven to the arms of OSX by Vista.
Please read this[ ^] if you don't like the answer I gave to your question.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
|
|
|
|
|
This is code can run before time on Windows Server 2008, SQLServer 2008.
battulga
|
|
|
|
|
I have 2 user controls:
-1 contains my collapsiblepanel control.
-My other contains a button I want to click to expand my collapsiblepanel
How can I pass the value of my button click in my 2nd user control over to my collapsiblepanel in my 1st user control?
Can this even be done?
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
