|
I need help applying a tool bar to my website in which people can comment on my page. any help here??
modified on Friday, July 24, 2009 12:45 AM
|
|
|
|
|
I hope this isn't a programming question.
|
|
|
|
|
well it maybe. People cant blog on my site I just created. Please visit www.numbskullkid.com and click review on the top left corner of my main page and see what I mean. I just want feed back from people visiting my site. Can you help?
|
|
|
|
|
You're going to get slammed for posting a programming question in the Lounge.
You should post this question in one of the programming forums instead.
|
|
|
|
|
How dare you.
|
|
|
|
|
hey im using sql server connection with oledb provider to access database..previously it was ms access file .. now i am try switched to sql database.. here is the C# code:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Drawing.Text;
using System.Drawing.Imaging;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Web.UI.DataVisualization.Charting;
using System.Data.OleDb;
namespace System.Web.UI.DataVisualization.Charting.Samples
{
public partial class DataBindSeriesByRows : System.Web.UI.Page
{
protected void Page_Load(object sender, System.EventArgs e)
{
string myConnectionString = "Provider=SQLNCLI.1;Data Source=.;Integrated Security=SSPI;Initial Catalog=abc";
string mySelectQuery="SELECT * FROM SALESCOUNTS;";
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
myCommand.Connection.Open();
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = myCommand;
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "Query");
foreach(DataRow row in myDataSet.Tables["Query"].Rows)
{
string seriesName = row["SalesRep"].ToString();
Chart1.Series.Add(seriesName);
Chart1.Series[seriesName].ChartType = SeriesChartType.Line;
Chart1.Series[seriesName].BorderWidth = 2;
Chart1.Series[seriesName].ShadowOffset = 2;
for(int colIndex = 1; colIndex < myDataSet.Tables["Query"].Columns.Count; colIndex++)
{
string columnName = myDataSet.Tables["Query"].Columns[colIndex].ColumnName;
int YVal = (int) row[columnName];
Chart1.Series[seriesName].Points.AddXY(columnName, YVal);
}
}
DataGrid.DataSource = myDataSet;
DataGrid.DataBind();
myCommand.Connection.Close();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
private void InitializeComponent()
{
}
#endregion
}
}
==============================================================
IM getting this error on running this code..:
Server Error in '/DataBindSeriesByRows' Application.
Specified cast is not valid.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Specified cast is not valid.
Source Error:
Line 68:
Line 69: string columnName = myDataSet.Tables["Query"].Columns[colIndex].ColumnName;
Line 70: int YVal = (int) row[columnName];
Line 71:
Line 72: Chart1.Series[seriesName].Points.AddXY(columnName, YVal);
Source File: c:\Documents and Settings\gauravk\My Documents\WebSamples\WebSamples\WorkingWithData\DataBinding\DataBindSeriesByRows\DataBindSeriesByRows.aspx.cs Line: 70
Stack Trace:
[InvalidCastException: Specified cast is not valid.]
System.Web.UI.DataVisualization.Charting.Samples.DataBindSeriesByRows.Page_Load(Object sender, EventArgs e) in c:\Documents and Settings\gauravk\My Documents\WebSamples\WebSamples\WorkingWithData\DataBinding\DataBindSeriesByRows\DataBindSeriesByRows.aspx.cs:70
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
plz help buddiess... i'll be very grateful.. thanks in advance
modified on Thursday, July 23, 2009 5:00 PM
|
|
|
|
|
Please post the code with Proper Format.
Like,
protected void Page_Load(object sender, System.EventArgs e)
{
Which will make thinks readable.
[Note : Don't Repost : Update The Original Post ]
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.
|
|
|
|
|
namespace System.Web.UI.DataVisualization.Charting.Samples
{
///
/// Summary description for ImageMapCustom.
///
public partial class DataBindSeriesByRows : System.Web.UI.Page
{
protected void Page_Load(object sender, System.EventArgs e)
{
// resolve the address to the Access database
//string fileNameString = this.MapPath(".");
///fileNameString += "..\\..\\..\\..\\data\\chartdata.mdb";
// initialize a connection string
string myConnectionString = "Provider=SQLNCLI.1;Data Source=.;Integrated Security=SSPI;Initial Catalog=abc";
// define the database query
string mySelectQuery="SELECT * FROM SALESCOUNTS;";
// create a database connection object using the connection string
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
// create a database command on the connection using query
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
// open the connection
myCommand.Connection.Open();
// Initializes a new instance of the OleDbDataAdapter class
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = myCommand;
// Initializes a new instance of the DataSet class
DataSet myDataSet = new DataSet();
// Adds rows in the DataSet
myDataAdapter.Fill(myDataSet, "Query");
foreach(DataRow row in myDataSet.Tables["Query"].Rows)
{
// for each Row, add a new series
string seriesName = row["SalesRep"].ToString();
Chart1.Series.Add(seriesName);
Chart1.Series[seriesName].ChartType = SeriesChartType.Line;
Chart1.Series[seriesName].BorderWidth = 2;
Chart1.Series[seriesName].ShadowOffset = 2;
for(int colIndex = 1; colIndex < myDataSet.Tables["Query"].Columns.Count; colIndex++)
{
// for each column (column 1 and onward), add the value as a point
string columnName = myDataSet.Tables["Query"].Columns[colIndex].ColumnName;
int YVal = (int) row[columnName];////// ERRROR IN THIS LINE
Chart1.Series[seriesName].Points.AddXY(columnName, YVal);
}
}
DataGrid.DataSource = myDataSet;
DataGrid.DataBind();
// Closes the connection to the data source. This is the preferred
// method of closing any open connection.
myCommand.Connection.Close();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
}
#endregion
}
}
is this thing you want....proper format i think
|
|
|
|
|
No this is the same thing you have post and I have requested you dont repost, just modify your last post.
Use pre tag in between you code block. Break the code in different section.
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.
|
|
|
|
|
posted ... plz help me out
actually im trying to connect the sql database to charts just im hindered by this ERROR... plz help
... really needed... i'll be very grateful thanks in advance
|
|
|
|
|
Hope you have resolved your problem. If you have some doubts please let me know
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Hello solo,
re:
string columnName = myDataSet.Tables["Query"].Columns[colIndex].ColumnName;
int YVal = (int) row[columnName];////// ERRROR IN THIS LINE
I believe that you may be trying to cast a non convertible variable to an integer. Check the value of column name in the debugging mode. If it is indeed a number, so it can be converted to an integer, the use the following code:
intYVal = Convert.toInt32(row[ColumnName].toString());
This should return the correct integer value.
Best Regards, Pat
|
|
|
|
|
solo_gaurav wrote: string columnName = myDataSet.Tables["Query"].Columns[colIndex].ColumnName;
int YVal = (int) row[columnName];////// ERRROR IN THIS LINE
Put breakpoint over here. Now Check what is value of columnName and What does row[columnName] Returns.
solo_gaurav wrote: Exception Details: System.InvalidCastException: Specified cast is not valid.
The Stack Trace Clarly says there is problem with Type Casting. So Please checkk the value for that line.
[Edit]
1.While debug please check for all item inside the for-each loop
2. Never put Keyword Like Urgent in subject or any where on the post. If some body knows the answer will definately give you.
[/Edit]
Please mark it as good answer if its helps you
Thanks !!
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
modified on Thursday, July 23, 2009 5:22 PM
|
|
|
|
|
|
Hi,
I've read a bit about ASP.NET and want to try it out to build a website. But right now I can't figure out how to get the server to recognize the application.
Interestingly all tutorials and "beginner" info discuss the internals of ASP.NET but say virtually nothing about how to actually implement it on the server.
In the simplest terms (I'm a total neophyte to ASP.NET) can someone try to explain how to get a simple "Hello World" page uploaded to a server so it actually runs.
Thanks,
Jeff
|
|
|
|
|
Can you get your simple ASP.NET application to run in the Visual Studio debug environment ?
Try this ...
Select Debug/Start Debugging from the menu. It will start a small web-server on your machine and run the web application there, allowing you to step through code if necessary.
If that works, then you need to setup IIS and deploy your ASP.NET application there.
Do you have a separate server with IIS installed ? or Are you trying to run IIS on your development machine ?
The next topic you may want to investigate is "Installing IIS".
|
|
|
|
|
Hi,
Thanks for your reply.
Okay, it runs fine when viewed on my computer. Basically I'm viewing it in Firefox and the address is listed as
http://localhost:49../FirstWebPage.aspx
This is all well and good, but obviously I want to run it on the server (a separate entity out in the midwest), not on my computer.
I'm very confused about what IIS is or does. One tutorial suggested I needed to enable IIS on my local machine, which I did, but that didn't make the program run any better or worse here (logically). The issue isn't how to make it run here but getting it to run on the server.
How exactly would the server know how to interpret the weird files spit out by ASP.NET? How does it know where to "enter"? Is there some way to tell the server "expect a ASP.NET application"?
I know this is incredibly basic but I find half the problems I encounter in programming are just this kind of thing, getting the first lines of communication started.
Thanks,
Jeff
|
|
|
|
|
Jeffrey Webster wrote: I'm very confused about what IIS is or does.
In simple words, IIS is an web server which used to HOST the ASP.NET web application. In Visual Studio, ASP.NET engined is integrated and its takes care of all the execution. Now for the hosting of the web application we need to deploy the site on IIS.
Jeffrey Webster wrote: One tutorial suggested I needed to enable IIS on my local machine,
Which OS are you using? In recent there are 3 IIS is used. IIS 5.1 (WinXP) , IIS 6.0 ( Win 2k3), IIS 7.0 (Vista Premium, Win Server 2008 )
I gueess you are dealing with Win2k3 and here is the installion guide of IIS 6.0
Installing IIS6
But installtion of rest are also same.
Jeffrey Webster wrote: How exactly would the server know how to interpret the weird files spit out by ASP.NET? How does it know where to "enter"? Is there some way to tell the server "expect a ASP.NET application"?
This is all about How IIS and ASP.NET integrated together, How IIS handels the request, What is the Use Of HTTPHandler and HTTPMoudle.
If am refering you some good links, This will help you
IIS 6 and ASP.NET
IIS 7 and ASP.NET
Hope this will helps you
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.
|
|
|
|
|
Hi,
I'll check out those links in just a second.
Which OS are you using? In recent there are 3 IIS is used. IIS 5.1 (WinXP) , IIS 6.0 ( Win 2k3), IIS 7.0 (Vista Premium, Win Server 2008 )
I'm assuming IIS 7.0 because I'm running Vista.
Also, as I mentioned in the other reply, there appears to be an issue because I'm running the Express version of the Visual Web Developer. I guess it's a Catch 22. I want to know if it is worth ponying up the dough for this thing. But it's hard to determine that if it won't let me upload the app to test.
Jeff
|
|
|
|
|
Jeffrey Webster wrote:
I'm assuming IIS 7.0 because I'm running Vista.
Cool.
Here is my complete Article on Deplying web site on IIS 7
Deploying ASP. Net Websites on IIS 7.0
Regarding Second part, I have already give you the answer
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.
modified on Thursday, July 23, 2009 4:40 PM
|
|
|
|
|
If you have developed your web application in VS studio and want to Deploy on server (IIS ) you need to perform the following step.
1. Published your web application from VS.
2. Copy the published folder in C:\initpub\wwwroot
3. Start > Run > inetmgr
4. Click on Default web site
5. You will get the folder of your web application.
6. Right Click on that Folder > Properties
7. In Defult Tab, There is a Create Button . Click on It
8. Goto ASP.NET TAb > Select Proper Framework Version
9. Goto Security Tab > Edit > Select Anonymous
10. Apply > OK
11. Close IIS
12. Open Browser > type http://ipaddress/VirtualDirectoryName/Default.aspx
That's All.
Here is an good Tutorial
Make Sure, IIS is installed in the Server and ASP.NET is registred with IIS.
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.
|
|
|
|
|
Hi,
Okay I see one of the problems I'm having is I'm using the Express edition. I just learned through the MSDN site that you can't publish the website without the full version.
I'm wondering if maybe there is a way to work around this limitation or if it really is impossible to actually use the Express edition in a practical way.
Thanks,
Jeff
|
|
|
|
|
Publishing of web site is something different and you can read some more information from net regrading this. Generaly it is done for security purpose. You can do the same thing with out publishing the web site as you are in learning phase, just copy the web site folder to wwwroot folder.
Please go through the CP article which I have provided to in my last answer.
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.
|
|
|
|
|
Hi,
Okay I'll check that out.
Thanks...
|
|
|
|
|
Let me know if you have any issue. I think I can help you on IIS related you
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.
|
|
|
|