Comments by ADI@345 - CodeProject

ADI@345 20-Jun-18 7:27am View

Sir, i have to check checkbox based on textbox value automatically.

ADI@345 20-Jun-18 7:27am View

List<string> term = new List<string>();

foreach (RepeaterItem item in Repeater1.Items)
{
CheckBoxList CheckBoxList1 = (CheckBoxList)item.FindControl("CheckBoxList1");
foreach (ListItem item1 in CheckBoxList1.Items)
{
if (item1.Selected == true)
{

term.Add(item.ToString());
TextBox1.Text = term.Count.ToString();

}

}

ADI@345 20-Jun-18 7:17am View

checkboxlist

ADI@345 29-May-18 7:55am View

i have solved this problem..

ADI@345 28-May-18 2:50am View

Plz reply

ADI@345 23-May-18 5:41am View

List<string> term = new List<string>();

foreach (RepeaterItem item in Repeater1.Items)
{
CheckBoxList CheckBoxList1 = (CheckBoxList)item.FindControl("CheckBoxList1");
foreach (ListItem item1 in CheckBoxList1.Items)
{
if (item1.Selected == true)
{
Label lblname = (Label)item.FindControl("Label1");
term.Add(lblname.Text);

}

}

}

Label5.Text = string.Join(" ", term.ToArray());
}

this is working , but how i get only distinct element.i mean remove duplicate element..

ADI@345 23-May-18 5:13am View

Deleted

how??

ADI@345 23-May-18 5:13am View

Deleted

List<string> term = new List<string>();
foreach (RepeaterItem item in Repeater1.Items)
{
CheckBoxList CheckBoxList1 = (CheckBoxList)item.FindControl("CheckBoxList1");
foreach (ListItem item1 in CheckBoxList1.Items)
{
if (item1.Selected == true)
{
Label lblname = (Label)item.FindControl("Label1");

term.Add(lblname.Text);

}

}

Label5.Text = term.ToString();
}

i am not getting label name if i use list

ADI@345 23-May-18 5:08am View

Deleted

sir i tried to add list but that didn't work..

ADI@345 9-May-18 4:18am View

Yes , this code work for me..thanks sir..

ADI@345 9-May-18 4:12am View

Deleted

Getting this error:
Unable to cast object of type 'System.Web.UI.WebControls.ListItem' to type 'System.Web.UI.WebControls.CheckBox'.

