|
I'm sorry but the main forums are English language only. Could you please translate your question?
|
|
|
|
|
INSERT the dates in the database access ( not Generating One new)
OleDbConnection cn = DataBase.CreaConnessione();
OleDbDataAdapter ad = new OleDbDataAdapter();
Operai o = new Operai();
private void Form2_Load(object sender, EventArgs e)
{
}
private void btnentrata_Click(object sender, EventArgs e)
{
txtentrata.Text = DateTime.Now.ToLongTimeString();
OleDbCommand cmd = cn.CreateCommand();
cmd.CommandText = "INSERT INTO operai (nome,cognome,entrata) VALUES ('" + this.txtnome.Text + "','" + this.txtcognome.Text + "','" + this.txtentrata.Text + "')";
cmd.CommandType = CommandType.Text;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
private void btuscita_Click(object sender, EventArgs e)
{
txtuscita.Text = DateTime.Now.ToLongTimeString();
OleDbCommand cmd = cn.CreateCommand();
cmd.CommandText = "INSERT INTO operai (nome,cognome,uscita) VALUES ('" + this.txtnome.Text + "','" + this.txtcognome.Text + "','" + this.txtuscita.Text + "')";
cmd.CommandType = CommandType.Text;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
|
|
|
|
|
Your code is vulnerable to SQL Injection[^].
NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.
To update the same row, you will need to retrieve and store the ID from the new row, and then issue an UPDATE statement:
private int? _id;
private void btnentrata_Click(object sender, EventArgs e)
{
using (OleDbConnection cn = DataBase.CreaConnessione())
using (OleDbCommand cmd = cn.CreateCommand())
{
cmd.CommandText = "INSERT INTO operai (cognome, nome, entrata) VALUES (?, ?, ?)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("p0", txtcognome.Text);
cmd.Parameters.AddWithValue("p1", txtnome.Text);
cmd.Parameters.AddWithValue("p2", DateTime.Now);
cn.Open();
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT @@IDENTITY";
cmd.Parameters.Clear();
_id = (int)cmd.ExecuteScalar();
}
}
private void btuscita_Click(object sender, EventArgs e)
{
if (_id == null)
{
throw new InvalidOperationException("Row not created!");
}
using (OleDbConnection cn = DataBase.CreaConnessione())
using (OleDbCommand cmd = cn.CreateCommand())
{
cmd.CommandText = "UPDATE operai SET uscita = ? WHERE ID = ?";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("p0", DateTime.Now);
cmd.Parameters.AddWithValue("p1", _id);
cn.Open();
cmd.ExecuteNonQuery();
}
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I'm doing SMS system.Unable to load DLL "dllforvc.dll": The specified module could not be found. (Exception from HRESULT: 0x8007007E).
|
|
|
|
|
That's telling you that it cannot find either dllforvc.dll or another DLL in its dependency chain. In cases like this, I would look to use this[^] to help find what's missing.
|
|
|
|
|
I think dllforv.dll is worry. Do you have available dllforvc.dll?
|
|
|
|
|
|
I ask you to help me transfer code below into C#2008 to C#2005 ?, which takes the form type class DataClass.cs
[CODE]
// Example 1:
private void PopulateArr(DataClass[] tmpArr)
{
for (int i = 0; i < 3; i++)
{
tmpArr[i] = new DataClass() { DoubleValue = seed++ }; //error this place
}
}
//Example 2:
/// public static implicit operator DataClass(double? othaNumba)
/// public static implicit operator DataClass(double othaNumba)
/// can you explain why the declaration on (Example 2a and 2b) parameters included in the question mark and no question mark ?
// Example 2a:
public static implicit operator DataClass(double? othaNumba)
{
return new DataClass() //error this place
{
DoubleValue = othaNumba == null ? null : (double?)Convert.ToDouble(othaNumba) // error this place
};
}
// Example 2b:
public static implicit operator DataClass(double othaNumba)
{
return new DataClass() // error this place
{
DoubleValue = othaNumba == null ? null : (double?)Convert.ToDouble(othaNumba) // error this place
};
}
// Example 3:
private void filterControl1_BeforeShowValueEditor(object sender, ShowValueEditorEventArgs e) // error this place
{
GridFilterColumn currentColumn = e.CurrentNode.Property as GridFilterColumn;
if (currentColumn != null)
{
e.CustomRepositoryItem = currentColumn.GridColumn.ColumnEdit;
}
}
// Error 13 The type or namespace name 'ShowValueEditorEventArgs' could not be found
// (are you missing a using directive or an assembly reference?)
[/CODE]
|
|
|
|
|
Normal Value Type variables cannot contain null values - but C# allows you to create a version that can called a Nullable Type[^] by appending a "?" to the type name when you declare the value - the link explains all this.
The rest of the code you show is pretty much rubbish: it amounts to
If the value is null, return null.
Otherwise, convert the double value to a double, then cast it to a nullable double.
Why?
The original value is a double, which can't be null (because it's a Value Type) so just cast it to a nullable double anyway...
And your other example is equally ridiculous.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Examples 1 and 2 are using object initializers[^], which were introduced with VS2008. To compile the code in VS2005, you'll need to use the older initialization syntax. For example:
tmpArr[i] = new DataClass { DoubleValue = seed++ };
DataClass temp = new DataClass();
temp.DoubleValue = seed++;
tmpArr[i] = temp;
Example 3 appears to be related to a DevExpress component. Either you're missing a reference to the component, or you're missing a using directive for the namespace, or you're using a different version of the component in your VS2005 code.
Is there a reason you're using VS2005, when VS2013 Community Edition[^] is available free of charge?
And for future reference, when you're posting a code block, this site doesn't use [CODE]...[/CODE] tags. Use either <pre> tags or fenced code blocks to format your code:
<pre>
Your code here
</pre>
Or:
```
Your code here
```
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
The first of all thank you for answering me, now I want to convert the code example 2 (2a and 2b included) to C# 2005 I will write again how ?
|
|
|
|
|
I am working on C# Project [Windows Form Application], to update treeview nodes from excelsheet [xls] Cell [row i, Column 3] Values, while on selecting treenode, it should update corresponding Column 4 Value [row i, Column 4]. For me, Treenode are populated successfully, but on selecting the treenode, it always display first Element of treenode [Not selected one].
Populated Treenode from Excel as: [ Update Child Nodes from Column 3 elements [Column 2 Contain Parent node name and Column 3 have Child Node name], if Column 2 Value is same as Parent node name [My Module], update the child nodeunder same Parent node.]
for (int i = 0; i < worksheet.UsedRange.Rows.Count; i++)
{
string mynode = ((Excel.Range)worksheet.Cells[i + 1, 3]).Value2.ToString();
string mynode2 = ((Excel.Range)worksheet.Cells[i + 1, 2]).Value2.ToString();
if (mynode2 == mymodule)
{
TreeNode ChildNode = ParentNode.Nodes.Add(mynode);
ChildNode.Text = mynode;
}
}
On selecting the Child Node, it always give 1st Parent node. Instead of Selected Node.
for (int i = 0; i < worksheet.UsedRange.Rows.Count - 2; i++)
{
string mynodetext = ((Excel.Range)worksheet.Cells[i + 2, 3]).Value2.ToString();
string mynodetext1 = ((Excel.Range)worksheet.Cells[i + 2, 4]).Value2.ToString();
if (treeView1.SelectedNode.FirstNode.Text == mynodetext)
{
this.richTextBox1.SelectedText += Environment.NewLine + mynodetext1 + Environment.NewLine;
}
}
Please Guide, How to get correct selected Node.
|
|
|
|
|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace webbrowser2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
webBrowser1.Navigate(http://SomeWebiste.com);
}
private void button1_Click(object sender, EventArgs e)
{
HtmlElementCollection links = webBrowser1.Document.GetElementsByTagName("a");
foreach (HtmlElement link in links)
{
try
{
if (link.InnerText.ToString() == "How to change ip in webBroswer control?")
{
link.InvokeMember("Click");
break;
}
}
catch { }
}
}
}
}
How to spoof ip when I click specific link on "some website" with proxy ip list on my computer ?
I have implemented the code with webBroswer control like above but I don't know how to spoof the ip with proxy ip lists.
Any helps would be apppreciated
Thank you
modified 22-Apr-15 12:45pm.
|
|
|
|
|
I am not sure I understand the question, but I assume you just use the IP address instead of the URL, like:
webBrowser1.Navigate("http://173.194.67.106");
|
|
|
|
|
Sorry my English is too bad so you didn't understand what I wanted to say.
I wanna spoof my ip whenever I click the link on "Some webiste" with proxy ip lists.
Can you help me?
Thank you
|
|
|
|
|
hapiten wrote: Can you help me?
Sorry, no. I have no idea how to do that, and I am not sure it is legal.
|
|
|
|
|
hapiten wrote: How to spoof ip when I click specific link on "some website" with proxy ip list
on my computer ? I have implemented the code with webBroswer control like
above but I don't know how to spoof the ip with proxy ip lists.
Do you want to redirect the user to some other IP if he clicks a link in your webbrowser?
If yes, research how to build your own proxy-server using C#.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I want to update a column from table but I receive: database is locked twice. The error accours only when I call updateIndex() function. Why? This is the complete code:
Load function:
private void MediuInvatare_Load(object sender, EventArgs e)
{
using (Conexiune.getConnection())
{
string select = "SELECT * FROM questions WHERE id = indexrow LIMIT 1";
using (SQLiteCommand cmd = new SQLiteCommand(select, Conexiune.getConnection()))
{
cmd.CommandType = CommandType.Text;
using (SQLiteDataReader rdra = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
try
{
while (rdra.Read())
{
textBox1.Text = rdra["question"].ToString();
idintrebare = Convert.ToInt32(rdra["id"]);
}
rdra.Close();
}
catch (InvalidOperationException ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
Function where is the problem (I guess):
private void updateIndex()
{
string update = "UPDATE questions SET indexrow='" + idintrebare + "' WHERE id='" + idintrebare + "'";
SQLiteCommand comp = new SQLiteCommand(update, Conexiune.getConnection());
comp.CommandType = CommandType.Text;
comp.Parameters.AddWithValue(idintrebare.ToString(), idintrebare);
SQLiteDataAdapter da = new SQLiteDataAdapter(comp);
DataTable dt = new DataTable();
da.Fill(dt);
}
Button where updateIndex() is called:
private void button1_Click(object sender, EventArgs e)
{
try
{
updateIndex();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
|
|
|
|
|
|
1) For Insert-, Update- and Delete-Statements you should use the ExecuteNonQuery()-method of the Command-object.
2) Though you initialized an Sql-Parameter and added it to the Command-object, you didn't adjust your Sql-Statement accordingly and you used the value of your variable idintrebare as the name for the parameter.
3) As CommandType.Text is the default, you don't have to explicitly set it.
4) Use disposable objects (the Connection and Command here) in a using-Block. See this Article: IDisposable: What Your Mother Never Told You About Resource Deallocation[^]
5) idintrebare appears to be a class-member. I would suggest you call updateIndex() with idintrebare as an argument instead. As I don't know the type of it, I'll use int here, please adjust that if neccessary.
This should work:
private void updateIndex(int id)
{
string update = "UPDATE questions SET indexrow=@idintrebare WHERE id=@idintrebare;";
using (var connection = Conexiune.getConnection())
using (SQLiteCommand cmd = new SQLiteCommand(update, connection))
{
connection.Open();
cmd.Parameters.AddWithValue("@idintrebare", id);
cmd.ExecuteNonQuery();
}
}
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
First, thank you for suggestions. So: Conexiune is a class. getConnection() is a function that makes the connection and return true if connection is opened. So I can't use that var connection. I used this code in other forms and it worked..I want to update indexrow column with the value of int variable idintrebare..So I rewrite your code like this:
string update = "UPDATE questions SET indexrow=@idintrebare WHERE id=@idintrebare;";
using (var connection = Conexiune.getConnection())
using (SQLiteCommand cmd = new SQLiteCommand(update, connection))
{
connection.Open();
cmd.Parameters.AddWithValue("@idintrebare", idintrebare);
cmd.ExecuteNonQuery();
}
,but I receive Operation is not valid due to the current state of the object.
Conexiune class looks like this: (This is good)
private static string conn = @"Data Source=database.db;Pooling=true;FailIfMissing=false;Version=3;";
public static SQLiteConnection connect = null;
private Conexiune() { }
public static SQLiteConnection getConnection()
{
SQLiteConnection connect = null;
try
{
connect = new SQLiteConnection(conn);
connect.Open();
return connect;
}
catch (SQLiteException e)
{
throw new Exception("Cannot connect", e);
}
}
|
|
|
|
|
getConnection() returns an SQLiteConnection (not true/false).
So you can use that using (var connection = Conexiune.getConnection()) -line.
But as I see in that Conexiune-class, it already opens the connection for you. So the (new) error you're getting probably happens on my connection.Open() -line. Please remove that line and see what happens.
As I've seen from your reply to Richard Deeming, who suggested almost the same new code as me, you still get the old error there. This makes me believe the cause is one of those listed on the page that Simon_Whale linked for you. Do you maybe have an open Select-query while you click on the button that calls updateIndex() ?
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
I removed that line and now database is still locked. Well, I have another function which selects data from table and is called by pressing on another button, but even if I don't press that button and try to call updateIndex() just after form loads, I still got the error..
|
|
|
|
|
Do you possibly have some Select-query that is executed in your program's startup-code (so it get's executed no matter what) ? If yes, you might comment that out for testing. Maybe you don't close the reader of that query properly so that it's still open when trying to execute updateIndex().
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
I am sure..Where I have used DataReader, I used CommnadBehavior.CloseConnection and after that I closed the reader. For example:
string selectareLicenta = "SELECT licenta FROM licente WHERE licenta = '" + maskedTextBox1.Text + "'";
using (SQLiteCommand cmd = new SQLiteCommand(selectareLicenta, Conexiune.getConnection()))
{
using (SQLiteDataReader read = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
if (read.Read())
{
SimulatorManager.Licenta = read["licenta"].ToString();
}
read.Close();
}
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
