|
Following is the code that i have written to write contents of response object into an ExcelSheet.
<br />
Response.Clear();<br />
Response.Buffer = true;<br />
Response.ContentType = "application/vnd.ms-excel";<br />
Response.Charset = "";<br />
string sep = "";<br />
foreach (DataColumn dc in dt.Columns)<br />
{<br />
Response.Write(sep + dc.ColumnName);<br />
sep = "\t";<br />
}<br />
Response.Write("\n");<br />
<br />
int count;<br />
foreach (DataRow drow in dt.Rows)<br />
{<br />
sep = "";<br />
for (count = 0; count < dt.Columns.Count; count++)<br />
{<br />
Response.Write(sep + drow[count].ToString());<br />
sep = "\t";<br />
}<br />
Response.Write("\n");<br />
}<br />
If less than 30 records are there in the response , its not writting in the excel sheet.
Plzzzz help me
Mads
|
|
|
|
|
hi friends
i have two forms
1.login form
2.timesheet form
log inform database contains employeeid,username,password columns.
statically i give someusername,password in database table.
now username,password is correct it will redirect to timesheet form
my query is
how can i get the employee id using usernamefrom loginform to timesheetform
i want to store employee id in session
thanks in advance
regards
saravanan
|
|
|
|
|
What you are asking here is really basic, you simply take the input value from the login form then execute a simple query against DB to select the value. There are tons of tutorials out there that you can learn, you might also download the starter kits from the Microsoft ASP.NET site to learn from them.
|
|
|
|
|
You get it like this:
LoginControl1.UserName.Trim();
|
|
|
|
|
I followed the article here http://www.kirupa.com/net/sql_asp_introduction.htm
everything compiles ok but when it get to opening the database I get error message
An attempt to attach an auto-named database for file C:\Path\Games.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share
I do not have any other databases with the same name and it is on the C drive so leads me to believe for some reason it can not open the database.
could someone please help me with this.
Thanks
|
|
|
|
|
|
ok i figured out what was wrong, .net 2.0 needed to be reinstalled, my app now runs but does not write to the database, is there something wrong with my code to write to the database?
SqlConnection connection;
protected void Page_Load(object sender, EventArgs e)
{
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["GameConnection"].ConnectionString);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlCommand command = new SqlCommand("INSERT INTO gameTable(gameName, gamePlatform) VALUES (@id_gameName,@id_gmaePlatform)", connection);
SqlParameter nameContent = new SqlParameter("@id_gameName", SqlDbType.VarChar);
nameContent.Value = txtName.Text;
command.Parameters.Add(nameContent);
SqlParameter platformContent = new SqlParameter("@id_gamePlatform", SqlDbType.VarChar);
platformContent.Value = txtPlatform.Text;
command.Parameters.Add(platformContent);
connection.Open();
command.BeginExecuteNonQuery();
connection.Close();
Response.Redirect("Results.aspx");
}
|
|
|
|
|
Planker wrote: command.BeginExecuteNonQuery();
connection.Close();
You make an asynchronous call to insert data, but you close the connection right after that then how data can be inserted into DB. You might also double check the parameter name gmaePlatform as well.
|
|
|
|
|
I have a GridView that displays rows of pictures along with text that describes the pictures. When I click on the picture I would like another page to display. How do I write an event for that, or can I configure the Imagefield in the GridView to do this? Thanks.
|
|
|
|
|
AFAIK, the ImageField does not allow you to define the event handler in the field markup, instead you'll need to use the RowCreated/RowDataBound event of the GridView control and try to get reference to the Image control, then register your event handler script. Another option is to use the Image control with the TemplateField in lieu of the ImageField and you can easily add the event handler for the Image control in the template.
|
|
|
|
|
You shouldn't need any event handlers, a template field with an image link will do the trick.
|
|
|
|
|
hi friends
i want display the current date in textbox.how can i bind the date with c#,asp.net
plz give me the code
regards
saravanan
|
|
|
|
|
SomeTextBoxThatYouHave.Text = DateTime.Now.ToString("d", TheFormatInfoOrCultureInfoThatYouWantToUse);
---
Year happy = new Year(2007);
|
|
|
|
|
hi
thanks for reply
i want currentdate only.i dont want time.date is dd/MM/yyyy this format
regards
saravanan
|
|
|
|
|
You can't get only a date. The DateTime structure is used to handle dates and times, and there is no Date structure wihtout time. The time is always there, even if it's 0:00, it's still there. It's no problem, though, as you choose what you want to display when you convert the DateTime value to a string.
The formatting string that you use in the call to ToString determines the format. The "d" string specifies the use of a short date format. The short date format is depending on the culture, so you should specify a FormatInfo or CultureInfo object to determine the culture to be used.
---
Year happy = new Year(2007);
|
|
|
|
|
Try like this,
sometextbox.Text = Now.ToString("dd/MM/yyyy")
|
|
|
|
|
If you call DateTime.Now.ToShortDateString(), you will get a string that is locale correct.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Is there any way to handle event(maybe some custom) raised by ASP.NET page in outer application(of course in .NET platform)? I am running Windows Form and start ASP.NET server from form. And data received from web should be processed in form too.
|
|
|
|
|
I believe that there are a couple of options to notify the Windows Form ( or an outer .Net application in general), for example .Net remoting, MSMQ, ....
|
|
|
|
|
I believe this too;) But would be great to know HOW should I do
|
|
|
|
|
Assuming you use the .Net Remoting, briefly your Window application can host an object that can be called remotely from an outer application like the ASP.NET application. Whenever a custom event happens in the ASP.NET application, you can send a request from the ASP.NET application to notify the Windows application via this remote object about this event as well as the event-related data sent along with the request. For more information, sample code, and how-tos you can see Remote Objects[^]
|
|
|
|
|
Thanx for this - remoting is quite usable. But maybe there is a way to pass objects inside system? I mean that would be great if objects will not be able to come out from local machine .NET system.
|
|
|
|
|
|
|
I'm trying to use TabPanels inside of a TabContainer. Each of the TabPanels contains an iFrame with src specified. The problem I'm having...The panels will not adjust in size according to the content and content is not being displayed. If I don't use frames and simply place all markup/content within the <contenttemplate> tags, the panels' size adjusts to accomodate. Is there a trick to getting the TabPanels to work with iFrame?
<cc1:tabcontainer runat="server" id="Tabs" onclientactivetabchanged="ActiveTabChanged">
<cc1:tabpanel runat="Server" id="Panel1" headertext=" Page1 ">
<contenttemplate>
<cc1:tabpanel runat="Server" id="Panel2" headertext=" Page2 ">
<contenttemplate>
<cc1:tabpanel runat="Server" id="Panel3" headertext=" Page3 ">
<contenttemplate>
lawsop
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