Using this code:
foreach (CheckBox checkbox in CheckBoxList1.Items)
{
if (checkbox.Checked)
{
using (SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
using (SqlCommand cmm = new SqlCommand())
{
cnn.Open();
cmm.Connection = cnn;
cmm.CommandType = CommandType.Text;

cmm.CommandText = "INSERT INTO[consult_sl otblock]([blockdate],[slotime])" + "VALUES(@blockdate,@slotime)";
cmm.Parameters.AddWithValue("@blockdate", TextBox1.Text.Trim());
cmm.Parameters.AddWithValue("@slotime", CheckBoxList1.SelectedItem.Text);

cmm.ExecuteNonQuery();
cnn.Close();
ScriptManager.RegisterStartupScript(this, GetType(), "Success", "alert('Information Save Successfully.');", true);
}
}
}

ADI@345 9-May-18 3:09am View

yes i have to insert multiple for checked checkbox

ADI@345 4-May-18 4:19am View

Nothing work for me.. Please reply what should i do.

ADI@345 4-May-18 4:05am View

Deleted

Nothing works for me, i have made lots of changes ..

<?xml version="1.0"?>

<configuration>

<connectionstrings>
//

<appsettings>
<add key="ChartImageHandler" value="storage=file; timeout=20;"/>

<system.web>

<machineKey validationKey="2BB9D82595A3B72D2D7455D16AF8139F68B45CD38D34530DC6BD390C3523F985F8290CA1058CAFCE6CEC4A553DCBE6AB7E4D25E81DDB786E699B15F7E32D0417,IsolateApps"
decryptionKey="D45FF3DC542E9C04454E5B94EA189513C41766FA383BE60B,IsolateApps" validation="SHA1" />

<pages enableViewStateMac="true"/>

<sessionState timeout="50"/>
<customErrors mode="Off"/>

<compilation debug="true" targetFramework="4.0">
<assemblies>
<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<authentication mode="Forms">
<forms loginUrl="Login.aspx"/>



<membership>
<providers>
<clear>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/"/>

<profile>
<providers>
<clear>
<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>

<roleManager enabled="false">
<providers>
<clear>
<add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/"/>
<add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/"/>

<system.webserver>
<validation validateIntegratedModeConfiguration="false"/>
<httphandlers>
<add path="ChartImg.axd" verb="GET,HEAD,POST" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false" />

<defaultDocument enabled="true">
<files>
<clear>
<add value="Login.aspx"/>

<modules runAllManagedModulesForAllRequests="true"/>

ADI@345 4-May-18 3:55am View

IIS 7.5

yes i have add chart assembly too in my application

ADI@345 4-May-18 3:02am View

Pls provide some solution

ADI@345 2-Apr-18 2:06am View

Thanks sir

ADI@345 29-Mar-18 7:44am View

sir, i did this work .. thanks for your help..

ADI@345 29-Mar-18 6:00am View

i use repeater to fetch table from database inside productbind() function.. and call productbind() to get record.

ADI@345 29-Mar-18 5:55am View

productbind is a function

ADI@345 29-Mar-18 5:17am View

yes i have to iterate row but coming from database..

ADI@345 29-Mar-18 5:04am View

for example i have table that is coming from database inside repeater for this i made a function and call, but at the time of creating pdf, i am unable to call function to create table ..
here productbind(); is a function ..

ADI@345 15-Jan-18 4:49am View

oky finally it work thanks..

ADI@345 15-Jan-18 4:41am View

how can i debug my code on server , it work fine on localhost.

ADI@345 15-Jan-18 4:35am View

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

string userid = GVmydsr.DataKeys[e.RowIndex].Value.ToString();
GridViewRow row = (GridViewRow)GVmydsr.Rows[e.RowIndex];
Label date = (Label)row.FindControl("lblcurrentdate");

string cdate = date.Text.ToString();
DateTime date1 = DateTime.MinValue;
DateTime.TryParseExact(cdate.Split(' ')[0], new string[] {"MM/dd/yyyy"}, null, System.Globalization.DateTimeStyles.None, out date1);
DateTime dt1 = date1;

GVmydsr.EditIndex = -1;

DateTime dt2 = DateTime.Today.Date;
if (dt1 == dt2)

{
//my code
}

else
{
ScriptManager.RegisterStartupScript(this, GetType(), "Success", "alert('Cannot Edit !!!.');", true);
gvbind();
}

sir i replace my code with your code .but again facing same issue.
here, dt1 and dt2 both are datetime..

ADI@345 15-Jan-18 4:22am View

server date format is different from localhost, that why i am not able to find server current date format..I am trying all format but isn't working anyone..

ADI@345 15-Jan-18 4:09am View

i made change but it work only on localhost not on server..

ADI@345 15-Jan-18 1:11am View

void recordbind()
{

if (Session["adminhome"] != null)
{

lblSales.Text = Session["adminhome"].ToString();

}

SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
cnn.Open();
SqlCommand comm = new SqlCommand();
string quiry = "BEGIN TRY " +
"BEGIN TRANSACTION " +
"INSERT INTO [dsr_data]([session_name],[currentdate],[client_type],[date_time],[tme],[area],[company_name],[client_name],[mobile],[email],[address_name],[landmark],[curr_presence_appoint],[status_type],[result],[comment])";

if (ddlctype.Text != "Select")
{
quiry += " select '" + lblSales.Text + "', '" + lbldate.Text + "', '" + ddlctype.Text.Trim() + "','" + txtDate.Text.Trim() + "','" + ddltme.Text.Trim() + "','" + txtarea.Text.Trim() + "','" + txtcname.Text.Trim() + "','" + txtclientname.Text.Trim() + "', '" + txtmobile.Text.Trim() + "','" + txtemail.Text.Trim() + "','" + txtaddress.Text.Trim() + "','" + txtlandmark.Text.Trim() + "','" + txtcurr.Text.Trim() + "','" + ddlstatus.Text.Trim() + "','" + ddlresult.Text.Trim() + "','" + txtcomment.Text.Trim() + "'";
}

if (DropDownList1.Text != "Select")

quiry += " COMMIT TRANSACTION " +
"END TRY " +
"BEGIN CATCH " +
"ROLLBACK TRANSACTION " +
" END CATCH";

comm.Connection = cnn;
comm.CommandType = CommandType.Text;
comm.CommandText = quiry;

try
{

comm.ExecuteNonQuery();
ScriptManager.RegisterStartupScript(this, GetType(), "Success", "alert('Information Save Successfully.');", true);

}

catch (Exception ex)
{
Response.Write(ex.Message);
}

}

ADI@345 15-Jan-18 0:07am View

Actually what happen, my code work fine on my PC, but if run on another PC,i face this error not always , but sometime..Initially session is not null, i send name and email in session.

ADI@345 12-Jan-18 2:03am View

I am using sql server 2008..
My question is to show record of first to last date of current month in sql

ADI@345 11-Jan-18 6:37am View

I am able to show record in table on dropdown index change but again i select another value in dropdown, previous value remain in table, i need to remove previous value.

ADI@345 8-Jan-18 4:48am View

Thanks , it work for me by changing 25 to 587..

ADI@345 8-Jan-18 3:50am View

when i ping my host IP address , i got request timed out..

ADI@345 4-Jan-18 5:47am View

Thanks for help

ADI@345 4-Jan-18 5:45am View

i made changes , this code works for me online..

ADI@345 4-Jan-18 5:45am View

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

string userid = GVmydsr.DataKeys[e.RowIndex].Value.ToString();
GridViewRow row = (GridViewRow)GVmydsr.Rows[e.RowIndex];
Label date = (Label)row.FindControl("lblcurrentdate");

string cdate = date.Text.ToString();
DateTime date1 = DateTime.MinValue;
DateTime.TryParseExact(cdate.Split(' ')[0], new string[] { "MM-dd-yyyy", "d/M/yyyy" }, null, System.Globalization.DateTimeStyles.None, out date1);

string dt1 = date1.ToString("d/M/yyyy 00:00:00");

GVmydsr.EditIndex = -1;

string dt2 = DateTime.Today.ToString("d/M/yyyy 00:00:00");

if (dt1 == dt2)
{

ScriptManager.RegisterStartupScript(this, GetType(), "Success", "alert('Update Successfully!!!.');", true);
gvbind();
}

else
{
ScriptManager.RegisterStartupScript(this, GetType(), "Success", "alert('Cannot Edit !!!.');", true);
gvbind();
}
}

ADI@345 4-Jan-18 5:41am View

i apply all this , but it work fine on localhost , but not on server

ADI@345 4-Jan-18 5:31am View

