|
Yanshof wrote: Without writing my own code ?
I love comments like this on a development site. (No disrespect to Yanshof here...)
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
Yanshof wrote: Is there is no other way ?
Without writing my own code ?
OK - this is a developer site. Surely this is exactly the type of challenge you would want to rise to.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
My application is connected with access database called BaseStudents!
This database have table with name: tblSudents. The first field in table
tblStudents is "StudentID" type:number(long int) and also primary key,
second field is "Name of Student" etc...
So my problem is, when my application will insert some data in table 'tblStudents'
it would look like this:
StudentID Name
1 Jack
2 Tom
3 Mike
4 Peter
5 Paul
6 Maria
7 Jean
8 David
9 Jesse
10 Vik
11 Alex
.....
Then, my application can delete from this table, but if someone
delete records with number: 2,3,4,5,6,7,8
the table 'StudentID' it would look like this:
StudentID Name
1 Jack
9 Jesse
10 Vik
11 Alex
Is there a way,when I delete records, the field 'StudentID'
to have a value: 1,2,3,4,5,...
I mean after deleting the table to look like this:
StudentID Name
1 Jack
2 Jesse
3 Vik
4 Alex
to renumber StudentID, to sequence number, not 1,8,9,10!
Second question:
I need help with select statement...
I know UPDATE,DELETE, INSERT, but SELECT with condition
like this(when I press button "Select", to execute code below)
"SELECT StudentID, Name, FatherName, LastName, years FROM [tblStudents]" + " WHERE Name=" +comboBoxName.Text+", FatherName="+comboBoxFatherName.Text+", LastName=" +comboBoxLastName.Text+", years=" +comboboxYears.Text+";";
So I want to select data who is equal from database tblStudents, and the data who user of my application
will pick from the comboBoxes.First, user pick value from comboBoxes, then press button "select"
and "selected" data should appear in dataGrid or dataView...
Is this correct?
Is this possible?
Please, if you have a free time and if you want to help me, reply to me...
All the best, from c# begginer to c# advanced...
sorry for bad english
kpp
|
|
|
|
|
I recommend you buy a book on SQL and work through it.
replace your , with the word AND, put quotes around the strings, and then it will probably work.
If you have SQL Server, read the books that come with it, they cover all this basic SQL stuff.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Yes, but how to put this data in datagrid or dataview
kpp
|
|
|
|
|
Buy a book or use Google. There are only about 1 million examples.
__________________________
Don't drink and derive.
Alcohol and calculus don't mix.
|
|
|
|
|
Some people like to be spoonfed. They can't (or don't want to) look for stuff that's already there.
ROFLOLMFAO
|
|
|
|
|
Hi,
Is there any good way to handle large file (typically 2Gig)? I prefer to read block by block and upload into GUI.
How it will work out ?
|
|
|
|
|
I think that you can read it fast enough with Streamreader. But I don't know what the results will be for your memory...
If you are intending to pass this info into a database. You might wanne create a Data Transformation Service
(DTS) package for the (bulk) insert. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_21rn.asp
For the rest I want to suggest you, because you specified GUI, that while reading to a GUI, you don't update/redraw the GUI, because this will slow down the whole process. When passing them to a listview, the good way is:
listview1.BeginUpdate()
READ + ADD TO LISTVIEW1
listview1.EndUpdate()
Good luck, if not satisfied, please provide more details on your project.
|
|
|
|
|
If you're using a 32 bit version of windows, the maximum memory space for an application is 2gig (3 if you fiddle some system settings), so you might find you can't hold the whole file in memory
|
|
|
|
|
Dear Mr and Ms !
I am using C# 2005,
I can not input date type with format 'dd/MM/yyyy' in Datagridview control.
Please help me.
Thank so much !
Thomas
|
|
|
|
|
how to tranfer file using Filestream through sockets using UDP in c#..?
I've tried file streaming but at Recieving End i m unable to get the byte recieved in my recieving buffer as RecieveBuff.length() gives the length of buffer but not the total bytes recieved in buffer.
ForExample at rcving end length of buff is 8KB but if last sending packet is of 2KB then how Could I retriev just 2KB as it append the 6KB of garbag data into buffer.
SO PLZ HELP ME OUT ASAP.
Thanx.
Shanzay
|
|
|
|
|
I want to use connection pooling in my application.
its a multithreaded application. every thread open is querying database with different sql statement.
If i use connection pooling here will it create any problems? like giving wrong results
aparna
|
|
|
|
|
Think in Datareaders. If you use it,you open, read and time after you close it. If in this period you try to open another from other thread you will get an exception.
Visit my blog at http://dotnetforeveryone.blogspot.com/
|
|
|
|
|
Hi - this is actually the third time you came to this site asking the same question.
It looks like you really need to post to a Crystal Reports forum not a C# forum. Have a search on google to see what you can find.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
If the OP who just deleted his post is still around - please don't delete above a thread - it messes up the forum.
I wasn't being unjust - I just didn't want you wasting your time asking the same question in the same place many times and not getting any results.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
I am not too clever, if I was, I would have answered your original question. I use what ability I have to the best of it. Always. I was simply trying to help - it is pointless posting the same question over and over.
I hope you find your answer, and if you do, write an article for Code Project on Guntt Gantt Charts in Crystal Reports for C# - thereby helping others.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
This is no different to putting urgent plz help in the title. You are not being polite to other posters by doing this because you are assuming that your post is more important than theirs. Just because it is the most important thing that you are dealing with, doesn't make it any more important or urgent than things that other people are dealing with.
This site is volunteer only. If you feel that you really need this information ASAP then you need to consider paying for a support call with Business Objects (or Crystal Reports - or whatever they are calling themselves now). That way, you can guarantee that people will take a look at your problem ASAP.
The problem that you now have is that people know that you repeat post the same issue. This meanst that people are more likely to ignore your posts because they think that they are a repeat of things that have already been posted about.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hai Every body,
Can any one tell me how to create a html file for the contents in the rich text box.
Also can you tell me how to bold the selected text of the rich text box.
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
Get it
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Hi,
I have some Static label or Some Rich Text label that i set to it in Run Time some String.
In case the string is too long ( the size of the Static label or the Rich Text label is not auto size ( i mean that the size is const ) ) there will be some Tool Tip with the all string.
My question is ... how can i know if the string is too long ?
Is there is some way ?
Thanks for any help.
|
|
|
|
|
class myClassThatHoldsTheString
{
const int _myToolTipLength = 50;
private string _myTooltip;
public string MyTooltip
{
get { return _myTooltip;}
set {
if (_myTooltip== value)
return;
if (value.Length > _myToolTipLength)
_myTooltip= value.Substring(0,myToolTipLength );
else
_myTooltip= value;
}
}
}
myControl.Tootip = myInstance.MyTooltip;
-- modified at 3:25 Wednesday 26th September, 2007
I've just re-read the OP question and think I have answered totally the wrong thing...but I am leaving it here anyway!
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
As i still dont have much programming exp., so there are some question of mine which want as answer.......
-> If i created a peice of code and its working, then i dont even think wheather it is good enough or not, i mean is there other better way?
So, how to analyse this?
(plz dont measure performance in neno-second(resources), as in small application it hardly matters)
-> How to analyse the worst case possibility of code?
|
|
|
|
|
if u r using a backend it really matters
www.codepal.co.nr
Regards
Bino
http://www.codepal.co.nr
|
|
|
|
|
Performance and properly architected code matter in all cases. Also, please use proper english and not SMS (Text) Speak in the forums and don't advertise.
|
|
|
|