|
I still didn't quite get what purpose that connection should serve. Suggestions:
- Removing/commenting the code that opens/closes the connection
- Using it like this instead:
using (var conn = new MySqlConnection("server=localhost;user id=localhost;password=localhost;database=localhost;pooling=false"))
{
conn.Open();
}
- Make sure you're building your solution in debug configuration
- Rebuilding the solution (Build > Rebuild solution)
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
Just tried both, still no difference, It is really annoying..
|
|
|
|
|
Also, the purpose of the connection is that the program is mean't to sync data into a mysql database, but I just haven't coded it all in yet.
|
|
|
|
|
I'm out of ideas, atm. Maybe someone else has another idea..
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
i need help regarding this,
i want to keep datageridview cell in edit mode even any arrow key is pressed,
it should only exit edit mode on enter or on tab key.
|
|
|
|
|
If you haven't already, create a custom class deriving from DataGridView and override the method ProcessCmdKey. In that method you can check if the key that is pressed is one of the arrow keys and inhibit its normal effect by not calling the base implementation:
public class MyDataGridView : DataGridView
{
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if (keyData == Keys.Left ||
keyData == Keys.Right ||
keyData == Keys.Up ||
keyData == Keys.Down)
{
return true;
}
return base.ProcessCmdKey(ref msg, keyData);
}
}
If you need help on how to use such a subclassed Control in your Form/Project, please see here:
Override datagridview_keypress method[^]
(It addresses overriding the OnKeyPress-method but apart from that it's all the same.)
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
|
|
Dear Experts,
I have datagridView with tow columns.
I use the below code to get value from Cell the cursor left, but when cursor left for first time, even if I filled a value, the message box give me "Blank" notjing, but if I returned to the cell and leave it again, then message give me the Value. I have searched in google, but with no result.
private void dataGridView1_CellLeave(object sender, DataGridViewCellEventArgs e)
{
string x = (string)dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
MessageBox.Show(x);
}
Your help please.
Ahmad,
|
|
|
|
|
Just subscribe to the CellValueChanged[^]-event instead of the CellLeave-event.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
put datagridview1.EndEdit() above
string x = (string)dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
statement
|
|
|
|
|
It is working, Thank you 
|
|
|
|
|
Currently i have painted top portion of a panel as header for this panel but if in design time I am setting a child control inside that panel as dockstyle bottom while resizing this control is overriding panel of that header.so I want header should be always on top or over the child controls
Pls help me
|
|
|
|
|
Sorry?
Perhaps punctuation would help...
Stop just typing as fast as you can, and thing about the people who have to read your question: that is all we get to work on. We can't see your screen, we can't access your hard disk, and we can't read your mind!
So explain in some detail what you expect to happen, and what did occur. Sometimes drawing little "ASCII-art" pictures can help:
_____
| 1 | 1 - Header
|-----|
| |
| 2 | 2 - Rest of panel
| |
----- And then drawing others to show what you expected, and got.
And relevant code fragments help as well!
The better the info you give us, the better the response we can give you.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Add a new panel to your panel. Have it dock to "top". Make it as high as the header should be. Paint the new panel as if it is the header.
When adding a control, add it to the original pannel, using dock set to "fill". May require an additional BringToFront or SendToBack.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi, If change EmployeeName in dropdownlist I can Get clientState value have empId in mvc DayPilot Calendar Current control.It will work. If i navigate to Day or Month view then DayPilot control cannot update Event of Employee and Client state is 0.
Here my Coding
In Jquery...
$(#ddlProviderSched).change(function () {
var ProviderId = $(this).val();
if (ProviderId != null) {
switcher.active.control.clientState.ddlProviderSched = ProviderId;
switcher.active.control.commandCallBack(refresh);
}
})
in C# MVC Controller Page....
protected override void OnCommand(DayPilot.Web.Mvc.Events.Month.CommandArgs e)
{
switch (e.Command)
{
case "navigate":
StartDate = (DateTime)e.Data["day"];
Update(CallBackUpdateType.Full);
break;
case "refresh":
Update(CallBackUpdateType.EventsOnly);
break;
case "delete":
new EventModel().EventDelete((string)e.Data["e"]["id"]);
Update(CallBackUpdateType.EventsOnly);
break;
//case "filter":
// string Provider1 = (string)e.Data["Provi"];
// Events = new EventModel().FilteredData(StartDate, VisibleEnd, Convert.ToInt32(Provider1)).AsEnumerable();
// Update(CallBackUpdateType.Full);
// break;
}
}
protected override void OnFinish()
{
if (UpdateType == CallBackUpdateType.None)
{
return;
}
//Events = from e in dc.TimesheetRecords where e.EmployeeId == employee select e;
int Provider = SelectedEmployee();
Events = new EventModel().FilteredData(VisibleStart, VisibleEnd,Provider).AsEnumerable();
DataIdField = "Id";
DataTextField = "Reason";
DataStartField = "eventstart";
DataEndField = "eventend";
}
public int SelectedEmployee()
{
if (ClientState["ddlProviderSched"] != null)
{
var ProId = (string)ClientState["ddlProviderSched"];
return Convert.ToInt32(ProId);
}
else
return 0;
}
|
|
|
|
|
|
I have a sqlite database protected by password and I can't use it in query. How should I modify the code to read data from a protected database?
private static string conn = @"Data Source=aplicatie.db;Pooling=true;FailIfMissing=false;Version=3;Password=example";
An example with query:
string selectutilizator = "SELECT username,prenume,licenta FROM accounts";
SQLiteCommand selcom = new SQLiteCommand(selectutilizator, Conexiune.getConnection());
selcom.CommandType = CommandType.Text;
using (SQLiteDataReader read = selcom.ExecuteReader())
{
if (read.Read())
{
SimulatorManager.Nume = (string)read["username"];
SimulatorManager.Prenume = (string)read["prenume"];
SimulatorManager.Utilizator = SimulatorManager.Nume + " " + SimulatorManager.Prenume;
}
}
Error is:
file is encrypted or is not a database
|
|
|
|
|
Are you sure that the password is correct?
|
|
|
|
|
My next stupid question is: How should I suppose to set a password for sqlite database? ) Cause obviously I don't know how..I thought that I just have to set there a password..
|
|
|
|
|
Speaking for myself, I would start by reading the documentation.
|
|
|
|
|
DPaul1994 wrote: How should I suppose to set a password for sqlite database?
private static string conn = @"Data Source=aplicatie.db;Pooling=true;FailIfMissing=false;Version=3;Password=example"; What happens if you connect using this to a non-existing file?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
As Richard says, the wrong password is the most obvious problem.
Other possibilities are:
1) It's not an SqLite database at all - ".db" is a common enough extension that it could be a different application
2) It's SqLite, but from a different version - check that the DLLs you are using to access it are the latest version, and that you didn't create it in a later application.
If in doubt, it's worth setting up a connection in Visual studio via the Server Explorer pane - if "Connect to Database" doesn't list SqLite then see here: http://stackoverflow.com/questions/19665370/missing-sqlite-data-provider-in-vs-2013[^]
Once you have a working connection in VS, you can get a "good" connection string in the Properties Pane.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I have a new pc and installed new software. Visual Studio 2013 and SQL Server 2014. My old pc had VS 2010 and SS 2012.
Now I have the problem that I created code for working with DTS packages. Worked perfect on the old pc. But the dll is in the GAC of Windows. My new pc has a newer version and won't work. The problem is, that the server where it has to be hosted, also works with the old verion (SS 2012)
I tried to copy the old dll from the GAC and reference it in my new environment, but without luck.
I cannot imagine that I have to install the old software as well on my new pc. I mean, what do you do when your customer has older or newer version in GAC. You must be somehow able to program for that situation.
Anyone any ideas?
|
|
|
|
|
Well, I would suggest you to have a virtual machine on your new PC(VMWare free version). Install all that old software and save the VM on an external drive. This will make it ready to use as and when required.
Your customer will keep coming back to you to get this stuff fixed. This way, you just have to boot your virtual machine and get the job done.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
