Comments by Member 12244977 (Top 65 by date)

insert when i insert new row the counter column make +1 but when i change date ,column counter count from first

when i change date , count not changed in textbox

when i change date textbox not changed , i want textbox change when i change date

i create gridview and i add columns in this gridview , How i pass this columns to columns in the select query

this ismy code in form gridview :-
public partial class FRM_Patient_List : Form
{
SqlConnection con = new SqlConnection("Server= .; Database= GammaCamera; Integrated Security = true");
SqlCommand sCommand;
SqlDataAdapter sdAdapter;
DataTable dt;
string s;

public FRM_Patient_List()
{
InitializeComponent();
}

void FillGridView()
{
try
{
con.Open();
s = " select P_id as , P_Name , case when P_Gender = 1 then 'M' else 'F' end as 'الجنس', P_DateOfBirth , City.City_Name , ";
s = s + " Center.Center_Name , Phone1 , Phone2 , Doctor.Doctor_Name , ";
s = s + " SideName.Side_Name , P_Weight , P_Length , Notes ";
s = s + " from Patients ";
s = s + " inner join City on Patients.City_id = City.City_id ";
s = s + " inner join Center on Patients.Center_id = Center.Center_id ";
s = s + " inner join Doctor on Patients.Doctor_id = Doctor.Doctor_id ";
s = s + " inner join SideName on Patients.Side_id = SideName.Side_id ";
sCommand = new SqlCommand(s, con);
sdAdapter = new SqlDataAdapter();
sdAdapter.SelectCommand = sCommand;
dt = new DataTable();
sdAdapter.Fill(dt);
BindingSource BSource = new BindingSource();
BSource.DataSource = dt;
dGV_Patient.DataSource = BSource;
con.Close();
}
catch
{
return;
}
}

private void FRM_Patient_List_Load(object sender, EventArgs e)
{
FillGridView();
}

i want display data from gridview to another form textbox .

no but values for Cb_Center not display

not work

thanks for help

How i when i clear combobox make it on ---- select----

its desktop application, not asp

its work but can you explain it for me please and thanks

yes :) How i do that please and thank you for help

i want print the last 5000 kilo for this car number 600 is driven or moved , i have in this table current_distance and prev_distance for this car how i do that with cursor or with loop in C#

the columns in the database allow nulls

i want select all details car_number when last distance is 10000
like :-current_dist - prev_dist
17000 - 15000 = 2000+
15000 - 10000 = 5000
= 7000 when its became 10000 its stop and select rows

and thanks for help

this code return form crystal report views is empty , i want crystal not open

why order by not work here?

select Auto_Parts.Car_id,convert(varchar, Auto_Parts.Change_date,101) as Change_date,Service_Type.Servce_desc,Auto_Parts.Current_dist,Auto_Parts.Prev_dist,(convert(float,Current_dist) - convert(float,Prev_dist)) as Change_dist,(s1.Value_Part) as Value,NULL as [Qty] from Auto_Part_Details s1 inner join Auto_Parts on s1.Job_Card = Auto_Parts.Job_Card inner join Service_Type on Auto_Parts.Servce_id = Service_Type.Servce_id where Auto_Parts.Car_id = 555 and Auto_Parts.Change_date between 1-1-2000 and 1-1-201 order by s1.Change_date

this is code how i add order by here :-

select Cars.Car_id,convert(varchar, Change_date,101) as Change_date , Service_Type.Servce_desc, Current_dist,Prev_distance as Prev_dist,(Current_dist - Prev_distance) as Change_dist,value_Tashhem as Value,NULL as [Qty] from Tashhem s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id = 555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Cars.Car_id,convert(varchar, Change_date,101) as Change_date, Service_Type.Servce_desc,Current_Dist as Current_dist,Prev_Dist as Prev_dist,(Current_dist - Prev_Dist) as Change_dist,Value_Oil as Value,QTY as Qty from Change_Oil s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id =555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Cars.Car_id,convert(varchar, Change_Date,101) as Change_date, Service_Type.Servce_desc,Current_dist ,Prev_dist ,(Current_dist - Prev_dist) as Change_dist,Value_Fuel as Value,Qty from Full_Fuel s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id =555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Cars.Car_id,convert(varchar, Change_date,101) as Change_date, Service_Type.Servce_desc,Current_dist ,Prev_dist ,(convert(float,Current_dist) - convert(float,Prev_dist)) as Change_dist,value_tire as Value,NULL as [Qty] from Change_Tire s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id =555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Cars.Car_id,convert(varchar, Change_Date,101) as Change_date, Service_Type.Servce_desc,Current_dist ,Prev_dist ,(convert(float,Current_dist) - convert(float,Prev_dist)) as Change_dist,Value_Batteries as Value,NULL as [Qty] from Change_Batteries s1 inner join cars on s1.Car_id= Cars.Car_id inner join Service_Type on s1.Servce_id = Service_Type.Servce_id where s1.Car_id =555 and s1.Change_date between 1-1-2000 and 1-1-2016
union
select Auto_Parts.Car_id,convert(varchar, Auto_Parts.Change_date,101) as Change_date,Service_Type.Servce_desc,Auto_Parts.Current_dist,Auto_Parts.Prev_dist,(convert(float,Current_dist) - convert(float,Prev_dist)) as Change_dist,(s1.Value_Part) as Value,NULL as [Qty] from Auto_Part_Details s1 inner join Auto_Parts on s1.Job_Card = Auto_Parts.Job_Card inner join Service_Type on Auto_Parts.Servce_id = Service_Type.Servce_id where Auto_Parts.Car_id = 555 and Auto_Parts.Change_date between 1-1-2000 and 1-1-2016

