|
Hi, have a good day ,
I was wondering , how do you write Database Application With C# ?
I mean what is the your way , what tools do you use and what is your rules ?
--- For me :
1 - All My SqlConnection , DataTable Are in Runtime ( no desing at all )
2 - I write INSERT and update and delete Sql Query Manually , like functions ( even if I have 50 values in INSERT command I wrote them
as paramters
public static void DeletePerson ( string guid )
{
SqlCommand SqlCmd.CommandText ="DELETE FROM persons WHERE guid = @guid";
SqlCmd.Parameters.AddWithValue ("@guid" , guid);
SqlCmd.ExecuteNonQuery();
SqlCmd.Parameters.Clear();
}
3 - I always use paramters .
4 - I always use Transaction ( even for the short one )
5 - I never ever Use Binding Source ( I build one manually )
Like
TxtPerson.Text = clsDataTable.Rows[CurrentRecored]["Name"].ToString();
Insted of
TxtPerson.DataBindings.Add("Text" , bindingsource , "name" );
6 - I never use Identity in my database , I generte the last number
manually
SELECT MAX(PersonID) FROM persons
7 - All my tables recored dependes on GUID ( No Guid = No table at all )
8 - I use SQL Query Analyzer ... I hate VS Server Explorer ...
9 - For Complex Search Query
I used some routin's like :
public string[] SearchUserNames = { "Name" , "Age" };
public string[] SearchDBNames = { "pName" , "pAge"};
stQuery = "SELECT * FROM persons";
int isAnd = 0;
if (CheckName.Checked)
{
stQuery += " WHERE " + SearchDBNames[combobox.SelectedIndex].ToString();
isAnd++;
}
if (CheckAge.Checked)
{
if (isAnd != 0)
{
stQuery += " AND ";
}
else
{
stQuery += " WHERE ";
}
stQuery += SearchDBNames[combobox.SelectedIndex].ToString();
isAnd++;
}
I want to hear from you ... what is yours ?
I am doing right ?
Thank you , for time and for your advice ...
I know nothing , I know nothing ...
|
|
|
|
|
I do a lot of what you have said.
Isn't Max(PersonId) going to be very inefficient?
I have never had the need to do number 9. It looks too complicated IMHO, although I can see why you do it.
I always use using when I'm using databases though. eg.
using (SqlCommand command = new SqlCommand(sql, connection))
{
}
|
|
|
|
|
Have a look at the DatabaseAccessor[^] article.
If at first you don't succeed, you're not Chuck Norris.
|
|
|
|
|
Hi! I would like know how can I upload and delete video files saved in server using an aplication from client with webservices.
I was reading that I can use the class HttpFileCollection, class Uploader: IHttpHandler with the method ProcessRequest( HttpContext context ) or ftp.
What do you think? Any suggestion?
Thanks a lot. 
|
|
|
|
|
You can write any method you like in a webservice to send or deliver a stream of bytes. you may need to chunk large files tho.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
I would like to try attachments to be sent to WebServices.
You can find the details here[^] or google.
|
|
|
|
|
Thanks for the suggestions.
I used ftp. And no problem.
|
|
|
|
|
How to add scroll Horigental scroll bar in the call of DataGridView
Now each X seconds, the datagrid is updated with data from the database. So the datagridview is refreshed.
I also want to maintains the position of scroll bar even after datagridview is refreshed.
When a user is working on row X, and column Y, and the datagrid is refreshed all the scrollbars get back at position 0. So the horizontal scrollbar is put back to the left side of the screen, and the vertical scrollbar is put back on the top of the screen.
Raghvendra
|
|
|
|
|
int _xScrollPosition = dataGridView1.HorizontalScrollingOffset;
dataGridView1.HorizontalScrollingOffset = _xScrollPosition;
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hello,
I'having problems getting the "Taborder" right on a ToolBar which has a UserControl hosted in a ToolStripControlhost object.
To replicate:
1. Create a new WindowsForms project.
2 Add a toolBar with four ToolBarButtons to Form1 (via the designer)
3. Create a new UserControl and drop a MaskedTextBox on it (via the designer)
5. In the form Constructor add the following code;
toolStrip1.Items.Insert(2, new ToolStripControlHost(new UserControl1()));
During runtime if you click on the maskedTextBox in the toolStrip (to give it focus), and try to navigate with the tab key (either shifttab or tab) you'll notice a weird taborder.
If the MaskedTextbox is hosted directly in the ToolStripHostControl everything works fine. But my real usercontrol is way too comlicated to do this.
The problem seems to be caused by inserting a usercontrol in a toolstrip which messes up the taborder.
Does anyone know how to fix this? Any help would be sincerely appreciated.
|
|
|
|
|
The only thing I can think of is after adding UserControl1 go through first the toolstrip then usercontrol1 controls collection and manually set the tab order to what you want.
Other than that I've no idea. Perhaps someone else can help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks for your reply Henry.
I was thinking in the same direction...
But the only collection I could find to go through, are toolStrip1.Items[] and these do not have a TabIndex to reorder.
|
|
|
|
|
netogg wrote: these do not have a TabIndex to reorder.
That's a shame!
I hope someone else can help you.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
It seems the answer is to extend the ToolStripControlHost class as suggested here[^].
I've just tried it with your 'steps to reproduce' above and it worked fine. Code I used below.
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public class ToolStripUserControl1 : ToolStripControlHost
{
public ToolStripUserControl1() : base(new UserControl1()) { }
public UserControl1 UserControl1Control
{
get
{
return Control as UserControl1;
}
}
}
}
toolStrip1.Items.Add(new ToolStripUserControl1());
Hmm... It was adding it at the end so it appeared to work. Using Insert instead of Add to place it inbetween the buttons produces the same result as before 
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Hi Dave,
Thank you for your solution, I already came across the link your posted and tried several times.
I might be doing something terribly wrong...
When I try to "tab" trough the buttons its still messed up. When the focus is inside the UserControl then "tab" goes to the first button instead of to the next. And "shifttab" goes to the last button instead of the previous.
Would you mind posting your full solution please?
Thanks in advance.
@Dave at your comments suggesting insert: been there, tried that... sigh
modified on Friday, July 3, 2009 12:11 PM
|
|
|
|
|
This is annoying me so I'll have a further look at home tonight (UK) and see if I can work a solution.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Wow, thanks.
So far I've tried to add everything in the designercode, but nothing changes. Also am I looking into SelctNextControl en SelectPreviousControl, but I'd rather have the whole userControl self contained.
Anyway, Good luck!
|
|
|
|
|
No solution I'm afraid, but I have narrowed down the exact situation under which it occurs which could help to diagnose the cause and find a solution
Problem: It only happens when a UserControl is being hosted and that UserControl has a control(s) that can accept focus.
OK: If you use an empty UserControl or one that only has non focusable controls, it behaves as expected.
OK: If you host a TextBox (or any other edit control) directly, it also behaves as expected.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Thank you very much for your effort!
Anybody else on this issue? It shouldn't be that hard...you'd think.
|
|
|
|
|
I'd file it as a bug report on Microsoft Connect.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Hmmm, the process of bugreporting seems excruciating, frustrating and the average results too meager.
I'd be more interested in a workaround or fix.
If anyone else thinks this is worthy of reporting to Microsoft, I won't stop you and be thankful for it.
Kind regards to all you nice people.
|
|
|
|
|
Reported here[^]
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Have you got anywhere with this?
Microsoft have been able to reproduce it which is a good first step, but doesn't mean they have a fix or workaround for it of course!
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
They better ought to be able to reproduce it... I've been battling this for quite a while now. 
Thank you for reporting this, I must admit Microsofts reponse so far has pleasantly surprised me.
Still no luck in getting around this issue though.
Does anyone else know a solution for putting a complex compound control in a toolbar?
|
|
|
|
|
I have been trying this with a "compound"control on this same form as the toolbar is.
The compound control is a Panel with a Texbox inside (child control) on the very Form.
In the Form's Constructor i do;
toolStrip1.Items.Insert(2,new ToolStripControlHost(panel1));
With the same results. I think this narrows the bug to:
When using a ToolStripControlHost to host any ContainerControl with any focusable controls in a ToolStrip, tabbing between controls on the ToolStrip does not cycle through all controls.
You might wanna link Microsoft to here. Thanks again.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
