Mr. S.
here's how I fill the dataset, after a trial to enlarge the column width:
System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(SqlStmt,conn);
if(this.myDatSet.Tables.Contains(TableName))
this.myDatSet.Tables[TableName].Clear()...
Mr. S.
sorry 4 late reply
well, the value is untouched in the DB. Querying from DB gets over 30 characters.
About the Dataset, I dunno its type but I don't use the wizard so i'm not sure. It's the default type I guess.
stsuing,
Here are the steps:
1. I get the value from GUI and insert in DB (Value arrives at the DB without truncation)
2. Query the string values filling a Dataset
3. Refering to the appropriate column in the datatable in the filled dataset, The string retrieved back is truncated to 30...
Dear All,
In my application I have 2 database coulmns that include long string values (over 30 characters). When retrieving data from these cells the value returned is truncated to the size of 30 characters only! anyone got an idea about this issue???
Zdehkordi,
As far as i worked with Crystal Reports in C#, in tabular forms I add records one by one by setting each cell then sending it to the crystal report then add other. In same way you can add records with empty cells at the end of each report. Empty cells would be presented by spaces or...
Dear all,
In my project I currently do the following:
1. Fill a datatable from DB
2. Have a DataGridTableStyle mapped with the datatable to hide some columns
3. the DataGridTableStyle is assigned to a datagrid
Everything works fine except that I can't arrange the columns, I'm forced to use the...
MasterRacker,
I agree with JurkMonkey, it will take some effort may be equal to that of looping through ur controls at each form, but it'll make ur button events editable anytime just from ur NoisyButton class and it'll save time of extra loops running at each Form's load.
More questions! :P
As I told u in my application, my controller a static class and including static methods. some issues are not clear in examples I'v seen till now:
1. In all examples I'v seen Controllers are not static, I can't imagine a controller not static
2. In one example the Controller...
Chiph,
As far as I can understand, I should have an Emp class to hold only my Setters & getters and any other validations on the entity level. Emp_DB to handle the CRUD operation. EMP_DB seems to be static, right?
What about sql queries that not related to a certain entity, it just help me to...
Grooke,
It's not the first time I appreciate your tips :) . It's the professional way to have the system implemented, but what if the system looks simple that some of class layers u'v mentioned can be merged together. I'll tell u the structure and please correct me if i'm wrong:
1. A class...
Chiph,
Do u mean if I'm retrieving a list of 100 Emp, the Emp_DB would have a function to return me an ArrayList of Emp as example?
If yes, could this function be a static function in EMP? or it'd break a rule or convention?
I appretiate your help so much.
Dear imterpsfan3,
First of all i'd like to thank all who replied there for their valuable replies, I really liked it as I have imterpsfan3 problem with termonologies. But i'd like to express it from one other point of view as I had some of such strange interviews. It happened many times that...
As far as I'm know, Functions which Add/Delete/Update an object is placed in the object's class.
like
class Emp...
Emp.addEmp(Emp newEmp)
Emp.delEmp(Emp oldEmp)
Emp.updateEmp(Emp currentEmp)
and in the Emp class I place my SQL satements.
If I'm right, my question is:
I have a class, the GUI...
Gil,
It's a lil bit simpler than what u expect, the point is that the resource is always available and always accessible, it's like a gate and it's mandatory to pass through, so the airport takes the responsibility of arranging its traffic. Sometimes it happens that this resource is down, so...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.