Comments by 12045649 - CodeProject

12045649 23-Nov-15 5:31am View

No boss,Not like that i want it in normal asp application and not in table i want in form view...did u tried previous..

12045649 18-Nov-15 5:19am View

Boss,I don't have editor control in ajax toolkit how to do that.?

12045649 17-Nov-15 3:45am View

As u r seeing below
ADD YOUR SOLUTION HERE (there is b l u s small BIG ....)
like this i want bottom of the textbox..

12045649 4-Nov-15 1:44am View

hello Suvendu Shekhar Giri thank you from posting answer ...Can u write it in mysql please..i am unable to convert ..

12045649 2-Nov-15 8:20am View

query is not working ..Can u write another one please

12045649 2-Nov-15 1:39am View

No sir..it is not working ..It is showing all values as 0 and it is not showing all dates in 45th week.

12045649 2-Nov-15 1:21am View

i want it in mysql so..

12045649 2-Nov-15 0:46am View

thank you sir.for reply BUt small modification

i want remaining dates as zero

means if i give input as 45
45th dates should comes..

for example :

input 45 means
45th dates

dates | names

10/10/15 | rama
11/10/15 | shiva
12/10/15 | 0
13/10/15 | 0
14/10/15 | 0
15/10/15 | 0
16/10/15 | 0

like i should get can u try please

12045649 30-Oct-15 4:57am View

I kept that code ..it showing gridview... but that functionality is not working..

12045649 30-Oct-15 2:53am View

Hey Boss .they is no usefull code ..how to do that with out any hint..

12045649 29-Oct-15 8:09am View

PANKAJMAURYA can u tell me the query..

12045649 29-Oct-15 7:33am View

I am getting error like this:

Msg 1087, Level 15, State 2, Line 13
Must declare the table variable "@MissingCarTypeIDs".

Please guide me

12045649 29-Oct-15 7:30am View

Msg 1087, Level 15, State 2, Line 13
Must declare the table variable "@MissingCarTypeIDs".

12045649 29-Oct-15 7:24am View

Actually my table name is: get_date

My table :

dates | contacted
20/10/15| 3
21/10/15| 1
22/10/15| 5
24/10/15| 10
27/10/15| 3

I want to get like

dates | contacted
20/10/15| 3
21/10/15| 1
23/10/15| 0
22/10/15| 5
24/10/15| 10
25/10/15| 0
26/10/15| 0
27/10/15| 3

select * from get_date

12045649 29-Oct-15 7:04am View

hello Pankajmaurya ..thanks for reply

should i write date in place of @minDate and table name in place of @missingcartypeids

Can u please rewrite the query neatly..with comments understandable.plz

12045649 28-Oct-15 8:57am View

But Here in table i can't update in database ..while dragging and dropping i want to update in database also ..?Can u

12045649 27-Oct-15 8:03am View

It is showing blank page..it is not showing output..please tell me what to do

12045649 27-Oct-15 7:30am View

hello saha...please help me with above code ..what to change for changing the color

12045649 27-Oct-15 7:21am View

hello sir ,..thanks for valuable time ..last request see the following code ..please give respond

But ..i am using database for data..(hope u under stand)

source code :

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Multi series Line chart using Google Visualization</title>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Literal ID="lt" runat="server">
<div id="chart_div"></div>
</div>
</form>
</body>
</html>

.cs code :

public partial class _Default : System.Web.UI.Page
{
StringBuilder str = new StringBuilder();
//Get connection string from web.config
SqlConnection conn = new SqlConnection("server=ADMIN-PC\\SQLEXPRESS;database=rama;integrated security=true");

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
chart_bind();
}
}

private DataTable GetData()
{
DataTable dt = new DataTable();
conn.Open();
string cmd = "select * from lines";
SqlDataAdapter adp = new SqlDataAdapter(cmd, conn);
adp.Fill(dt);
conn.Close();
return dt;
}
private void chart_bind()
{
DataTable dt = new DataTable();
try
{
dt = GetData();

str.Append(@"<script type=*text/javascript*> google.load( *visualization*, *1*, {packages:[*corechart*]});

google.setOnLoadCallback(drawChart);
function drawChart() {
var data = new google.visualization.DataTable();
data.addColumn('number', 'Year' );
data.addColumn('number', 'Purchase');
data.addColumn('number', 'Sales');
data.addColumn('number', 'Expenses');

data.addRows(" + dt.Rows.Count + ");");

for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
str.Append("data.setValue( " + i + "," + 0 + "," + "'" + dt.Rows[i]["year"].ToString() + "');");
str.Append("data.setValue(" + i + "," + 1 + "," + dt.Rows[i]["purchase"].ToString() + ") ;");
str.Append("data.setValue(" + i + "," + 2 + "," + dt.Rows[i]["sales"].ToString() + ") ;");
str.Append("data.setValue(" + i + "," + 3 + "," + dt.Rows[i]["expences"].ToString() + ");");

}

str.Append(" var chart = new google.visualization.LineChart(document.getElementById('chart_div'));");
str.Append(" chart.draw(data, {width: 660, height: 400, title: '',");
// str.Append(" chart.draw(data, {width: 650, height: 300, title: 'Course Enrollment', color:#0092CB,");

str.Append("hAxis: {title: 'Year', titleTextStyle: {color: 'red'}}");
str.Append("}); }");
str.Append("</script>");
lt.Text = str.ToString().Replace('*', '"');
}
catch
{ }
}
}