I am getting date in this format offline - 01-04-2018 00:00:00
but after uploading it, get convert into - 01/04/2018 00:00:00

ADI@345 4-Jan-18 1:53am View

finally it move inside loop, thanks a lot for your help..

ADI@345 4-Jan-18 1:49am View

I am getting this :
dt1 ="04-01-2018 00:00:00"
dt2 ="01-04-2018 00:00:00"

string userid = GVmydsr.DataKeys[e.RowIndex].Value.ToString();
GridViewRow row = (GridViewRow)GVmydsr.Rows[e.RowIndex];
Label date = (Label)row.FindControl("lblcurrentdate");

string cdate = date.Text.ToString();
DateTime date1 = DateTime.ParseExact(cdate, "MM-dd-yyyy 00:00:00", null);
string dt1 = date1.ToString();

string dt2 = DateTime.Today.ToString("MM-dd-yyyy 00:00:00");
if (dt1 == dt2)
{
//

}

ADI@345 4-Jan-18 1:44am View

i solve this error, but doensont go inside loop.. I send you my code..
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

string userid = GVmydsr.DataKeys[e.RowIndex].Value.ToString();
GridViewRow row = (GridViewRow)GVmydsr.Rows[e.RowIndex];

//string date = GVmydsr.Rows[e.RowIndex].Cells[1].Text;
Label date = (Label)row.FindControl("lblcurrentdate");

string cdate = date.Text.ToString();
DateTime date1 = DateTime.ParseExact(cdate, "MM-dd-yyyy 00:00:00", null);
string dt1 = date1.ToString();

GVmydsr.EditIndex = -1;

string day = DateTime.Today.ToString("MM-dd-yyyy");
if (dt1 == day)
{
con.Open();
//
cmd.ExecuteNonQuery();
con.Close();

gvbind();
}

ADI@345 4-Jan-18 1:39am View

getting error in this line
DateTime date1 = DateTime.ParseExact(cdate.Split(' ')[0], "MM-dd-yyyy", null);
String was not recognized as a valid DateTime.

ADI@345 4-Jan-18 1:32am View

String was not recognized as a valid DateTime.
//string date = GVmydsr.Rows[e.RowIndex].Cells[1].Text;
Label date = (Label)row.FindControl("lblcurrentdate");
string cdate = date.ToString();
DateTime date1 = DateTime.ParseExact(cdate.Split(' ')[0], "MM-dd-yyyy", null);
string dateDB = date1.ToString("MM-dd-yyyy");

string day = DateTime.Today.ToString("MM-dd-yyyy");

if (dateDB == day)
{
////
}

ADI@345 4-Jan-18 1:17am View

Label date = (Label)row.FindControl("lblcurrentdate");
i am using label to get date from database.., and then comparing system date with database date from label..

ADI@345 4-Jan-18 1:14am View

sir, i got same result on date and day, but even if both are same, it does not go inside loop..

ADI@345 4-Jan-18 1:08am View

oky

ADI@345 4-Jan-18 1:04am View

"01-04-2018 00:00:00"

ADI@345 15-Nov-17 4:21am View

i think my code work..i solved this issue..Thanks a lot...

ADI@345 15-Nov-17 4:19am View

Deleted

but sir still face a issue when all item less than current system date time get disable ..but no any disable .

ADI@345 15-Nov-17 4:12am View

sir i change HH to hh , it works fine..

ADI@345 15-Nov-17 4:03am View

Finally it work , but give error in this time slot "1:00PM"

ADI@345 15-Nov-17 3:39am View

sir there is no option in codeproject to post screenshot..

ADI@345 15-Nov-17 3:39am View

S= "9:00AM |9:15AM |9:30AM |9:45AM |10:00AM |10:15AM |10:30AM|10:45AM|11:00AM|11:15AM|11:30AM|11:45AM|12:00PM|12:15PM|12:30PM|12:45PM|1:00PM|1:15PM|1:30PM|1:45PM|2:00PM|2:15PM|2:30PM|2:45PM"

ADI@345 15-Nov-17 3:02am View

same issue

ADI@345 15-Nov-17 3:01am View

actually i made changes by using google help..

ADI@345 15-Nov-17 2:53am View

9:00AM

ADI@345 15-Nov-17 2:52am View

<asp:RadioButtonList ID="RadioButtonList1" runat="server" Width="100%" CssClass="rbl" RepeatColumns="2" RepeatLayout="Flow" RepeatDirection="Horizontal" >

<asp:ListItem Text="9:00AM" >9:00AM
<asp:ListItem Text="9:15AM">9:15AM
<asp:ListItem Text="9:30AM">9:30AM
<asp:ListItem Text="9:45AM">9:45AM

<asp:ListItem Text="10:00AM">10:00AM
<asp:ListItem Text="10:15AM">10:15AM
<asp:ListItem Text="10:30AM" >10:30AM
<asp:ListItem Text="10:45AM">10:45AM

ADI@345 15-Nov-17 2:45am View

i am getting error initially after entering to the loop for first item

ADI@345 15-Nov-17 2:37am View

in dt i am getting this when i run separately {15-11-2017 09:00:00}

ADI@345 15-Nov-17 2:35am View

I actually dont know why i am not getting this, i read everywhere in google for this..i dont what mistake i made here...

ADI@345 15-Nov-17 2:33am View

yes, but in dt= 01-01-0001 00:00:00

ADI@345 15-Nov-17 2:28am View

i am using this line but the getting same error.

ADI@345 15-Nov-17 2:25am View

string id = Request.QueryString["id"];
txtdate.Text = Calendar1.SelectedDate.ToShortDateString();
Calendar1.Visible = false;

