ASP.NET

indian143 wrote:

May be it something to do with its pdb files

Quote:

insert a data into SQL(MS SQL 2008 ) data base with apostrophe.

Quote:

insert with a stored procedure from C#.Including all DB connectivity

using (var connection = new SqlConnection("YourConnectionStringGoesHere"))
using (var command = new SqlCommand("YourProcedureNameGoesHere", connection))
{
    command.CommandType = CommandType.StoredProcedure;
    
    command.Parameters.AddWithValue("@YourParameterName", "This parameter value's got an embedded apostrophe.");
    
    connection.Open();
    command.ExecuteNonQuery();
}

praveenmachat wrote:

Kindly provide a sample code to execute query as function as mentioned in above fashion

//Sample modification on Richard's code
public void execute(ClassEmployee objEmp)

using (var connection = new SqlConnection("YourConnectionStringGoesHere"))
using (var command = new SqlCommand("YourProcedureNameGoesHere", connection))
{
    command.CommandType = CommandType.StoredProcedure;
    
    command.Parameters.AddWithValue("@EmpName", objEmp.EmpName);
    command.Parameters.AddWithValue("@EmpAge", objEmp.EmpAge);
    command.Parameters.AddWithValue("@EmpCity", objEmp.EmpCity);
    
    connection.Open();
    command.ExecuteNonQuery();
}

}

//You can create a common function to execute query or procedure,
 public static DataTable GetTable(SqlCommand cmd)
        {
            DataTable tbl = null;
            SqlConnection conn = null;
            try
            {
                conn = //Your connection;
                cmd.Connection = conn;
                tbl = new DataTable();
                SqlDataReader dr = cmd.ExecuteReader();
                tbl.Load(dr);

                dr.Close();
                dr.Dispose();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
            return tbl;
        }

DataTable tbl = GetTable(cmd); //pass you query or store-procedure here.

//design side:

<asp:chart id="yourchart" runat="server" Height="280px" Width="250px">
                            <titles>
                                <asp:Title ShadowOffset="3" Name="Title1" />
                            </titles>
                            <legends>
                                <asp:Legend Alignment="Center" Docking="Bottom" IsTextAutoFit="true" Name="Default" LegendStyle="Table" />
                            </legends>
                            <series>
                                <asp:Series Name="Default" /></series>
                            <chartareas>
                                <asp:ChartArea Name="ChartArea" BorderWidth="0" />
                            </chartareas>
                        </asp:chart>

//Coding Side
yourchart.Series[0].XValueMember = "YourColumn";
yourchart.Series[0].YValueMembers = "YourColumn";
yourchart.Series["Default"].IsValueShownAsLabel = true;
yourchart.Series["Default"].ChartType = SeriesChartType.Pie;
yourchart.Series["Default"]["PieLabelStyle"] = "Disabled";
yourchart.ChartAreas["ChartArea"].Area3DStyle.Enable3D = false;
yourchart.Legends[0].Enabled = true;
 

//Add Legend Text Column
LegendCellColumn LegendTextColumn = new LegendCellColumn();
LegendTextColumn.ColumnType = LegendCellColumnType.Text;
LegendTextColumn.Text = "#LEGENDTEXT";
yourchart.Legends["Default"].CellColumns.Add(LegendTextColumn);