i update code

thank you very much it's work

can you tell me how ?please and thanks for help

thanks its work but now when the user open form he will find the first row , i want when open he find the combobox empty or like this (---select---) when open it find the data and thank you for help

i used this code i want when the user open form found combobox like (---select----) and when open it he find the data :-
void FillComboBoxRepair()
{
try
{
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select * from Repair_Type", con);
da.Fill(ds, "Repair_Type");

CB_Repair_type.DisplayMember = "Repair_desc";
CB_Repair_type.ValueMember = "Repair_id";
CB_Repair_type.DataSource = ds.Tables["Repair_Type"];
}
}

yes how i select data in combobox used display member and value

this code when i write value in text box and retrieve data in gridview
void CreateDataTable()
{
dt.Columns.Add("items Number");
dt.Columns.Add("job card");
dt.Columns.Add("value");
dt.Columns.Add("auto part");
dt.Columns.Add("repair type");
dt.Columns.Add("New or Old");
dt.Columns.Add("provider");
dt.Columns.Add("");
dt.Columns.Add("notes");

dgv_Add_job_card.DataSource = dt;
}

private void txt_Job_card_KeyDown(object sender, KeyEventArgs e)
{
if ((e.KeyCode == Keys.Enter))
{

con.Open();
SqlDataAdapter DA = new SqlDataAdapter();
DataTable dt = new DataTable();
//s = "SELECT Auto_Parts.Car_id, Auto_Parts.Job_Card, Auto_Parts.Change_date, Auto_Parts.Current_dist, Auto_Parts.Prev_dist, Auto_Parts.Driver_ID, Auto_Part_Details.Items_No, Auto_Part_Details.Value_Part, Auto_Part_Details.Auto_Parts_id,Auto_Part_Details.Repair_id ,Auto_Part_Details.New_Old_Part, Auto_Part_Details.Provider_id, Auto_Part_Details.Installation_id, Auto_Part_Details.Notes FROM Auto_Part_Details RIGHT OUTER JOIN Auto_Parts ON dbo.Auto_Part_Details.Job_Card = Auto_Parts.Job_Card where Auto_Parts.Car_id = @Car_id and Auto_Parts.Job_Card = @Job_Card";
s = "SELECT Auto_Parts.Car_id, Auto_Parts.Job_Card, Auto_Parts.Change_date, Auto_Parts.Current_dist, Auto_Parts.Prev_dist, Auto_Parts.Driver_ID FROM Auto_Parts where Auto_Parts.Car_id = @Car_id and Auto_Parts.Job_Card = @Job_Card";
s = "select s1.Items_No , s1.Job_Card , s1.Value_Part ,Auto_Parts_Type.Parts_desc,Repair_Type.Repair_desc,s1.New_Old_Part,Providers.Provider_desc,Hand_Installation.Installation_desc,s1.Notes from Auto_Part_Details s1 LEFT OUTER JOIN Hand_Installation ON s1.Installation_id = Hand_Installation.Installation_id LEFT OUTER JOIN Providers ON s1.Provider_id = Providers.Provider_id LEFT OUTER JOIN Repair_Type ON s1.Repair_id = dbo.Repair_Type.Repair_id LEFT OUTER JOIN Auto_Parts_Type ON s1.Auto_Parts_id = dbo.Auto_Parts_Type.Auto_Parts_id where s1.Job_Card = @Job_Card ";
sd = new SqlCommand(s, con);
sd.Parameters.AddWithValue("@Car_id", txt_Car_id.Text);
sd.Parameters.AddWithValue("@Job_Card", txt_Job_card.Text);
sda = sd.ExecuteReader();
if (sda.Read())
{
dtp_Change_date.Value = sda.GetDateTime(2);
txt_Current_dist.Text = sda.GetString(3);
txt_Prev_dist.Text = sda.GetString(4);
CB_Driver_name.SelectedValue = sda.GetInt32(5);

}
DA.SelectCommand = sd;
DA.Fill(dt);
dgv_Add_job_card.DataSource = dt;
dgv_Add_job_card.Columns["Items_No"].HeaderText = "item number";
dgv_Add_job_card.Columns["Job_Card"].HeaderText = "job card";
txt_Car_id.ReadOnly = true;
txt_Job_card.ReadOnly = true;
btn_Add.Enabled = false;
btn_Delete.Enabled = true;
btn_Edit.Enabled = true;
con.Close();
}
}