// DateTime txtMyDate = DateTime.Parse(txtdate.Text);
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date and doc_id='" + id + "'";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.AddWithValue("@date", txtdate.Text);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
string[] slots = dtAdmin.Rows.OfType<datarow>().Select(k => k["slot"].ToString()).ToArray();

foreach (ListItem item in RadioButtonList1.Items)
{

DateTime dt= DateTime.ParseExact(item.Text, "h:mm tt" , CultureInfo.InvariantCulture);

if (slots.Contains(item.Text) && DateTime.Now >dt)
{

item.Enabled = false;

}
else
{
item.Enabled = true;

}

}
}

In dt , i am getting {01-01-0001 00:00:00}..

ADI@345 15-Nov-17 2:14am View

still i am getting the same error.. String was not recognized as a valid DateTime.

ADI@345 15-Nov-17 1:58am View

String was not recognized as a valid DateTime.
again getting same error.

my radibutton listitem contain:
<asp:ListItem Text="9:00 AM" >9:00 AM
<asp:ListItem Text="9:15 AM">9:15 AM
<asp:ListItem Text="9:30 AM">9:30 AM
<asp:ListItem Text="9:45 AM">9:45 AM

ADI@345 15-Nov-17 1:53am View

what would be correct solution..

ADI@345 15-Nov-17 1:53am View

foreach (ListItem item in RadioButtonList1.Items)
{
DateTime dt = DateTime.Parse(item.Text);

if (slots.Contains(item.Text) && DateTime.Now.ToString("HH:mm tt")>dt)
{

item.Enabled = false;

}

i am using this code but again getting error..operator > cannot be applied to operands of type 'string' and 'system.datetime'

ADI@345 15-Nov-17 1:49am View

In dt = 01-01-0001 00:00:00 value i am getting and item.text="9:00 AM"

ADI@345 15-Nov-17 1:45am View

DateTime dt = DateTime.ParseExact(item.Text, "HH:mm tt", CultureInfo.CurrentCulture);

GETTING ERROR IN THIS LINE..
String was not recognized as a valid DateTime.

ADI@345 15-Nov-17 1:41am View

item.Enabled = DateTime.Now.ToString("HH:mm tt") > dt;

i need only hour and minute but datetime.now format is different .i am using above code but getting error.

ADI@345 15-Nov-17 1:00am View

foreach (ListItem item in RadioButtonList1.Items)
if (slots.Contains(item.Text) && Convert.ToInt32(item.Text) < Convert.ToInt32(time)) i am getting error in this line only ..

ADI@345 10-Nov-17 2:30am View

finally i know why i get this error..thanks

ADI@345 10-Nov-17 1:58am View

It work fine on localhost but getting error on server.

ADI@345 10-Nov-17 1:58am View

so what would be the code for catch block..

ADI@345 8-Nov-17 3:18am View

oky thank you sir for help..

ADI@345 8-Nov-17 3:05am View

Thanks a lot sir, finally my code work as per my requirement. but i didn't understand this code..
string[] slots = dtAdmin.Rows.OfType<datarow>).Select(k=>k["slot"].ToString()).ToArray();

ADI@345 8-Nov-17 2:36am View

oky

ADI@345 8-Nov-17 2:18am View

Now my code work fine, thanks for help but still facing some problem. i.e if i have two slot in my database then it will disable two radiobutton listitem , right now only single listitem get disable.

txtdate.Text = Calendar1.SelectedDate.ToString();
DateTime txtMyDate = DateTime.Parse(txtdate.Text);
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.AddWithValue("@date", txtMyDate);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
if (item.Text == dtAdmin.Rows[0]["slot"].ToString())
{

item.Enabled = false;
}

else
item.Enabled = true;
}

this code work fine , but it disable only one time slot even if i have two two time slot in my database

ADI@345 8-Nov-17 1:54am View

txtdate.Text = Calendar1.SelectedDate.ToString();
DateTime txtMyDate = DateTime.Parse(txtdate.Text);
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.AddWithValue("@date", txtMyDate);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
{
if(item.Text == dtAdmin.Rows[0]["slot"].ToString())
{

RadioButtonList1.Items[0].Enabled = false;
}

else
{
RadioButtonList1.Items[0].Enabled = true;
}
}
}
after parsing date , it work fine but doesnot disable radiobutton selected listitem..

ADI@345 8-Nov-17 0:50am View

My design :-
<asp:RadioButtonList ID="RadioButtonList1" runat="server" Width="100%">

<asp:ListItem Text="9:00 AM" Value="1">9:00 AM
<asp:ListItem Text="9:15 AM" Value="2">9:15 AM
<asp:ListItem Text="9:30 AM" Value="3">9:30 AM
<asp:ListItem Text="9:45 AM" Value="4">9:45 AM

<asp:ListItem Text="10:00 AM" Value="5">10:00 AM
<asp:ListItem Text="10:15 AM" Value="6">10:15 AM
<asp:ListItem Text="10:30 AM" Value="7">10:30 AM
<asp:ListItem Text="10:45 AM" Value="8">10:45 AM

<asp:ListItem Text="11:00 AM" Value="9">11:00 AM
<asp:ListItem Text="11:15 AM" Value="10">11:15 AM
<asp:ListItem Text="11:30 AM" Value="11">11:30 AM
<asp:ListItem Text="11:45 AM" Value="12">11:45 AM

