I can not understand the error.....code bellow...for trans data from sql database to another
-
Specified cast is not valid.
-
this is debugger error(Specified cast is not valid.)
So use the debugger to look at the value of that cell and find out what type of data it contains. When you know that, you can start looking at why it isn't a boolean value. We can't do that for you: we can't run your code, and don't have your data which fills the table if we could!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
So use the debugger to look at the value of that cell and find out what type of data it contains. When you know that, you can start looking at why it isn't a boolean value. We can't do that for you: we can't run your code, and don't have your data which fills the table if we could!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
did you have a time to take a look via teamviewr
-
did you have a time to take a look via teamviewr
Are you clinically insane? You would allow total strangers you never met to remotely control your PC? Have you any idea what some of them might do? Have you ever heard of ransomware? If you have that enabled, disable it immediately! Use the debugger. Look at the cell content. It should tell you a lot.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
Are you clinically insane? You would allow total strangers you never met to remotely control your PC? Have you any idea what some of them might do? Have you ever heard of ransomware? If you have that enabled, disable it immediately! Use the debugger. Look at the cell content. It should tell you a lot.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
no i'm not clinically insane.... but we are in a community to help each author.and i'm stacked.
-
no i'm not clinically insane.... but we are in a community to help each author.and i'm stacked.
We are in a community to help each other, but you have no idea who people are, and what they are going to do. This is the real world, and leaving your machine open for total strangers to access and do whatever they want - and if you give them access to VS that's exactly what they can do - is not "asking for trouble" it's inviting it indoors, giving it a beer, and telling it where you keep your credit cards! :laugh: Be realistic and honest: you know how to use the debugger, don't you? (If you don't, then say so and we'll try to get you started. But not telling us relevant information is just wasting your own time, as well as ours)
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
We are in a community to help each other, but you have no idea who people are, and what they are going to do. This is the real world, and leaving your machine open for total strangers to access and do whatever they want - and if you give them access to VS that's exactly what they can do - is not "asking for trouble" it's inviting it indoors, giving it a beer, and telling it where you keep your credit cards! :laugh: Be realistic and honest: you know how to use the debugger, don't you? (If you don't, then say so and we'll try to get you started. But not telling us relevant information is just wasting your own time, as well as ours)
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
many thanks for your advice and your time.
You're welcome!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
You're welcome!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
i get my issue.... i need to get the value from DataGridView that was selected into array. can you write to me example code.
-
i get my issue.... i need to get the value from DataGridView that was selected into array. can you write to me example code.
Sorry, but I don't understand what you said: remember I only get exactly what you type to work from. Can you explain in more detail, perhaps?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
Sorry, but I don't understand what you said: remember I only get exactly what you type to work from. Can you explain in more detail, perhaps?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
i need code for get selected column value from datagridview into array list //foreach (DataGridViewRow row in this.dataGridView1.Rows) //{ // if ((((bool)(row.Cells[this.invoiceNO.Index].Value)) == true)) // { // a.Add(row.Cells[this.invoiceNO.Index].Value); // } //}
-
i need code for get selected column value from datagridview into array list //foreach (DataGridViewRow row in this.dataGridView1.Rows) //{ // if ((((bool)(row.Cells[this.invoiceNO.Index].Value)) == true)) // { // a.Add(row.Cells[this.invoiceNO.Index].Value); // } //}
The problem is that you aren't thinking about what is going on here: the value you are casting to a bool is not a bool value, so the cast fails: that can't be "fixed" at that point - you need to find out what it actually is and why it isn't the value you are expecting. And the only way to do that is to use the debugger while your code is running and look at what the actual data looks like. No amount of code I could give you would fix that - because either the index is wrong, the data is wrong, the table isn't organised as you think it is, or it's totally the wrong table. We can't tell you which of those: but the debugger probably can almost instantly!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
private void exprtbtn_Click(object sender, EventArgs e)
{
try
{
if ((this.dataGridView1.Rows.Count == 0))
{
MessageBox.Show("Please select Vouchers");
}
else
{
// HEaders Vouchers
SqlConnection con = null;
SqlConnection con2 = null;
connClass cs = new connClass();
con = new SqlConnection(cs.distiConn1);
con2 = new SqlConnection(cs.sourceConn2);ArrayList a = new ArrayList(); DataTable DT = new DataTable(); SqlCommand cmd = new SqlCommand(); SqlTransaction trans = default(SqlTransaction); con.Open(); trans = con.BeginTransaction(); cmd.Connection = con; cmd.Transaction = trans; SqlCommand cmdLive = new SqlCommand(); cmdLive.Connection = con2; SqlDataAdapter DR = default(SqlDataAdapter); //foreach (DataGridViewRow row in dataGridView1.Rows) //{ // if ((bool) row.Cells\[this.invoiceNO.Index\].Value == true) // { // a.Add(row.Cells\[this.invoiceNO.Index\].Value); // } //} //foreach (DataGridViewRow row in this.dataGridView1.Rows) //{ // if ((bool)row.Cells\[this.invoiceNO.Index\].Value == true) // { // a.Add(row.Cells\[this.invoiceNO.Index\].Value); // } //} error in the anderline code foreach (DataGridViewRow row in this.dataGridView1.Rows) { if ((((bool)(row.Cells\[this.invoiceNO.Index\].Value)) == true)) { a.Add(row.Cells\[this.invoiceNO.Index\].Value); } } int C = a.Count; string str = "("; int i = 0; while (i < C - 1) { str += "'" + a\[i\] + "',";As long as you keep mixing "business logic" in with your "data access" logic, your life will continue to be difficult. You are simply copying and pasting each "case", without any thought to the amount of duplicate code you are creating. I would tell you to rewrite what you've got instead of helping you to "fix" it (and continuing to support your bad habits). Or are you getting paid by lines-of-code?