i'm try but i can't so please write the code , explain it and thank you for help

the error here :- where Reload_License.Car_E_date_Licen = '" + x + "' union " + s1 + " union "+ s2 +";";

i'm beginner and i try do that but i can't, please tell me how i do this and thank you for help

tell me how i do this please ?

yes :)

i do that but i can't copy and write too i don't what i can do with this problem

i have error that error must be solution from app.config
< startup uselegacyv2runtimeactivationpolicy = "true" >

i can't write in this file are this file is read only or what i used it usually when i create web app

i trying do this in visual studio app.config when i write code

i can't write anything

yes i'm sure .

i want write uselegacyv2runtimeactivationpolicy = "true"; in app.config but this file become read only i don't know how i can't write any thing in this file

using data set

i know that because the data that i want insert in data table from grid view come from combo box.
this is code that i display the value in combobox i used stored procedure:-

CB_Auto_parts.DataSource = clsParts.GET_ALL_AUTO_PARTS_DESC();
CB_Auto_parts.DisplayMember = "Parts_desc";
CB_Auto_parts.ValueMember = "Auto_Parts_id";

in gridview , i create methods to build columns to display data only :-

void CreateDataTable()
{
dt.Columns.Add("Item");
dt.Columns.Add("Job Number");
dt.Columns.Add("Value");
dt.Columns.Add(" Auto Part Desc");
}

and i create button to insert data in this grid view :-

private void btn_Add_Job_card_Click(object sender, EventArgs e)
{

Validation_Add_Job_card_order();
if (validate == true)
{
DataRow r = dt.NewRow();
// = dt.Rows.Count + 1;
r[0] = dt.Rows.Count + 1;
//r[0] = txt_Items_No.Text;
r[1] = txt_Job_card.Text;
r[2] = txt_Value_Part.Text;

r[3] = CB_Auto_parts.Text; this is a combobox my be the error here ,and how i display value here

dt.Rows.Add(r);
dgv_Add_job_card.DataSource = dt;
ClearText();

txt_Total_Values.Text = (from DataGridViewRow row in dgv_Add_job_card.Rows
where row.Cells[2].FormattedValue.ToString() != string.Empty
select Convert.ToDouble(row.Cells[2].FormattedValue)).Sum().ToString();
}
}

finally this is button that i want insert all rows in grid view to database :-

private void btn_Add_Click(object sender, EventArgs e)
{
for (int i = 0; i < dgv_Add_job_card.Rows.Count; i++)
{
con.Open();
s = "insert into Auto_Part_Details (Items_No, Job_Card, Value_Part, Auto_Parts_id) values (@Items_No, @Job_Card, @Value_Part,@Auto_Parts_id )";
sd=new SqlCommand(s,con);
sd.Parameters.AddWithValue("@Items_No", dgv_Add_job_card.Rows[i].Cells[0].Value);
sd.Parameters.AddWithValue("@Job_Card", dgv_Add_job_card.Rows[i].Cells[1].Value);
sd.Parameters.AddWithValue("@Value_Part", dgv_Add_job_card.Rows[i].Cells[2].Value);
sd.Parameters.AddWithValue("@Auto_Parts_id", dgv_Add_job_card.Rows[i].Cells[8].Value);
sd.ExecuteNonQuery();
con.Close();
}
}

i try explain the problem , i change this r[3] = CB_Auto_Part.text, to , r[3] = CB_Auto_Part.Selected value, its work but its display to user in grid view number and its mistake

iam sorry , i don't know that but can you help me Please