<asp:ListItem Text="12:00 PM" Value="13">12:00 PM
<asp:ListItem Text="12:15 PM" Value="14">12:15 PM
<asp:ListItem Text="12:30 PM" Value="15">12:30 PM
<asp:ListItem Text="12:45 PM" Value="16">12:45 PM

<asp:ListItem Text="1:00 PM" Value="17">1:00 PM

Code:-
txtdate.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.AddWithValue("@date", txtdate.Text);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
{
if(item.Text == dtAdmin.Rows[0]["slot"].ToString())
{

item.Enabled = item.Text == dtAdmin.Rows[0]["slot"].ToString();
}

}
}

i dont know my mistake.. when i debug it doesnot count any row from database, thats why it doenot move inside if(dtAdmin.Rows.Count >0)..

ADI@345 8-Nov-17 0:38am View

txtdate.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate = @date";
SqlCommand cmd = new SqlCommand(Query, cnn);
cmd.Parameters.Add("@date", txtdate.Text);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da;
da = new SqlDataAdapter(cmd);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
{
if(item.Text == dtAdmin.Rows[0]["slot"].ToString())
{

RadioButtonList1.Items[0].Enabled = false;
}

else
{
RadioButtonList1.Items[0].Enabled = true;
}
}
}

i change my code but in dtAdmin.Rows.Count >0 it doesnot count , alwys show 0,but i have one record in my database

ADI@345 8-Nov-17 0:15am View

how can i disable radiobuttonlist 2 or 3 listitem based on database condition..

ADI@345 8-Nov-17 0:14am View

txtdate.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "select slot from appoint where selectdate =@date";
DataTable dtAdmin = new DataTable();
SqlDataAdapter da;
da = new SqlDataAdapter(Query, cnn);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
foreach (ListItem item in RadioButtonList1.Items)
{
if (item.Text == Query)
{

item.Enabled = false;
}

else
{
item.Enabled = true;
}
}
}

ADI@345 3-Nov-17 6:30am View

thanku. my code now works..

ADI@345 3-Nov-17 5:18am View

i cant understand actually, please tell me where in my code i have to change for BCC

ADI@345 2-Nov-17 2:54am View

Yes i forget to use IN clause ..now it work.. thanks

ADI@345 2-Nov-17 2:49am View

sir actually what happen , when we select two item from listbox , it work fine with one item but with two item
SELECT * FROM [dsr_data] where date_time between '11/1/2017' and '11/30/2017' And session_name='abc','efg'
this query doesnot give any output in sql server..

ADI@345 2-Nov-17 2:42am View

protected void searchname_date()
{
List<string> lstSelectedItems = new List<string>();

if (ListBox1.Items.Count > 0)
{
for (int i = 0; i < ListBox1.Items.Count; i++)
{
if (ListBox1.Items[i].Selected)
{
lstSelectedItems.Add(ListBox1.Items[i].Text);

string inQuery = string.Join("','", lstSelectedItems);
inQuery = "'" + inQuery + "'";

SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Query = "SELECT * FROM [dsr_data] where (date_time between '" + TextBox1.Text + "' and '" + TextBox4.Text + "') And session_name='" + inQuery + "'";
Query = string.Format(Query, inQuery);
DataTable dtAdmin = new DataTable();
SqlDataAdapter da;
da = new SqlDataAdapter(Query, cnn);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
GVmydsr.DataSource = dtAdmin;
GVmydsr.DataBind();

}
else
{
GVmydsr.DataSource = null;
GVmydsr.DataBind();
}

}

}
}
}

ERROR :-
Deepali is one the name of item of listbox.
Incorrect syntax near 'Deepali'.
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.Data.SqlClient.SqlException: Incorrect syntax near 'Deepali'.

ADI@345 2-Nov-17 2:33am View

still facing same issue, only last record of listbox item shown

ADI@345 31-Oct-17 6:37am View

i also solve the above that i ask , leave it thanks..

ADI@345 31-Oct-17 6:35am View

how to get data between two date :

void gvbind()
{

string Query = "SELECT * FROM [dsr_data] WHERE date_time between date_time '"+TextBox1.Text+"' and date_time '"+TextBox4.Text+"'";
DataTable dtAdmin = new DataTable();
SqlDataAdapter da;
da = new SqlDataAdapter(Query, cnn);
da.Fill(dtAdmin);
if (dtAdmin.Rows.Count > 0)
{
GVmydsr.DataSource = dtAdmin;
GVmydsr.DataBind();

}
else
{
GVmydsr.DataSource = null;
GVmydsr.DataBind();
}
}

ADI@345 31-Oct-17 4:47am View

but is there any way to remove time from datetime.

ADI@345 31-Oct-17 4:45am View

Deleted

Thanks sir..

ADI@345 31-Oct-17 4:44am View

thanks sir for your suggestion , i will do this and i solved this problem ..my code now work fine..

ADI@345 31-Oct-17 4:13am View

i thought this is the problem ...

ADI@345 31-Oct-17 4:13am View

here on datetime data save as YYYY-MM-DD
but on getdate() format i get as YYYY-DD-MM

ADI@345 31-Oct-17 3:52am View

CREATE TABLE [dbo].[dsr_data](
[client_type] [varchar](100) NULL,
[date_time] datetime NULL,
[tme] [varchar](100) NULL,
[area] [varchar](100) NULL,
[company_name] [varchar](100) NULL,
[client_name] [varchar](100) NULL,
[mobile] [varchar](100) NULL,
[email] [varchar](100) NULL,
[address_name] [varchar](100) NULL,
[landmark] [varchar](100) NULL,
[curr_presence_appoint] [varchar](100) NULL

) ON [PRIMARY]

