niketakapoor

hello everyone still now i m working in c# window application and now im working in asp.net i made a same form and same coding in window application but this code is not working in asp.net... i want to do here is: [B]member_id textbox[/B] when i put some data in …

[COLOR="Green"]exception occur i my code is: Violation of PRIMARY KEY constraint 'PK__lib_book__1ADC427003317E3D'. Cannot insert duplicate key in object 'dbo.lib_book_details'. The statement has been terminated. [/COLOR] [CODE]SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(); da.UpdateCommand = new SqlCommand("Update Lib_book_details set book_tag_id=@book_tag_id,book_name=@book_name,book_author_name=@book_author_name where book_category_id=@book_category_id", cs); da.UpdateCommand.Parameters.Add("@book_tag_id", SqlDbType.Int).Value …

[COLOR="Red"]in the search form by display button records are displayed from database....but i wnt to change the header text of data grid column like member_id as memberID....[/COLOR] [B]how can i do it[/B] as i m tring [CODE]datagridview.column[1].headerText="memberID"[/CODE] [COLOR="Green"][B]it shows error of indexes of collection so what code i will use …

[COLOR="Red"]Book_Return_form Book_tag_id=textbox1 Member_id=textbox2 Book_return_on=textbox3 Book_due_date=textbox4 Fine=textbox5[/COLOR] In this form when I put book-tag_id the rest items come automatically a/c to database and I hv done all till textbox4(book_due_date). Now problem is with fine(textbox5) Fine is calculated acc to membership_type,there are three types of membership silver,gold,platinum Fines are:silver=30,gold=20,platinum=30 so the calculated …

[B]Book_Return_form[/B] [COLOR="Red"]Book_tag_id=textbox1 Member_id=textbox2 Book_return_on=textbox3 Book_due_date=textbox4 Fine=textbox5[/COLOR] [COLOR="Green"][B]In this form when I put book-tag_id the rest items come automatically a/c to database and I hv done all till textbox4(book_due_date). Now problem is with fine(textbox5) Fine is calculated acc to membership_type,there are three types of membership silver,gold,platinum Fines are:silver=30,gold=20,platinum=30 so the calculated …