oh, i want tell u something when i insert one row only this code is work but when i insert more than rows this error happened

ALTER proc [dbo].[ADD_AUTO_PART_DETAILS]
@item_no int,
@job_card varchar(50),
@value_part varchar(50),
@auto_parts_id int,
@new_old_part bit,
@provider_id int,
@installation_id int,
@notes text
as
insert into Auto_Part_Details
([Items_No]
,[Job_Card]
,[Value_Part]
,[Auto_Parts_id]
,[New_Old_Part]
,[Provider_id]
,[Installation_id]
,[Notes])
values (@item_no
,@job_card
,@value_part
,@auto_parts_id
,@new_old_part
,@provider_id
,@installation_id
,@notes)

this is the insert query :)

this error , input string was not in a correct format in C# windows form....
int this part:-

for (int i = 0; i < dgv_Add_job_card.Rows.Count - 1; i++)
{
clsParts.ADD_AUTO_PART_DETAILS(Convert.ToInt32(dgv_Add_job_card.Rows[i].Cells[0].Value)
,dgv_Add_job_card.Rows[i].Cells[1].Value.ToString()
,dgv_Add_job_card.Rows[i].Cells[2].Value.ToString()
,Convert.ToInt32(dgv_Add_job_card.Rows[i].Cells[3].Value)
,Convert.ToBoolean(dgv_Add_job_card.Rows[i].Cells[4].Value)
,Convert.ToInt32(dgv_Add_job_card.Rows[i].Cells[5].Value)
,Convert.ToInt32(dgv_Add_job_card.Rows[i].Cells[6].Value).
,dgv_Add_job_card.Rows[i].Cells[7].Value.ToString());
}
}

this error , input string was not in a correct format in C# windows form....
int this part:-

for (int i = 0; i < dgv_Add_job_card.Rows.Count - 1; i++)
{
clsParts.ADD_AUTO_PART_DETAILS(Convert.ToInt32(dgv_Add_job_card.Rows[i].Cells[0].Value)
,dgv_Add_job_card.Rows[i].Cells[1].Value.ToString()
,dgv_Add_job_card.Rows[i].Cells[2].Value.ToString()
,Convert.ToInt32(dgv_Add_job_card.Rows[i].Cells[3].Value)
,Convert.ToBoolean(dgv_Add_job_card.Rows[i].Cells[4].Value)
,Convert.ToInt32(dgv_Add_job_card.Rows[i].Cells[5].Value)
,Convert.ToInt32(dgv_Add_job_card.Rows[i].Cells[6].Value).
,dgv_Add_job_card.Rows[i].Cells[7].Value.ToString());
}
}

i know that ,but no way to get the last date for car_id and the new job_no only

yes and thanks for help

its work but this code display like this :-
Car_id Job_Number Item_Count Change_date
------ ---------- ---------- -----------
123 2222 3 1/10/2015
123 1233 4 2/1/2016
and i want display the last date only

yes i want get Car_id and Job_car with last date and Count(item_No)

item number is key when user insert 5 Parts_type the item number became like this 1,2,3,4,5....

