Generate no autumatically

Accepted answer

In Calendar1_SelectionChanged, try this code:

DateTime dt = Calendar1.SelectedDate + DateTime.Now.TimeOfDay;
txtchin.Text = dt.ToString("yyyyMMdd HH:mm:ss");

0

Vulpes12y ago

If you've made the date column a primary key, or given it the unique constraint, in the database, then you won't be able to save two records with the same date in the database.

However, if you use a full date/time including seconds (and possibly milliseconds), then you should be OK as the times when individual records are saved should then be unique.

0

Amol Sonavane12y ago

Hello Sir, when i select a one date for record and save it..after that i choose same date for another record..at that time selected date is invisible or selected... what the reason is this any solution.. means i want to save two records in same date but after first record inserted this date is invisible or selected i cant select that date....

0

Amol Sonavane12y ago

Hello Sir, Its working Thanks...

0

Amol Sonavane12y ago

namespace WebApplication1

{

public partial class WebForm1 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Calendar1.Visible = false;

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

string ConString="Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\Amol Sonavane\\documents\\visual studio 2010\\Projects\\WebApplication1\\WebApplication1\\App_Data\\Database1.mdf;Integrated Security=True;User Instance=True";

SqlConnection con=new SqlConnection(ConString);

Session["Connection"] = con; // store in Session state for now

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

cmd.CommandText = "SELECT TOP 1 ChallenNo FROM tbSample ORDER BY ChallenNo DESC";

con.Open();

SqlDataReader reader = cmd.ExecuteReader();

string challen = "AS000";

if (reader.HasRows)

{

reader.Read();

challen = reader["ChallenNo"].ToString();

}

reader.Close();

con.Close();

//lblInChallen.Text = challen;

lblchln.Text = challen;

Session["Challen"] = challen;

}

//protected void ImageButton1_Click(object sender, ImageClickEventArgs e)

//{

// if (Calendar1.Visible)

// {

// Calendar1.Visible = false;

// }

// else

// {

// Calendar1.Visible = true;

// }

//}

protected void btnSave_Click1(object sender, EventArgs e)

{

string ConString="Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\Amol Sonavane\\documents\\visual studio 2010\\Projects\\WebApplication1\\WebApplication1\\App_Data\\Database1.mdf;Integrated Security=True;User Instance=True";

SqlConnection con = new SqlConnection(ConString);

con.Open();

string query = "Insert into tbSample values('"+lblchln.Text+"','"+txtchln.Text+"') ";

SqlCommand cmd = new SqlCommand(query,con);

cmd.ExecuteNonQuery();

con.Close();

btnSave.Enabled = false;

}

protected void Calendar1_SelectionChanged(object sender, EventArgs e)

{

//txtchln.Text = Calendar1.SelectedDate.ToString("yyyy-MM-dd HH:mm:ss");

//txtchln.Text = Calendar1.SelectedDate.ToString();

txtchln.Text = Calendar1.SelectedDate.ToString("dd/MMMM/yyyy");

Calendar1.Visible = false;

}

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)

