|
Mark Nischalke wrote: You don't need to store the form in a binary format in the database, only the data that was entered.
Dude , the reason why I want this is because the fields of the form are many (almost 130 ). The data in fields are all of varchar type. I go crazy having to make a table with 130 fields and a form to show those fields , a stored procedure to update , insert to those fields.
Do you have a more elegant way ?
|
|
|
|
|
Then what happens when the form changes? The previous versions you have stored are all invalid?
A more elegant solution would allow the data to be stored independent of the presentation.
I'm sure this data could also be used for analysis also, forming charts or graphs. It wouldn't be possible in a binary format.
devboycpp wrote: The data in fields are all of varchar type.
Are the fields truely all varchar, or are you being lazy and making them such? What about validation of the data entered?
If they are all truely varchar then a table could be constructed with a name/value pair. With an identity column, that's only three columns. Is that too much for you?
If they are not all varchar and you need to create a table with seperate columns, using Linq to SQL or Entity Framework you can eliminate the need to write and maitain stored procs. Also, I'm sure there is potenttial to normalize the data and elimiate some of the columns.
Lastly, don't call me dude.
only two letters away from being an asset
|
|
|
|
|
Mark Nischalke wrote: Lastly, don't call me dude.
Is it insult to call someone dude or what ?
If you are a girl ... then ...
|
|
|
|
|
To me, yes
only two letters away from being an asset
|
|
|
|
|
Mark Nischalke wrote: If they are all truely varchar then a table could be constructed with a name/value pair. With an identity column, that's only three columns. Is that too much for you?
With this solution when creating a form for the first time we have to insert 130 records into the table and when updating likewise. I don't know how much it will affect the performance.
And also when fetching data it is not straightforward to display data in the form.
If you are a girl ... then ...
|
|
|
|
|
devboycpp wrote: we have to insert 130 records into the table...much it will affect the performance.
You can't be serious?  Modern databases, such as SQL Server, can handle thousands of transactions per second. Do you really think 130 rows is going to cripple it?
devboycpp wrote: And also when fetching data it is not straightforward to display data in the form.
form["field name"] = row["field name"].value
Something like this is too cumbersome for you? 
only two letters away from being an asset
|
|
|
|
|
Mark Nischalke wrote: form["field name"] = row["field name"].value
For displaying data we need to fetch the records into a DataTable. It will contain 130 records . To display the values for the form fields we need to locate in DataTable to find the desired record matching the form entry. Which is not like you said . The above code is for when all 130 fields are stored in one record of a table.
If you are a girl ... then ...
|
|
|
|
|
Notice the Something like this statement. Can you use a little imagination or would you like me to write the application for you?
You've gotten all the help you need. I'll expect either a check or a thank you.
only two letters away from being an asset
|
|
|
|
|
Thanks
Well . I just wanted an elegant way. Seems in this way I should write a function that in its body loops through records of a DataTable and blah blah blah ... like this
string GetFieldValue(string fieldName)
{
for(int i=0 ; i < table1.Rows.Count ; i++)
{
if(table1.Rows[i]["fieldName"].ToString()==fieldName)
{
return table1.Rows[i]["Value"].ToString();
}
}
return "";
}
Is it right majesty ? Or you know a more elegant way?
modified on Monday, September 7, 2009 3:33 PM
|
|
|
|
|
This is where Linq to SQL adds elegance to the solution.
Given FormValues is the LinqToSQL representation of your table in which you store the huge array of 130 values.
string value = FormValues.SingleOrDefault(e => e.Name == fieldName);<br />
form[fieldName] = (value == null) ? "Some default" : value;
devboycpp wrote: Is it right majesty
Don't be an ass
only two letters away from being an asset
|
|
|
|
|
Mark Nischalke wrote: Don't be an ass
only two letters away from being an asset 
I thought it is a kind of respect .
|
|
|
|
|
is it good? efficient ?
If you are a girl ... then ...
|
|
|
|
|
Hallo
i have a parametric query which fills a TableAdapter. I would like that the parameter value be read from the app config file.
How could I achieve this?
Thanks in advance
|
|
|
|
|
Search for Application Settings on MSDN, or Google/Bing it.
But are you sure?
The config file is an easily editable XML file. You will be leaving yourself open to mischief.
Is that better Luc?
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.”
|
|
|
|
|
Hallo Henry and thanks for the reply.
I've already googled but I cannot find any resource to link TableAdapter and Application Settings.
I'm aware of possible issues, but they are not risky for us for the environment we are addressing to.
Thanks again.
|
|
|
|
|
In your original post you said "I would like that the parameter value be read from the app config file.".
Well if you read the stuff you found on Application Settings you should have found how to retrieve the value of the parameter from yourapp.exe.config. It is then a simple matter to use the retrieved value where you use your current parameter.
Or is it that part that you require assistance with? If so I misunderstood your OP.
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.”
|
|
|
|
|
hi all
please help me
i am facing a problem in developing dynamic crystal reports
it shows error as "the report has no table"
as i am using kept blank report
following is the code
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("satinconnectionstring").ConnectionString)
con.Open()
Dim cmd As New SqlCommand
cmd.Connection = con
cmd.CommandText = "select * from employee"
Dim da As New SqlDataAdapter(cmd.CommandText, con)
Dim ds As New DataSet
da.Fill(ds)
Dim myReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument
myReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument()
myReportDocument.Load(Server.MapPath("CrystalReport2.rpt"))
myReportDocument.SetDataSource(ds)
'myReportDocument.Database.Tables(0).SetDataSource(ds)
CrystalReportViewer1.ReportSource = myReportDocument
CrystalReportViewer1.DataBind()
|
|
|
|
|
hiii
hey u found any solution of this error
please mail mee at vks.2009@gmail.com
|
|
|
|
|
can we make some games in .Net
|
|
|
|
|
|
yashwant vaishnav wrote: can we make some games in .Net
Yes.
Which type of game you want to developed ? 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Pong.NET
|
|
|
|
|
Don't you think that parts of it smell enough already?
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 could use a little refactoring, and some #5. So what?
|
|
|
|
|
Luc Pattyn wrote: and some #5
You have expensive tastes.
I was thinking more along the lines of air freshener.
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.”
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Badger | [badger,badger,badger,badger...]](https://www.codeproject.com/script/Forums/Images/badger.gif)
![Jig | [Dance]](https://www.codeproject.com/script/Forums/Images/jig.gif)