|
I get the employee list from SQL Server problem with fields:
ID: id employee
Employee: name employee
after filter the kernel list dv.RowFilter = "set condition unique 1 recoder" at the command if (dv.Count == 1) at this assignment id and the kernel name is not correct the unique file filter on which it assign the first file in the family list. yourself want to get sample sample already been filter by dv.RowFilter, main syntax in command if (dv.Count == 1) {// chars this again as what ?)
string tmpSQL = "string to get the list employee";
DataTable dt = Conection.FillDatatable(tmpSQL);
DataView dv = new DataView(dt);
dv.RowFilter = "set condition unique 1 recoder";
if (dv.Count == 1)
{
txtIdEmployee.Text = dv.Table.Rows[0]["ID"].ToString();
txtNameEmployee.Text = dv.Table.Rows[0]["Employee"].ToString();
}
else
{
}
modified 23-May-18 2:55am.
|
|
|
|
|
It may be early in the morning and I'm still drinking my first coffee of the day, but that makes no sense to me at all.
Please, try copy and pasting the code you are actually using (use the "code" widget to format it)
if (a)
{
b();
} And show sample DB data. Then explain what you expected to happen, and compare that to what did, tell us when it happened, what you did to make it happen, give us any error messages that appeared. Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
But from what you have posted so far, I can't even work out when the problem occurs (compilation or run time) much less what the problem itself might be - and so can't even begin to come up with a solution!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Member 2458467 wrote: dv.RowFilter = "set condition unique 1 recoder";
The RowFilter property[^] has a defined syntax[^] which you must follow.
"set condition unique 1 recoder " is not a valid row filter.
The rest of your question makes absolutely no sense. I suggest you find a better translator.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
You could try this:
DataTable table = dv.ToTable().AsEnumerable().GroupBy(x=>x.ID);
if (table.Rows.Count == 1)
{
txtIdEmployee.Text = table.Rows[0]["ID"].ToString();
txtNameEmployee.Text = table.Rows[0]["Employee"].ToString();
}
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Hi Guys,
How can I make below work? 3 radio button is there and whichever is clicked will be added to pdf.
switch
{
case 1 (radioButton54.Checked)
Paragraph q1 = new Paragraph(label10.Text + " " + radioButton54.Text);
pdfDosya.Add(q1);
case 2 (radioButton122.Checked)
Paragraph q1 = new Paragraph(label10.Text + " " + radioButton122.Text);
pdfDosya.Add(q1);
case 3 (radioButton1.Checked)
Paragraph q1 = new Paragraph(label10.Text + " " + radioButton1.Text);
pdfDosya.Add(q1);
}
modified 13-Feb-19 21:02pm.
|
|
|
|
|
You can't use switch like that in C#, the format is:
switch (variable)
{
case constantValue1:
...
break;
case constantValue2:
...
break;
default:
...
break;
} You could use a variable to "combine" the radio buttons and the switch on that, but it would be very messy. You would be much better off with an if ... else if ... else instead:
if (radioButton54.Checked)
{
Paragraph q1 = new Paragraph(label10.Text + " " + radioButton54.Text);
pdfDosya.Add(q1);
}
else if (radioButton122.Checked)
{
Paragraph q1 = new Paragraph(label10.Text + " " + radioButton122.Text);
pdfDosya.Add(q1);
}
else if (radioButton1.Checked)
{
Paragraph q1 = new Paragraph(label10.Text + " " + radioButton1.Text);
pdfDosya.Add(q1);
} In the long term, it'll be a lot more readable and maintainable.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Message Closed
modified 13-Feb-19 21:02pm.
|
|
|
|
|
You're welcome!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
Yes, but nothing that will let him do that!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Well, technically, this terrible code would work:
switch (true)
{
case true when radioButton54.Checked:
...
break;
case true when radioButton122.Checked:
...
break;
case true when radioButton1.Checked:
...
break;
}
After all, you didn't say it had to be good code.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
:shudder:
We should have a detector system that sends code like that direct to "weird and wonderful" so we can abuse it...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OW! MY EYES!
You will burn at the stake for coming up with such an abomination!
|
|
|
|
|
It's very useful code: a perfect example of "Just because you can do something, doesn't mean you should".
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Bloody hell you have a weird and twisty mind just to be able to think of that!
I'm with OG have it moved to weird and wonderful so it can be voted abuse
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I do not provide one-to-one solutions here: so sending me a private email requesting further help will not work.
If you want additional help please post the request publically, so all can assist and / or benefit.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
This is one of the many reasons I have email me switched off in my profile.
This space for rent
|
|
|
|
|
Why couldn't you simply set some variables in the Checked handler, which would make the switch statement irrelevant?
Paragraph q1 = null;
public void radio54_ischecked(...)
{
this.q1 = new Paragraph(string.Format("{0} {1}", label10Text, radioButton54.Text));
}
public void radio22_ischecked(...)
{
this.q1 = new Paragraph(string.Format("{0} {1}", label10Text, radioButton22.Text));
}
public void radio1_ischecked(...)
{
this.q1 = new Paragraph(string.Format("{0} {1}", label10Text, radioButton1.Text));
}
at that point, switch statement could be removed and replaced with this line of code, because q1 would already be ready (or null, depending on how your code is written):
if (q1 != null) pdfDosya.Add(q1);
EDIT ==================================
There are ways you can further reduce the code in the checked event handlers (depending on what framework you're dealing with), but I'll leave that as an exercise for the programmer.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
modified 24-May-18 14:55pm.
|
|
|
|
|
Hello guys,
Im using .NET3.5 with ClosedXML libraray version is 0.75.0.0 .
I just inserted into merged cells on excel file. But when i convert to XPS file image is not in cell. Now image size is in pixel.
The questions are:
1. How to correctly insert image into merged cell?.
2. When i print file it's dependent on screen settings . How to solve this problem perfectly.
Thanks
|
|
|
|
|
|
Hi. I have a cellformatting event of a datagridview. No problem when loading and running first time. But what should i do if i click on a button and run cellformatting with this click. I couldnt manage this. Even i run databindingcompleted manually but it didnt help run cellformatting.
|
|
|
|
|
|
Hi. I try to color specific cells of a datagridview in cellformatting. everything is ok but if i color first row's cell, other rows' cells are coloured with the same color. so, for the time being i excluded to color first row. what should be the problem? this is the code:
if (e.ColumnIndex == 2)
{
if (dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString() !=bookmark_id.ToString())
{
if (dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() == ((int)specialStates.Anlasildi).ToString()) { dataGridView1.Rows[e.RowIndex].Cells["content"].Style.BackColor = Renk_Anlasildi_Backcolor; dataGridView1.Rows[e.RowIndex].Cells["content"].Style.ForeColor = Renk_Anlasildi_Forecolor; }
else if (dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() == ((int)specialStates.Onemli).ToString()) { dataGridView1.Rows[e.RowIndex].Cells["content"].Style.BackColor = Renk_Onemli_Backcolor; ; dataGridView1.Rows[e.RowIndex].Cells["content"].Style.ForeColor = Renk_Onemli_Forecolor; }
else if (dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() == ((int)specialStates.Soru).ToString()) { dataGridView1.Rows[e.RowIndex].Cells["content"].Style.BackColor = Renk_Soru_Backcolor; dataGridView1.Rows[e.RowIndex].Cells["content"].Style.ForeColor = Renk_Soru_Forecolor; }
}
}
|
|
|
|
|
Hi,
DataGridView may well be the most complex Control in the entire WinForms universe.
Cells have a DefaultStyle and a Style.
First row and/or first column may have different behavior (e.g. for column headers).
IMHO inside the CellFormatting handler you are expected to only alter the Value and the CellStyle fields of the DataGridViewCellFormattingEventArgs that is passed to you, and both apply to the cell that is invoking the handler.
If you need more than that, I'm afraid you may need to use explicitly created DataGridViewCellStyle objects for each cell you may want to alter the style of. You may want to start reading here: Cell Styles in the Windows Forms DataGridView Control | Microsoft Docs[^]
Anyhow, it may take quite some experimentation to tame the beast.
PS: if you don't have column headers right now, the easiest way out could well be to add them; that way you dont have actual data in row zero!
|
|
|
|