ADI@345 31-Oct-17 3:20am View

i am using the same code but didn't work

ADI@345 31-Oct-17 3:14am View

now i change nvarchar to datetime , and using this query but didn't work.

select date_time from dsr_data where date_time >= DATEADD(DAY,-30,GETDATE()) and
date_time <= getdate()

ADI@345 30-Oct-17 7:15am View

Thanks sir , but i have done this using my logic..

ADI@345 30-Oct-17 5:43am View

there is no option to add screenshot..
actually the real problem i am facing is that , i have 7 row each , each row contain 3 dropdown and 10 textbox and on single button click all data store in database and also send to mail . but on sending mail if i fill 2 row then only two row send to mail not all..how can i do this..

ADI@345 30-Oct-17 5:08am View

please reply me

ADI@345 30-Oct-17 4:43am View

static rows

ADI@345 30-Oct-17 3:42am View

ASP.net

ADI@345 30-Oct-17 3:41am View

one table with seven rows

ADI@345 15-Mar-17 3:12am View

Actually, I solved that problem. This is another problem that I am facing right now.

ADI@345 12-Oct-16 12:02pm View

I know the concept of generating scripts, actually my requirements is not to generate scripts.. i want my database run on another system without sql server setup installation.. How will I do this.. Pls reply

ADI@345 19-Sep-16 9:39am View

I am using information provided by you , but one thing i want to know that i again need to declare data in array1 during serial write communication
array1.Add(1);
array1.Add(666);
array1.Add(int.MaxValue);
byte[] data = array1.SelectMany(BitConverter.GetBytes).ToArray();

ADI@345 19-Sep-16 9:37am View

Deleted

..

ADI@345 19-Sep-16 1:01am View

As per my query, i don't get any proper answer from your side.. i am still confuse how to call my array in serial write port .. if u know please reply, its urgent for me ....

ADI@345 18-Sep-16 9:18am View

Actually i am unable to post my whole code here...

ADI@345 18-Sep-16 9:17am View

