|
Hi. I have a form with a rtb and a database with a table. In tabel, I have a column where I have inserted a text. I want like when I run the form, that text to be inserted in rtb and start from a line that I give. I tried like this but unsuccessfully..
string citireLastChapter = "SELECT * FROM cursuri WHERE capitol = '" + SimulatorManager.CursuriCapitol + "'";
SQLiteCommand cmd = new SQLiteCommand(citireLastChapter, Conexiune.getConnection());
cmd.CommandType = CommandType.Text;
SQLiteDataReader read = cmd.ExecuteReader();
while (read.Read())
{
SimulatorManager.ArticolRamasCursuri = (int)read["articol_ramas"];
data = read["date"].ToString();
}
richTextBox1.Text = data.ToString();
lineCount = richTextBox1.Lines.Count();
int row = SimulatorManager.ArticolRamasCursuri;
int col = 33;
richTextBox1.MaxLength = richTextBox1.SelectionLength;
int matchPos = 0;
string[] newLines = richTextBox1.Lines;
if (newLines.Length >= row)
{
for (int i = 0; i < row - 1; i++)
{
matchPos += newLines[i].Length + 1;
}
richTextBox1.Select(matchPos + col -1, richTextBox1.SelectionLength);
richTextBox1.ScrollToCaret();
}
Anyway, code is crap..can you give me some ideas?
|
|
|
|
|
Your code is vulnerable to SQL Injection[^].
NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.
const string citireLastChapter = "SELECT articol_ramas, data FROM cursuri WHERE capitol = @capitol LIMIT 1";
using (SQLiteCommand cmd = new SQLiteCommand(citireLastChapter, Conexiune.getConnection()))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@capitol", SimulatorManager.CursuriCapitol);
using (SQLiteDataReader read = cmd.ExecuteReader())
{
if (read.Read())
{
SimulatorManager.ArticolRamasCursuri = (int)read["articol_ramas"];
data = read["data"].ToString();
}
}
}
richTextBox1.Text = data;
int row = SimulatorManager.ArticolRamasCursuri;
if (row >= 0 && richTextBox1.Lines.Length > row)
{
int startLineIndex = richTextBox1.GetFirstCharIndexFromLine(row);
int lineLength = richTextBox1.Lines[row].Length;
int col = 33;
if (lineLength > col)
{
startLineIndex += col;
lineLength -= col;
}
richTextBox1.Select(startLineIndex, lineLength);
richTextBox1.ScrollToCaret();
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
modified 15-Apr-15 14:15pm.
|
|
|
|
|
Hmm I see, thank for advice. I reveice:
Additional information: database schema has changed
near "1": syntax error
What that means in my context? The error is on line:
using (SQLiteDataReader read = cmd.ExecuteReader())
I tried to run it with the old code that selects data and it worked. Are there any syntax problems?
|
|
|
|
|
Sorry, looks like SQL Lite uses LIMIT rather than TOP .
I've updated the query in my previous message to:
const string citireLastChapter = "SELECT articol_ramas, data FROM cursuri WHERE capitol = @capitol LIMIT 1";
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thank you very much! Be blessed
|
|
|
|
|
Please help anybody if you know about Web Api
|
|
|
|
|
This is an extremely poor question. When you ask a question, you should be specific about the problem you are facing. Show us what code you have that isn't working, and explain clearly what issues you are seeing.
|
|
|
|
|
In the Object Oriented Debate, is C#.Net a purely object oriented language ? If yes what are the parameters of Object oriented,object based and purely object oriented language ?Please explain with examples.If no give the proper explanation.Thanks
|
|
|
|
|
Yes.
But...we do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.
Try it yourself, you may find it is not as difficult as you think!
If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
HI OriginalGriff I tried to find the answer from web,took help from book and asked to my seniors but you know the answer is contradict to each other.
I feel this may be a great place someone will help me but not sure I may be back with an empty hand
|
|
|
|
|
The idea of homework is that you think about it and form your own conclusions!
So why not explain what you think, justify it and we'll see if we agree? But us just writing it all out for you doesn't help anyone - least of all you.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
|
Can any one tell me best coding practises in c#?
|
|
|
|
|
MSDN is always great place to dig into C#.Net or any .Net compliant languages or technology. Thanks
|
|
|
|
|
There are different "practices" out there. You can use the SOLID principle, you can learn and follow design patterns or the practices of a technology like LINQ, WPF, WCF, ... (by reading the book and following the advice). Personally, I keep everything in an N-tier format (feel free to read my articles 1[^] and 2[^] on that topic) and I like to follow the K.I.S.S. principle and the golden rule of "if it's not broken, don't fix it" see my other article[^]).
The absolute most important rule you should always follow in programming : Stay consistent.
Be it in programming style, naming conventions, commenting style, design style, or whatever ...
Mostly you will not use "one best practice", but rather a mix of several things that just work for you.
Read up on all the key words and find your own way young padawan.
hope this helps.
|
|
|
|
|
|
sure....
modified 15-Apr-15 3:35am.
|
|
|
|
|
Also try to implement that in your day to day coding.
Then only you can understand practically.
Hope this will help you
|
|
|
|
|
Message Removed
modified 15-Apr-15 1:14am.
|
|
|
|
|
I want to know generic interface and generic delegates in simple terminology.In MSDN so many things are there but please clerar it in simple words
Gyan
|
|
|
|
|
Okay. Before covering what they are, let's establish the level you are at with regards to C# so that we don't assume you know something you don't. Do you know what generics are? Do you understand them?
|
|
|
|
|
Yes I know generic well as well as I know Interface and delegate well.
|
|
|
|
|
Okay so a generic interface is, at its most basic level, an interface that has a generic element to it. In other words, the signature of the interface means that it can be used for different types. Consider this interface:
public interface IPersist<T>
{
void LoadLayout(T instance);
void SaveLayout(T instance);
} Suppose we have a class that looks like this:
public class MyModel
{
public string Name { get; set; }
public string FriendlyName { get; set; }
public DateTime LastLogin { get; set; }
} Now, we want to write a class that performs the persistence for this class. Let's write it like this:
public class MyModelPersistence : IPersist<MyModel>
{
public void LoadLayout(MyModel instance)
{
}
public void SaveLayout(MyModel instance)
{
}
} A common use of generic interfaces is in providing the interface definitions for generic collections such as List<T> .
Now, where things get really interesting is when it comes to covariant and contravariant interfaces. I will direct you to the discussion here[^]. The discussion around the zoo is an excellent example of using co and contra variance.
Similar to a generic interface, a generic delegate is one that uses the generic parameter to create a strong type (basically, by giving it a Type, you remove the need to use object as the delegate type, thus removing the need to perform boxing/unboxing to get the value of the parameter).
|
|
|
|
|
I hate you yoda! that simple description of generic interfaces makes we want to revisit my data layer and see if it is a viable change to the approach I use now
otherwise +5 for a simple explination
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
My way of doing things changed to thinking like this once I really got into SOLID as a discipline.
|
|
|
|