[B] m trying to make dll class but in m facing errors in it plzzz help me to resolve the...i really need help!!! my full code is:-[/B] [CODE]namespace selectfinedetails { public class TransactionService { SqlConnection cs; private void OpenConnection() { cs = new SqlConnection(); cs.ConnectionString = "Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"; …

i make a stored procedure create proc member_finedetails as select lib_member_details.member_id,lib_member_details.membershiptype_id,membership_desc,fine_per_day FROM lib_member_details INNER JOIN membership_details ON lib_member_details.membershiptype_id=membership_details.membershiptype_id now iwnt to work on it by making dll class...i m confused how to make class of it.plzzzzzzz help me to make dll class of this stored proc...

i m working on a project and still now i m working with data adapter but now i have to work in dll.. [COLOR="Red"]tag_id=textbox member_id=textbox book_retun date=textbox due_date=textbox fine=textbox[/COLOR] as i put tag_id in text box all textbox get automatically filled... for fine it is related to membership_desc silver=10 gold=20 …

Hello...!!! help me if u can..Thanks in advance!!! [COLOR="Red"]database table=issue_details in which columns are issue_id is identity,book_tag_id,member_id,book_issue_on.due_date database table=return_details colums are return_id identity,issue_id,book_returned_on,fine_per_day database=membership_details columns are membership_id,membership_desc(gold,silver,platinum) [/COLOR] [COLOR="Green"]Now my return form is:book_tag_id=textbox1 member_id=textbox2 Issue_date=textbox3 returndate=textbox4 fine=textbox5 [/COLOR] [COLOR="Red"]textbox5:-fine membership_desc=silver,gold,platinum fine_per_day for silver=30 gold=20 platinum=10[/COLOR] now what code i will …

Hello...!!! help me if u can..Thanks in advance!!! [COLOR="Red"]database table=issue_details in which columns are issue_id is identity,book_tag_id,member_id,book_issue_on.due_date database table=return_details colums are return_id identity,issue_id,book_returned_on,fine_per_day database=membership_details columns are membership_id,membership_desc(gold,silver,platinum) [/COLOR] as u see in return databasetable return_id is identity but issue_id is int Now my return form is[COLOR="Green"]:book_tag_id=textbox1 member_id=textbox2 Issue_date=textbox3 returndate=textbox4 fine=textbox5[/COLOR] …

[COLOR="Green"]membership desc=silver,gold,platinum[/COLOR] [COLOR="Red"]fine_per day=30,20,10[/COLOR] from book_due date and returned_date as number of days in which fine is added to get the fine............ how this can b [COLOR="Red"]done in c#[/COLOR] i think the calculation is done as(book_due_date)-(book_returned_on)*30 or 20 or10 how to do all this in c# to get fine in …

hello everyone help me in this code [COLOR="Green"]database table membership_details membership_id,membership_desc,fine_per day,membership_fees [/COLOR] [COLOR="Green"][COLOR="Red"]return table book return id identity,book_issue_id int,book_late_fine [/COLOR][/COLOR] issue table issue_id identity,book_tag_id [B][code]da.InsertCommand = new SqlCommand("Insert` into book_return_details Values(@issue_id,@book_returned_on,@late_fine)", cs); //da.InsertCommand.Parameters.Add("@book_issue_id", SqlDbType.Int).Value = ?????????????[/code][/B] what code i will insert in ???? so that issue id get saved …

i have combobox in which membership_desc=gold,silver,platinum is displayed and have textbox in which i want that fees displayed automatically in it as gold=100 silver=200 platinum=300 [CODE]form_load(); combobox1.datasource=ds.tables["membership_details"]; combobox1.displaymember="membership_type"; combobox1.valuemember="membership_id"; combobox1_selected_index_chanded(); da.selectcommand=neew sqlcommand("select membership fees from membership_details where membership_desc='"+combobox1.selectedvalue+"'",cs); textbox7.text=??????????????????????????????????????????[/CODE] as i do binding of text box it show ERROR that …

[CODE]private void Form_AddMember_Load(object sender, EventArgs e) { da.SelectCommand = new SqlCommand("SELECT * from dbo.membership_details", cs); DataSet ds = new DataSet(); da.Fill(ds, "membership_details"); comboBox1.DataSource = ds.Tables["membership_details"]; comboBox1.DisplayMember = "membership_desc"; comboBox1.ValueMember = "membershiptype_id"; da.SelectCommand = new SqlCommand("select membership_fees from dbo.membership_details where membership_desc='" + comboBox1.SelectedValue + "'", cs); SqlCommand cmd = new SqlCommand("select …

As i click update button data is updated but all the data in the table get with it....(same data in whole table) suggest me what i doing WRONG in it.... [CODE] private void btnUpdate_Click(object sender, EventArgs e) { SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new …

i want due date comes automatically as by adding after 15 days from date of issue................. [code] private void btnIssueBk_Click(object sender, EventArgs e) { SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(); cs.Open(); da.InsertCommand = new SqlCommand("Insert into Lib_issue_details Values(@book_tag_id,@member_id,@book_issue_on,@book_due_date)", cs); da.InsertCommand.Parameters.Add("@book_tag_id", SqlDbType.VarChar).Value = textBox2.Text; …

hello everyone i have a "text box" in which i have to put" member_id" and fetch records as number of books issued to that particular "member_id".... database tables are lib_member_details and issue_detIails... issue_details=tag_id,member_id,book_issue_on,due date... suggest me the code for this problem in c# with sql also help me that can …

hello everyone!! i m new to c# and making project on c# window application.I learned a lot from daniweb but now i m stuck in one thing help me to resolve the problem. database table lib_book_details in which column are tag_id,book_name,author_name. Now i want to make a search form in …