{

if (e.Day.IsOtherMonth)

{

e.Day.IsSelectable = false;

}

protected void ImageButton1_Click1(object sender, ImageClickEventArgs e)

{

if (Calendar1.Visible)

{

Calendar1.Visible = false;

}

else

{

Calendar1.Visible = true;

}

string challen = Session["Challen"].ToString();

int number = int.Parse(challen.Substring(2)) + 1;

challen = "AS" + number.ToString("D3");

//lblInChallen.Text = challen;

lblchln.Text = challen;

Session["Challen"] = challen;

}

0

Amol Sonavane12y ago

Hi sir i have created demo application for date and send you... has same problem for timing...please have a look

0

Vulpes12y ago

Can you post the code then. I'll see if I can figure out what the problem is.

0

Amol Sonavane12y ago

yes sir.... i have taken a database DateTime in database..

0

Vulpes12y ago

Have you added the time component in the way that I suggested?

Also is the column type in the database one that supports both date and time - in other words is it something other than the 'date' type which only supports dates?

0

Amol Sonavane12y ago

sorry sir its not working it also show 12.00

0

Vulpes12y ago

ToLongDateString() will give you something like 28 August 2014.

If you want both the date and time and want to be reasonably sure the datebase will accept it, I'd use: ToString ("yyyyMMdd HH:mm:ss").

0

Amol Sonavane12y ago

I write ToLongDate instead of Tostring for getting day and date but got a error when inserting.. Error-Conversion failed when converting date and/or time from character string.

0

Amol Sonavane12y ago

k sir...can we print the day by using this...

0

Vulpes12y ago

AFAIK, it's not possible to set a time using the Calendar control.

If you want to graft the current time onto whatever the selected date is, you could do this:

DateTime dt = Calendar1.SelectedDate + DateTime.Now.TimeOfDay;

As I said earlier I don't use Crystal Reports. I'd look for a suitable article of which there are plenty on this site alone:

http://www.c-sharpcorner.com/tags/1/Crystal-Reports/

0

Amol Sonavane12y ago

Hello Sir, How to create crystal report?

0

Amol Sonavane12y ago

hello sir... by using calender control is it possible or not?

0

Vulpes12y ago

Well, if you're obtaining the date from the Calendar control it will show as 12.00 am because the control can only deal with dates and the time component will always therefore be zero hours.

If you want to insert the current date and time , I'd use DateTime.Now rather than Calendar1.SelectedDate.

Sorry, I don't use Crystal Reports. I'd either search for an article on it or ask the question again in a new thread.

0

Amol Sonavane12y ago

Hello sir.. when i insert date into database it take date and default time 12.00..But i want current time...How we will do that?Also please tell me how to create crystal report step by step.... Thank you

0

Amol Sonavane12y ago

Hello Sir I have created new sample application in that i have taken the challan and date fields...In that your code is working...

0

Amol Sonavane12y ago

Thanks Sir I will check...

0

Vulpes12y ago

Well, I'm not surprised it's not working because the code to get the latest Challen number from the database when the page loads and to store the incremented number in Session state when the ImageButton is clicked is all commented out!

Anyway, I've tried to reconstruct it below. Unfortunately, I can't test this as I don't have any ASP.NET stuff on the machine I'm using just now so there may be bugs.

Ideally, the SqlConnection object should be stored globally but I've stored it in Session state for now. I wouldn't bother storing the SqlCommand and SqlDataReader objects - I'd just create them as needed.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Configuration;

namespace VISInventorySystem

{

public partial class InwardForm : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if(!IsPostBack)

{

grdInward.Visible = false;

Calendar2.Visible = false;

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

Session["Connection"] = con; // store in Session state for now

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

cmd.CommandText = "SELECT TOP 1 InChallenNo FROM tbInward ORDER BY InChallenNo DESC";

con.Open();

SqlDataReader reader = cmd.ExecuteReader();

string challen = "AS000";

if (reader.HasRows)

{

reader.Read();

challen = reader["InChallenNo"].ToString();

}

reader.Close();

con.Close();

lblInChallen.Text = challen;

Session["Challen"] = challen;

}

protected void Calendar2_SelectionChanged(object sender, EventArgs e)

{

txtReceiveDate.Text= Calendar2.SelectedDate.ToString("d");

Calendar2.Visible = false;

}

protected void Calendar2_DayRender(object sender, DayRenderEventArgs e)

{

if (e.Day.IsOtherMonth)

{

e.Day.IsSelectable = false;

}

protected void ImageButton2_Click(object sender, ImageClickEventArgs e)

{

if (Calendar2.Visible)

{

Calendar2.Visible = false;

}

else

{

Calendar2.Visible = true;

}

// don't know whether this code is dependent on visibility of calendar on not?

string challen = Session["Challen"].ToString();

int number = int.Parse(challen.Substring(2)) + 1;

challen = "AS" + number.ToString("D3");

lblInChallen.Text = challen;

Session["Challen"] = challen;

}

protected void btnInSave_Click(object sender, EventArgs e)

{

SqlConnection con = (SqlConnection)Session["Connection"];

con.Open();

string query = "Insert into tbInward(InChallenNo,InProdCategory,InProdDetails,InSerialNo,InReceivedlocation,InReceivedDate,Comments)values('"+lblInChallen.Text+"','"+ddlInProdCategory.SelectedValue+"','"+txtInPDetails.Text+"','"+txtInSerialNumber.Text+"','"+ddlInLocation.SelectedValue+"','"+txtReceiveDate.Text+"','"+txtInComments.Text+"')";

SqlCommand cmd = new SqlCommand(query,con);

cmd.CommandType = System.Data.CommandType.Text;

cmd.ExecuteNonQuery();

Response.Write("Record has been inserted");

con.Close();

ddlInProdCategory.SelectedValue = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text = "";

ddlInLocation.SelectedValue = "";

txtInComments.Text = "";

txtReceiveDate.Text = "";

}

protected void btnNewForm_Click(object sender, EventArgs e)

{

txtInComments.Text = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text="";

txtReceiveDate.Text="";

ddlInLocation.Text="";

ddlInProdCategory.Text="";

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

}

protected void btnInView_Click(object sender, EventArgs e)

{

grdInward.Visible = true;

}

protected void btnInUpdate_Click(object sender, EventArgs e)

{

SqlConnection con = (SqlConnection)Session["Connection"];

con.Open();

string query1 = "update tbInward set InChallenNo='"+lblInChallen.Text+"',InProdCategory='"+ddlInProdCategory.SelectedValue+"',InProdDetails='"+txtInPDetails.Text+"',InSerialNo='"+txtInSerialNumber.Text+"',InReceivedlocation='"+ddlInLocation.SelectedValue+"',InReceivedDate='"+txtReceiveDate.Text+"',Comments='"+txtInComments.Text+"' where (InSerialNo='"+txtInSerialNumber.Text+"')";

SqlCommand cmd = new SqlCommand(query1, con);

cmd.ExecuteNonQuery();

con.Close();

ddlInProdCategory.SelectedValue = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text = "";

ddlInLocation.SelectedValue = "";

txtInComments.Text = "";

txtReceiveDate.Text = "";

}

protected void btnSearch_Click(object sender, EventArgs e)

{

SqlConnection con = (SqlConnection)Session["Connection"];

con.Open();

string query = "Select * from tbInward where InSerialNo='" + txtInSerialNumber.Text + "'";

//string query1 = "Select * FROM tbRMC WHERE Cno='" + txtcno.Text + "'";

SqlCommand cmd2 = new SqlCommand(query, con);

//SqlDataReader reader;

SqlDataReader rd = cmd2.ExecuteReader();

//if (reader.IsClosed == false && reader.HasRows)

if(rd.IsClosed==false && rd.HasRows)

{

if (rd.Read())

{

lblInChallen.Text = rd["InChallenNo"].ToString();

ddlInProdCategory.Text = rd["InProdCategory"].ToString();

txtInPDetails.Text = rd["InProdDetails"].ToString();

//txtInSerialNumber.Text = rd["InSerialNo"].ToString();

ddlInLocation.Text = rd["InReceivedlocation"].ToString();

txtReceiveDate.Text = rd["InreceivedDate"].ToString();

txtInComments.Text = rd["Comments"].ToString();

//lbl_Cno.Text = reader["Cno"].ToString();

//txtTo.Text = reader["CTo"].ToString();

//txtContactNo.Text = reader["ContactNo"].ToString();

//txtBatchNo.Text = reader["BatchNo"].ToString();

//txtLOS.Text = reader["LOS"].ToString();

//txtDate.Text = reader["Date"].ToString();

//lblRQ.Text = reader["RQ"].ToString();

//txtWAT.Text = reader["WAT"].ToString();

//txtVIOTAS.Text = reader["VIATAS"].ToString();

//txtTOCA.Text = reader["TOCA"].ToString();

//txtTMN.Text = reader["TMN"].ToString();

//txtSTA.Text = reader["STA"].ToString();

//txtSQ.Text = reader["SQ"].ToString();

//txtOQ.Text = reader["OQ"].ToString();

}

else

{

Response.Write("No Record Found");

}

rd.Close();

con.Close();

ddlInProdCategory.SelectedValue = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text = "";

ddlInLocation.SelectedValue = "";

txtInComments.Text = "";

txtReceiveDate.Text = "";

}

protected void btnInDelete_Click(object sender, EventArgs e)

{

SqlConnection con = (SqlConnection)Session["Connection"];

con.Open();

string query1 = "delete from tbInward where InProdCategory='"+ddlInProdCategory.SelectedValue+"'";

SqlCommand cmd = new SqlCommand(query1, con);

cmd.ExecuteNonQuery();

con.Close();

ddlInProdCategory.SelectedValue = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text = "";

ddlInLocation.SelectedValue = "";

txtInComments.Text = "";

txtReceiveDate.Text = "";

}

0

Amol Sonavane12y ago

Hello Sir,If you have a time then check code and give me correct code AS EARLY AS possible....

0

Amol Sonavane12y ago

Hello sir please check the code and give me solution as early as possible ....please

0

Amol Sonavane12y ago

Hi sir please see below code and give me a solution.....

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Configuration;

namespace VISInventorySystem

{

public partial class InwardForm : System.Web.UI.Page

{

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

SqlCommand cmd = null;

SqlDataReader rd = null;

protected void Page_Load(object sender, EventArgs e)

{

//if (!IsPostBack)

//{

// Calendar2.Visible = false;

//}

if (true)

{

grdInward.Visible = false;

Calendar2.Visible = false;

////string conStr = "whatever";

////SqlConnection con = new SqlConnection(conStr);

//SqlCommand cmd = new SqlCommand();

//cmd.Connection = con;

//cmd.CommandText = "SELECT TOP 1 InChallenNo FROM tbInward ORDER BY InChallenNo DESC";

//con.Open();

//SqlDataReader reader = cmd.ExecuteReader();

//string challen = "AS000";

//if (reader.HasRows)

//{

// reader.Read();

// challen = reader["InChallenNo"].ToString();

//}

//reader.Close();

//con.Close();

//lblInChallen.Text = challen;

//Session["Challen"] = challen;

}

protected void Calendar2_SelectionChanged(object sender, EventArgs e)

{

txtReceiveDate.Text= Calendar2.SelectedDate.ToString("d");

Calendar2.Visible = false;

}

protected void Calendar2_DayRender(object sender, DayRenderEventArgs e)

{

if (e.Day.IsOtherMonth)

{

e.Day.IsSelectable = false;

}

protected void ImageButton2_Click(object sender, ImageClickEventArgs e)

{

if (Calendar2.Visible)

{

Calendar2.Visible = false;

}

else

{

Calendar2.Visible = true;

}

protected void btnInSave_Click(object sender, EventArgs e)

{

//int a = 1;

//con.Open();

//string query1 = "select max(InChallenNo) as maxid from tbInward";

//SqlCommand cmd1 = new SqlCommand(query1, con);

//a = Convert.ToInt32(cmd1.ExecuteScalar());

//lblInChallen.Text = (a + 1).ToString();

//con.Close();

con.Open();

string query = "Insert into tbInward(InChallenNo,InProdCategory,InProdDetails,InSerialNo,InReceivedlocation,InReceivedDate,Comments)values('"+lblInChallen.Text+"','"+ddlInProdCategory.SelectedValue+"','"+txtInPDetails.Text+"','"+txtInSerialNumber.Text+"','"+ddlInLocation.SelectedValue+"','"+txtReceiveDate.Text+"','"+txtInComments.Text+"')";

cmd = new SqlCommand(query,con);

cmd.CommandType = System.Data.CommandType.Text;

cmd.ExecuteNonQuery();

Response.Write("Record has been inserted");

con.Close();

ddlInProdCategory.SelectedValue = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text = "";

ddlInLocation.SelectedValue = "";

txtInComments.Text = "";

txtReceiveDate.Text = "";

}

protected void btnNewForm_Click(object sender, EventArgs e)

{

//string challen = Session["Challen"].ToString();

//int number = int.Parse(challen.Substring(2)) + 1;

//challen = "AS" + number.ToString("D3");

//lblInChallen.Text = challen;

//Session["Challen"] = challen;

txtInComments.Text = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text="";

txtReceiveDate.Text="";

ddlInLocation.Text="";

ddlInProdCategory.Text="";

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

}

protected void btnInView_Click(object sender, EventArgs e)

{

grdInward.Visible = true;

}

protected void btnInUpdate_Click(object sender, EventArgs e)

{

con.Open();

string query1 = "update tbInward set InChallenNo='"+lblInChallen.Text+"',InProdCategory='"+ddlInProdCategory.SelectedValue+"',InProdDetails='"+txtInPDetails.Text+"',InSerialNo='"+txtInSerialNumber.Text+"',InReceivedlocation='"+ddlInLocation.SelectedValue+"',InReceivedDate='"+txtReceiveDate.Text+"',Comments='"+txtInComments.Text+"' where (InSerialNo='"+txtInSerialNumber.Text+"')";

cmd = new SqlCommand(query1, con);

cmd.ExecuteNonQuery();

con.Close();

ddlInProdCategory.SelectedValue = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text = "";

ddlInLocation.SelectedValue = "";

txtInComments.Text = "";

txtReceiveDate.Text = "";

}

protected void btnSearch_Click(object sender, EventArgs e)

{

con.Open();

string query = "Select * from tbInward where InSerialNo='" + txtInSerialNumber.Text + "'";

//string query1 = "Select * FROM tbRMC WHERE Cno='" + txtcno.Text + "'";

SqlCommand cmd2 = new SqlCommand(query, con);

//SqlDataReader reader;

rd = cmd2.ExecuteReader();

//if (reader.IsClosed == false && reader.HasRows)

if(rd.IsClosed==false && rd.HasRows)

{

if (rd.Read())

{

lblInChallen.Text = rd["InChallenNo"].ToString();

ddlInProdCategory.Text = rd["InProdCategory"].ToString();

txtInPDetails.Text = rd["InProdDetails"].ToString();

//txtInSerialNumber.Text = rd["InSerialNo"].ToString();

ddlInLocation.Text = rd["InReceivedlocation"].ToString();

txtReceiveDate.Text = rd["InreceivedDate"].ToString();

txtInComments.Text = rd["Comments"].ToString();

//lbl_Cno.Text = reader["Cno"].ToString();

//txtTo.Text = reader["CTo"].ToString();

//txtContactNo.Text = reader["ContactNo"].ToString();

//txtBatchNo.Text = reader["BatchNo"].ToString();

//txtLOS.Text = reader["LOS"].ToString();

//txtDate.Text = reader["Date"].ToString();

//lblRQ.Text = reader["RQ"].ToString();

//txtWAT.Text = reader["WAT"].ToString();

//txtVIOTAS.Text = reader["VIATAS"].ToString();

//txtTOCA.Text = reader["TOCA"].ToString();

//txtTMN.Text = reader["TMN"].ToString();

//txtSTA.Text = reader["STA"].ToString();

//txtSQ.Text = reader["SQ"].ToString();

//txtOQ.Text = reader["OQ"].ToString();

}

else

{

Response.Write("No Record Found");

}

rd.Close();

con.Close();

ddlInProdCategory.SelectedValue = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text = "";

ddlInLocation.SelectedValue = "";

txtInComments.Text = "";

txtReceiveDate.Text = "";

}

protected void btnInDelete_Click(object sender, EventArgs e)

{

con.Open();

string query1 = "delete from tbInward where InProdCategory='"+ddlInProdCategory.SelectedValue+"'";

cmd = new SqlCommand(query1, con);

cmd.ExecuteNonQuery();

con.Close();

ddlInProdCategory.SelectedValue = "";

txtInPDetails.Text = "";

txtInSerialNumber.Text = "";

ddlInLocation.SelectedValue = "";

txtInComments.Text = "";

txtReceiveDate.Text = "";

}

0

Vulpes12y ago

I haven't been able to reproduce the problem but it appears that, for some reason, a new session is being started before the previous value can be saved to the database.

Can you post your code and I'll have another look at it when I have more time.

0

Amol Sonavane12y ago

Hello sir,have you solution in that scenario?please give me as early as possible.....

0

Amol Sonavane12y ago

what is the solution in this scenarion.........

0

Amol Sonavane12y ago

Hello sir seen is that i have taken a calender image,that is when i click a image button of calender at that time calender will show....and then we will select a date...In our case when i will click on calender button for showing calender at that time last value of challen no is not taken....i.e if our database value is AS002 and we will run the project when page loading at that time value is incremented i.e AS003 BUT when i click on image button at that time it will reset to AS002..Whats the problem?please give me solution as early as possible..thanks...

0

Vulpes12y ago

I didn't follow how your imagebutton and calendar controls are associated with each other.

If you click on the imagebutton, then I can't think of any obvious reason why the code wouldn't work the same as for an 'ordinary' button.

However, if you click on the calendar control, then there isn't a Click event as such. However, there is a SelectionChanged event.

Can you clarify the position here.

0

Amol Sonavane12y ago

code which is given by you for generating no is not working properly

0

Amol Sonavane12y ago

Hello sir actuly i was created image button for calender and whenever i will click the calender the top Challan no is not getting that is click event are generated.. so please can you give me code in proper format as early as possible..that means code is put in which braces....

0

Vulpes12y ago

Sorry for the delay in responding but I've been away for a couple of days.

Well, off the top of my head, the code to do all that will be along the following lines.

However, you'll need to make sure that the data types in the database correspond to what I've assumed and also need to add some try/catch statements in case there are exceptions.

protected void BtnInsert_Click(object sender, EventArgs e)

{

string conStr = "whatever";

SqlConnection con = new SqlConnection(conStr);

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

cmd.CommandText = "INSERT INTO sometable([textcol], [dropdowncol], [calendarcol]) VALUES(@text, @dropdown, @calendar)";

cmd.Parameters.Add("@text", SqlDbType.VarChar).Value = TextBox1.Text;

cmd.Parameters.Add("@dropdown, SqlDbType.VarChar").Value = DropDownList.SelectedItem.Text;

cmd.Parameters.Add("@calendar", SqlDbType.Date).Value = Calendar1.SelectedDate;

cmd.ExecuteNonQuery();

con.Close();

}

protected void BtnUpdate_Click(object sender, EventArgs e)

{

string conStr = "whatever";

SqlConnection con = new SqlConnection(conStr);

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

// it's assumed that [textcol] is a primary key or otherwise unique column

cmd.CommandText = "UPDATE sometable SET [textcol] = @text, [dropdowncol] = @dropdown, [calendarcol] = @calendar WHERE [textcol] = @prevtext";

cmd.Parameters.Add("@prevtext, SqlDbType.VarChar).Value = "whatever";

cmd.Parameters.Add("@text", SqlDbType.VarChar).Value = TextBox1.Text;

cmd.Parameters.Add("@dropdown, SqlDbType.VarChar").Value = DropDownList.SelectedItem.Text;

cmd.Parameters.Add("@calendar", SqlDbType.Date).Value = Calendar1.SelectedDate;

cmd.ExecuteNonQuery();

con.Close();

}

protected void BtnDelete_Click(object sender, EventArgs e)

{

string conStr = "whatever";

SqlConnection con = new SqlConnection(conStr);

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

// it's assumed that [textcol] is a primary key or otherwise unique column

cmd.CommandText = "DELETE FROM sometable WHERE [textcol] = @text";

cmd.Parameters.Add("@text", SqlDbType.VarChar).Value = TextBox1.Text;

cmd.ExecuteNonQuery();

con.Close();

}

If you're reloading the page without saving the current Challen number first, then the numbering will start again from the last saved value in the database.

+1

Amol Sonavane12y ago

hello sir number is generated but no increment....when new form is open

-1

Amol Sonavane12y ago

Hello sir please give me a solution as early as possible....

-1

Amol Sonavane12y ago

Hello Sir how to insert,update and delete text,dropdown,date value into database by using query....

-1

Vulpes12y ago

The code should be put in the Page_Load handler within the 'if' statement so that the last number only loads once from the database, not on each post-back.

+1

Amol Sonavane12y ago

Hi sir at which section i will put that code i.e button click or page load...

0

Vulpes12y ago

Well it will, of course, depend on which database you're using but, for SQL Server, the code will be something like this (EDITED):

string conStr = "whatever";
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "SELECT TOP 1 challen FROM sometable ORDER BY challen DESC";
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
string challen = "AS000";

if (reader.HasRows)
{
reader.Read())
challen = reader["challen"].ToString();
}

reader.Close();
con.Close();
Label1.Text = challen;
Session["Challen"] = challen;

+1

Amol Sonavane12y ago

Hello sir its working,but just tell me how to load last one from database.....

0

Vulpes12y ago

Something like this perhaps:

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

string challen = "AS001"; // or load last one saved from database

Label1.Text = challen;

Session["Challen"] = challen;

}

protected void Button1_Click(object sender, EventArgs e)

{

string challen = Session["Challen"].ToString();

int number = int.Parse(challen.Substring(2)) + 1;

challen = "AS" + number.ToString("D3");

Label1.Text = challen;

Session["Challen"] = challen;

}

+1