12045649 27-Oct-15 6:51am View

no it is not changing the color

12045649 27-Oct-15 6:49am View

should i change any thing in .cs code..?

12045649 27-Oct-15 6:36am View

even though it is not coming..

12045649 27-Oct-15 6:19am View

should i remove axes:{ x:{side:'top'}};

12045649 27-Oct-15 6:15am View

i had done like this ..

var options = {

colors: ['red', '#004411', 'Black'],
axes: {
x: {
0: { side: 'top' }
}
}
};

12045649 27-Oct-15 6:01am View

hello saha,...i have changed the datatype..afterward..what to do for changing the color of a line

12045649 27-Oct-15 4:48am View

Deleted

hello saha..

i had copied u r code in source code..But it is not changing the color ..Can u please help me with that..

source code :

<head>
<title></title>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1.1', { packages: ['line'] });
google.setOnLoadCallback(drawChart);

function drawChart() {

var data = new google.visualization.DataTable();
data.addColumn('string', 'Year');
data.addColumn('number', 'Purchase');
data.addColumn('number', 'Sales');
data.addColumn('number', 'Expenses');

data.addRows([
[1, 37.8, 80.8, 41.8],
[2, 30.9, 69.5, 32.4],
[3, 25.4, 57, 25.7],
[4, 11.7, 18.8, 10.5],
[5, 11.9, 17.6, 10.4],
[6, 8.8, 13.6, 7.7],
[7, 7.6, 12.3, 9.6],
[8, 12.3, 29.2, 10.6],
[9, 16.9, 42.9, 14.8],
[10, 12.8, 30.9, 11.6],
[11, 5.3, 7.9, 4.7],
[12, 6.6, 8.4, 5.2],
[13, 4.8, 6.3, 3.6],
[14, 4.2, 6.2, 3.4]
]);

var options = {
chart: {
title: 'Box Office Earnings in First Two Weeks of Opening',
subtitle: 'in millions of dollars (USD)'
},
width: 900,
height: 500,
colors: ['red', '#004411', 'Black'],
axes: {
x: {
0: { side: 'top' }
}
}
};

var chart = new google.charts.Line(document.getElementById('line_top_x'));

chart.draw(data, options);
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:Literal ID="lt" runat="server">
<div id="chart_div"></div>
</div>
</form>
</body>

12045649 27-Oct-15 4:43am View

Hello saha..Have u seen my code ..
Can u please explain u r code..What is that numbers..How to give our own color..?

12045649 19-Oct-15 3:03am View

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script type="text/javascript">
function getdates() {
var today = new Date()

document.getElementById('Label1').innerHTML = [today.getDate(), today.getMonth() + 1, today.getFullYear()].join('/') + ' ' + [today.getHours(), today.getMinutes(), today.getSeconds()].join(':');
}
</script>
</head>
<body >
<form id="form1" runat="server">

<div>

<%--<label id="lbldateformat" />--%>
<asp:Label ID="Label1" runat="server" Text="Label">
<br />
<asp:Label ID="Label2" runat="server" Text="Label">
<br />
<asp:Button ID="btnsubmit" runat="server" Text="Submit" OnClick="btnsubmit_Click" />
<br />

</div>
</form>
</body>
</html>

.cs code

public partial class dateformat : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("server=ADMIN-PC\\SQLEXPRESS;database=rama;integrated security=true");

protected void Page_Load(object sender, EventArgs e)
{
Label2.Text = Label1.Text;
}
public void times()
{
string x = Label1.Text;
SqlCommand cmd = new SqlCommand("insert into times values(@x)", conn);
cmd.Parameters.AddWithValue("@x", x);
conn.Open();
int i= cmd.ExecuteNonQuery();
conn.Close();

if (i == 1)
{
Label2.Text = "Inserted";
}
else
{
Label2.Text = "Not Inserted";
}
}

protected void btnsubmit_Click(object sender, EventArgs e)
{
times();
}

}

I have used the following code ..It is not inserting into database..Can any one help me please..

12045649 15-Oct-15 3:32am View

Actually after giving mysql connection to sqldatasource....after selecting table .and after selecting test query ..it is showing message like..."could not create connection..object references not set to instances of object.." if there is image attachment i can show you..Can u help me with that error

12045649 14-Oct-15 5:29am View

kk i tried this code now.. how Can u send to database sql server which is in datetime format string

12045649 14-Oct-15 5:25am View

Sorry ...Acutally i am using javascript ..in asp.net source code..Now i want to convert var variable to datetime format because i need to send to database..

Comments by 12045649 (Top 31 by date)