These all information i declare in an array named array1 ,then calling that array1 in serial write port
public void write(string text)
{
SerialPort mySerialPort = new SerialPort();
try
{
mySerialPort.PortName = comboBox6.Text;
mySerialPort.BaudRate = Convert.ToInt32(comboBox7.Text);
mySerialPort.Open();

byte[] buffer = array1;
mySerialPort.Write(buffer, 0, buffer.Length);

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
mySerialPort.Close();

}

ADI@345 18-Sep-16 9:15am View

Deleted

..

ADI@345 18-Sep-16 9:13am View

Deleted

List

ADI@345 18-Sep-16 9:09am View

Deleted

i am unable to post my code here..

ADI@345 17-Sep-16 14:19pm View

byte[] buffer = new byte[array1]; //
how will i correct this line.. here array1 is in int.. array1 contains my record which i have to write .. so whether i have to convert this array1 into string..

ADI@345 17-Sep-16 14:15pm View

Deleted

..

ADI@345 17-Sep-16 14:11pm View

Deleted

..

ADI@345 17-Sep-16 12:13pm View

byte[] byteArray = new byte[array1];
//This code give error :-
cannot implicitly convert type 'system.collections.generic.list

ADI@345 17-Sep-16 11:36am View

Deleted

public void processByte(byte data)
{
SerialPort mySerialPort = new SerialPort();
try
{
mySerialPort.PortName = comboBox6.Text;
mySerialPort.BaudRate = Convert.ToInt32(comboBox7.Text);
mySerialPort.Open();
byte[] byteArray = array1;// your byte data;
mySerialPort.Write(byteArray, 0, array1);

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
mySerialPort.Close();

}

ADI@345 17-Sep-16 11:29am View

Please let me know whether i will write my array of record in serial port.

ADI@345 17-Sep-16 11:22am View

i am unable to send my code here..

ADI@345 17-Sep-16 11:10am View

how will i convert bytes or character first.

ADI@345 17-Sep-16 10:54am View

I have my data in array for which i declare array1 here , this array1 includes my information that i have to write . I simply needs to write this array1 in serial write port.

ADI@345 17-Sep-16 10:49am View

Deleted

Please reply me

ADI@345 17-Sep-16 10:47am View

I am unable to post my code here..

ADI@345 17-Sep-16 10:38am View

Actually i want to know that,
List array1 = new List();
I have to write this array1 in serialWrite

ADI@345 17-Sep-16 10:18am View

where i have to call my array ..

ADI@345 9-Sep-16 10:02am View

please give solution

ADI@345 18-Jul-16 2:58am View

I am using above code provided by you but this is giving error,

ExecuteReader requires an open and available Connection. The connection's current state is closed.

how to solve this issue..

ADI@345 18-Jul-16 2:34am View

how could i merge both query ...

Actually i have to do this
when number of book present in the database is 0 then show "No Book Is Available " message otherwise if value is 5 then decrement the counter one by one ..

ADI@345 18-Jul-16 2:22am View

NoOfBook is Saved in database that is Int .
I am usng this code
string quiry1 = "select NoOfBook from BookEntry where AccessionNo='" + comboBox2.Text + "' and NoOfBook <=0";

This code gives record 0 .

and

string update = "UPDATE [BookEntry] SET [NoOfBook] = [NoOfBook] - 1 WHERE AccessionNo = '" + comboBox2.Text + "' And NoOfBook >0";
this code decrement NoOfbook greater than 0

but i am not able to combine of these query

ADI@345 9-Sep-14 7:06am View

when we click on submit button,error come:

"; echo $error."

"; echo "Please go back and fix these errors.

"; die(); } // validation expected data exists if(!isset($_POST['first_name']) || !isset($_POST['last_name']) || !isset($_POST['email']) || !isset($_POST['telephone']) || !isset($_POST['comments'])) { died('We are sorry, but there appears to be a problem with the form you submitted.'); } $first_name = $_POST['first_name']; // required $last_name = $_POST['last_name']; // required $email_from = $_POST['email']; // required $telephone = $_POST['telephone']; // not required $comments = $_POST['comments']; // required $error_message = ""; $email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/'; if(!preg_match($email_exp,$email_from)) { $error_message .= 'The Email Address you entered does not appear to be valid.
'; } $string_exp = "/^[A-Za-z .'-]+$/"; if(!preg_match($string_exp,$first_name)) { $error_message .= 'The First Name you entered does not appear to be valid.
'; } if(!preg_match($string_exp,$last_name)) { $error_message .= 'The Last Name you entered does not appear to be valid.
'; } if(strlen($comments) < 2) { $error_message .= 'The Comments you entered do not appear to be valid.
'; } if(strlen($error_message) > 0) { died($error_message); } $email_message = "Form details below.\n\n"; function clean_string($string) { $bad = array("content-type","bcc:","to:","cc:","href"); return str_replace($bad,"",$string); } $email_message .= "First Name: ".clean_string($first_name)."\n"; $email_message .= "Last Name: ".clean_string($last_name)."\n"; $email_message .= "Email: ".clean_string($email_from)."\n"; $email_message .= "Telephone: ".clean_string($telephone)."\n"; $email_message .= "Comments: ".clean_string($comments)."\n"; // create email headers $headers = 'From: '.$email_from."\r\n". 'Reply-To: '.$email_from."\r\n" . 'X-Mailer: PHP/' . phpversion(); @mail($email_to, $email_subject, $email_message, $headers); ?> Thank you for contacting us. We will be in touch with you very soon.

ADI@345 13-Aug-14 6:53am View

No

ADI@345 31-May-14 1:12am View

protected void btnlast_Click(object sender, EventArgs e)
{
pos = adsource.PageCount - 1;
Recordbind();

I am facing problem in last button

ADI@345 27-May-14 11:21am View

I am trying to save all checked item of treeview in database but,i am keeping treeview in modalpopupextender,thts why I am unable to save any item of treeview in database on button click.

ADI@345 27-May-14 10:57am View

okay i am posting again

ADI@345 25-May-14 3:47am View

on button click event i am trying to insert username using hidden field

ADI@345 25-May-14 2:19am View

pls reply me soon.Thanks in advance.

ADI@345 22-May-14 5:46am View

I have not any idea how to search friend, or how to send friend request and how to browse friend..

ADI@345 10-May-14 3:21am View

In verificationpage.aspx page contain what????

ADI@345 10-May-14 3:20am View

i have facing problem using this code,pls help me

ADI@345 30-Apr-14 3:06am View

thanks a lot,but now i have solve this issue...

ADI@345 30-Apr-14 2:38am View

pls reply

ADI@345 30-Apr-14 2:26am View

but sir in sql databse we have alread assign id is int.

ADI@345 30-Apr-14 2:23am View

objParamater.DbType = DbType.VarChar;
we have getting error in varchar

ADI@345 30-Apr-14 2:17am View

yes,i am getting same error again

ADI@345 30-Apr-14 1:45am View

actualy i have made two folder,first admin,and second website,when we insert data on admin panel,related data will fetch on website using dropdownbox.

ADI@345 30-Apr-14 1:44am View

i have using this,but isn't wrking,,same error arise

ADI@345 30-Apr-14 1:38am View

we are pasing aiee2010 in dropdownbox

ADI@345 30-Apr-14 1:37am View

aiee2010

ADI@345 30-Apr-14 1:33am View

but i have to fetch data through id..i.e value

ADI@345 30-Apr-14 1:32am View

returning value is text not value..

ADI@345 30-Apr-14 1:25am View

YES ,I AM GETTING THE SAME ERROR..

ADI@345 30-Apr-14 1:23am View

I HAVE ALREADY CHANGE TEXT INTO VALUE,BUT ISN'T WORK...

ADI@345 30-Apr-14 1:12am View

public DataSet FetchDataById(int uid, int id)
{

DataAccess objDataAccess;
DataSet objResult;
objDataAccess = new DataAccess();
List<dbparameter> objArrayList;
DbParameter objParamater;
objArrayList = new List<dbparameter>();

objParamater = objDataAccess.NewParameter();
objParamater.ParameterName = "@uid";
objParamater.DbType = DbType.Int32;
objParamater.Direction = ParameterDirection.Input;
objParamater.Value = uid;
objArrayList.Add(objParamater);

objParamater = objDataAccess.NewParameter();
objParamater.ParameterName = "@id";
objParamater.DbType = DbType.Int32;
objParamater.Direction = ParameterDirection.Input;
objParamater.Value = id;
objArrayList.Add(objParamater);

objResult = objDataAccess.ExecuteQuery("AieeeProc", objArrayList.ToArray());
return objResult;
}

ADI@345 30-Apr-14 1:06am View

ds = il.FetchDataById(2, Convert.ToInt32(DDLAieee.SelectedItem.Value));

i am already used this code..but not working..

ADI@345 30-Apr-14 0:45am View

pls reply me soon

ADI@345 29-Apr-14 12:47pm View

in dropdown text contain both string aur integer value.like Aieee2010

ADI@345 29-Apr-14 6:45am View

Fetchdatabyid take two arguments,i.e
(int uid,int id)
in the place of uid,i am using 2,but in the place of id..what should i have to used????
please clear me..

ADI@345 29-Apr-14 6:43am View

we have getting error only in this line pls correct this line:
error:-
ds = il.FetchDataById(4, Convert.ToInt32(DDLAieee.SelectedItem.Text));

ADI@345 29-Apr-14 6:13am View

sir,i have to fetch all data when we select any item of dropdownn using store procedure.but we have getting error i.e input string is not in correct format..

ADI@345 29-Apr-14 6:10am View

pls help me...

ADI@345 29-Apr-14 6:09am View

Input string was not in a correct format.
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.FormatException: Input string was not in a correct format.

Source Error:

Line 37: {
Line 38: DataSet ds = new DataSet();
Line 39: ds = il.FetchDataById(2, Convert.ToInt32(DDLAieee.SelectedItem.Text));
Line 40: if (ds.Tables[0].Rows.Count > 0)
Line 41: {

Source File: C:\Users\ADI\Documents\Visual Studio 2010\Projects\Fobbs\Fobbs\Eng1.aspx.cs Line: 39

ADI@345 29-Apr-14 5:43am View

sir,autopostback property was not true,but after we do true,then error comes:
DataSet ds = new DataSet();
Line 39: ds = il.FetchDataById(2, Convert.ToInt32(DDLAieee.SelectedItem.Text));
Line 40: if (ds.Tables[0].Rows.Count > 0)
Line 41: {
Line 42: txtdescription.Text = ds.Tables[0].Rows[0][1].ToString();

ADI@345 29-Apr-14 5:39am View

Deleted

<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="Eng1.aspx.cs" Inherits="Fobbs.Eng1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

<style type="text/css">

#nav {
border: 3px solid #F1F9FB;

}
#nav, #nav ul {
list-style: none outside none;
padding: 0;
width: 200px;
}
#nav ul {
position: relative;
z-index: -1;
}
#nav li {
position: relative;
z-index: 100;
}
#nav ul li {
margin-top: -25px;
transition: all 0.4s linear 0.4s;
}
#nav li a {
background-color: #FFFFFF;
color: #000000;
display: inherit;
font-size: 16px;
font-weight: bold;
line-height: 54px;
outline: 0 none;
padding-left: 39px;
text-decoration: none;
}
#nav li a.sub {
background: none no-repeat scroll 0 0 #F9F7F7;
}
#nav li a + img {
cursor: pointer;
display: none;
height: 28px;
left: 0;
position: absolute;
top: 0;
width: 200px;
}
#nav li a img {
border-width: 0;
height: 40px;
line-height: 28px;
margin-right: 8px;
vertical-align: middle;
width: 24px;
}
#nav li a:hover {
background-color: #BCBDC1;
}
#nav ul li a {
background-color: #EEEEEE;
border-bottom: 1px solid #CCCCCC;
color: #000000;
font-size: 17px;
line-height: 22px;
}
#nav ul li a:hover {
background-color: #DDDDDD;
color: #444444;
}
#nav ul li a img {
background: none no-repeat scroll 0 0 transparent;
border-width: 4px;
height: 21px;
line-height: 22px;
margin-right: 5px;
vertical-align: middle;
width: 16px;
}
#nav ul li:nth-child(2n+1) a img {
background: none no-repeat scroll 0 0 transparent;
}
#nav a.sub:focus {
background: none repeat scroll 0 0 #BCBDC1;
outline: 0 none;
}
#nav a:focus ~ ul li {
margin-top: 0;
transition: all 0.4s linear 0s;
}
#nav a:focus + img, #nav a:active + img {
display: block;
}
#nav a.sub:active {
background: none repeat scroll 0 0 #BCBDC1;
outline: 0 none;
}
#nav a:active ~ ul li {
margin-top: 0;
}
#nav ul:hover li {
margin-top: 0;
}
.style13
{
width: 10px;
}
.style14
{
width: 5px;
background-color: #996633;
height: 405px;
}
.style15
{
height: 385px;
}
.style17
{
font-size: large;
}
.style19
{
font-family: "Adobe Hebrew";
}
.style20
{
font-family: "Adobe Fangsong Std R";
}
.style21
{
font-family: "Adobe Heiti Std R";
}
#I1
{
height: 135px;
width: 1011px;
}
.style25
{
height: 468px;
}
.style26
{
width: 10px;
height: 468px;
}
.style28
{
width: 1083px;
text-align: center;
}
.style29
{
width: 1083px;
text-align: left;
}
.style30
{
width: 1083px;
height: 468px;
}
.style31
{
width: 1083px;
}
</style>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<div style="background-color:White">
<table style="width:1315px; height: 42px;">
<tr >
<td>
</td>

<td class="style13">
</td>

<td class="style28">

</td>

<td> </td>

<td>
</td>
</tr>

<tr >
<td>
<img src="" title="USERNAME" alt="profile picture"
style="width: 169px; height

ADI@345 29-Apr-14 5:39am View

Deleted

sir ,as i am using store procedure technique..

ADI@345 11-Apr-14 0:45am View

how can i use this contact form in my html page ..

ADI@345 9-Apr-14 5:57am View

the code u have given isn't working...

ADI@345 9-Apr-14 5:52am View

smtp.Send(toAddress, fromAddress, subject, body);

in this line,error occurs sometimes..

ADI@345 9-Apr-14 5:49am View

atually sir,my program works on localhost but not through server ..pls solve my problem

Comments by ADI@345 (Top 171 by date)