this is code in form2 :-

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WhiteWhale.FL
{
public partial class FRM_DRIVERS_LIST : Form
{
BL.CLS_DRIVERS clsDriver = new BL.CLS_DRIVERS();

int ID;

public FRM_DRIVERS_LIST()
{
InitializeComponent();
this.dGV_Driver.DataSource = clsDriver.GET_ALL_DRIVERS();
dGV_Driver.Columns[0].Visible = false;
}

private void txt_Search_TextChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = clsDriver.Search_Driver(txt_Search.Text);
this.dGV_Driver.DataSource = dt;
}

private void dGV_Driver_DoubleClick(object sender, EventArgs e)
{
this.close();
}

how i do this i try every thing to stop this problem but i cannot do this

when i close the form 2 that have data grid view the first row display in form1 that have text box without i double click in the rows or without i select the row i want display in the form1

in form1 that have text box :-
private void button1_Click(object sender, EventArgs e)
{
FRM_DRIVERS_LIST frm = new FRM_DRIVERS_LIST();
frm.ShowDialog();
ID = Convert.ToInt32(frm.dGV_Driver.SelectedRows[0].Cells[0].Value);
this.txt_code.Text = frm.dGV_Driver.SelectedRows[0].Cells[1].Value.ToString();
this.txt_Driver_Name.Text = frm.dGV_Driver.SelectedRows[0].Cells[2].Value.ToString();
this.txt_Tel1.Text = frm.dGV_Driver.SelectedRows[0].Cells[3].Value.ToString();
this.txt_Tel2.Text = frm.dGV_Driver.SelectedRows[0].Cells[4].Value.ToString();
this.txt_Address.Text = frm.dGV_Driver.SelectedRows[0].Cells[5].Value.ToString();
this.dtp_S_work.Text = frm.dGV_Driver.SelectedRows[0].Cells[6].Value.ToString();
this.CB_WorkPlace.Text = frm.dGV_Driver.SelectedRows[0].Cells[7].Value.ToString();
this.CB_License_type.Text = frm.dGV_Driver.SelectedRows[0].Cells[8].Value.ToString();
this.dTP_Date_e_License.Text = frm.dGV_Driver.SelectedRows[0].Cells[9].Value.ToString();
txt_code.ReadOnly = true;
btn_Edite.Enabled = true;
btn_Delete.Enabled = true;
btn_Add.Enabled = false;
}
form2 that have data grid view :-

private void dataGridView_Driver_DoubleClick(object sender, EventArgs e)
{
this.close();
}

when i double click on the row its display . but when i close form one he display the first row withoud i double click in this row

this is my code first form :-

private void button1_Click(object sender, EventArgs e)
{
FRM_DRIVERS_LIST frm = new FRM_DRIVERS_LIST();
frm.ShowDialog();
ID = Convert.ToInt32(frm.dGV_Driver.SelectedRows[0].Cells[0].Value);
this.txt_Driver_Name.Text = frm.dGV_Driver.SelectedRows[0].Cells[1].Value.ToString();
this.txt_Tel1.Text = frm.dGV_Driver.SelectedRows[0].Cells[2].Value.ToString();
this.txt_Tel2.Text = frm.dGV_Driver.SelectedRows[0].Cells[3].Value.ToString();
this.txt_Address.Text = frm.dGV_Driver.SelectedRows[0].Cells[4].Value.ToString();
this.dtp_S_work.Text = frm.dGV_Driver.SelectedRows[0].Cells[5].Value.ToString();
this.CB_WorkPlace.Text = frm.dGV_Driver.SelectedRows[0].Cells[6].Value.ToString();
this.CB_License_type.Text = frm.dGV_Driver.SelectedRows[0].Cells[7].Value.ToString();
this.dTP_Date_e_License.Text = frm.dGV_Driver.SelectedRows[0].Cells[8].Value.ToString();
}

my second form that open when i click button1 that have data gride view :
public partial class FRM_DRIVERS_LIST : Form
{
BL.CLS_DRIVERS clsDriver = new BL.CLS_DRIVERS();

int ID;

public FRM_DRIVERS_LIST()
{
InitializeComponent();
this.dGV_Driver.DataSource = clsDriver.GET_ALL_DRIVERS();
dGV_Driver.Columns[0].Visible = false;
}

private void txt_Search_TextChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = clsDriver.Search_Driver(txt_Search.Text);
this.dGV_Driver.DataSource = dt;
}

private void dGV_Driver_DoubleClick(object sender, EventArgs e)
{
this.Close();
}

when i open the second form(data grid view) the first row is display in my first form i want cancel this and i want display data when i double click only

this is my stored procedure i need message show to user if he write data is exist in text box

ALTER proc [dbo].[ADD_CAR_DATA]
@car_id int,
@car_no nchar(10),
@car_no_2 varchar(10),
@car_shs nchar(25),
@car_motor nchar(25),
@car_type_id int,
@car_model_id int,
@car_year varchar(4),
@car_capcity int,
@car_ton nchar(10),
@car_color_id int,
@care_date_bay date,
@car_date_in date,
@car_owner_id int,
@car_place_id int,
@note_desc text
as
INSERT INTO [Cars]
([Car_id]
,[Car_No]
,[Car_No_2]
,[Car_shs]
,[Car_Motor]
,[Car_Type_id]
,[Car_Model_id]
,[Car_Year]
,[Car_Capcity]
,[Car_Ton]
,[Car_Color_id]
,[Car_Date_Bay]
,[Car_Date_in]
,[Car_Owner_id]
,[Car_Place_id]
,[Note_desc])
VALUES
(@car_id,
@car_no,
@car_no_2,
@car_shs,
@car_motor,
@car_type_id,
@car_model_id,
@car_year,
@car_capcity,
@car_ton,
@car_color_id,
@care_date_bay,
@car_date_in,
@car_owner_id,
@car_place_id,
@note_desc)

i used stored procedures ADD_CAR_DATA is insert into and i used pram just i need the if condition that validate an check txt_motor and txt_shs is exist in database or not