Re: Managing paper-like forms in .NET . [modified] - .NET (Core and Framework) Discussion Boards

Not Active7-Sep-09 5:18

7-Sep-09 5:18

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

Re: Managing paper-like forms in .NET .

devboycpp7-Sep-09 6:52

devboycpp

7-Sep-09 6:52

Mark Nischalke wrote:
Lastly, don't call me dude.

Is it insult to call someone dude or what ?

If you are a girl ... then ...

Re: Managing paper-like forms in .NET .

Not Active7-Sep-09 7:10

Not Active

7-Sep-09 7:10

To me, yes

only two letters away from being an asset

Re: Managing paper-like forms in .NET .

devboycpp7-Sep-09 7:02

devboycpp

7-Sep-09 7:02

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 ...

Re: Managing paper-like forms in .NET .

Not Active7-Sep-09 7:09

Not Active

7-Sep-09 7:09

devboycpp wrote:
we have to insert 130 records into the table...much it will affect the performance.

You can't be serious? Roll eyes | :rolleyes:

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? OMG | :OMG:

only two letters away from being an asset

Re: Managing paper-like forms in .NET .

devboycpp7-Sep-09 7:23

devboycpp

7-Sep-09 7:23

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 ...

Re: Managing paper-like forms in .NET .

Not Active7-Sep-09 7:57

Not Active

7-Sep-09 7:57

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

Re: Managing paper-like forms in .NET . [modified]

devboycpp7-Sep-09 8:43

devboycpp

7-Sep-09 8:43

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

Re: Managing paper-like forms in .NET .

Not Active7-Sep-09 9:44

Not Active

7-Sep-09 9:44

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

Re: Managing paper-like forms in .NET .

devboycpp7-Sep-09 9:59

devboycpp

7-Sep-09 9:59

Mark Nischalke wrote:
Don't be an ass

only two letters away from being an asset Wink | ;)

I thought it is a kind of respect .

Re: Managing paper-like forms in .NET .

devboycpp7-Sep-09 9:35

devboycpp

7-Sep-09 9:35

is it good? efficient ?

If you are a girl ... then ...

TableAdapter query parameter taken from config file

LordZoster6-Sep-09 21:15

LordZoster

6-Sep-09 21:15

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

Re: TableAdapter query parameter taken from config file

Henry Minute7-Sep-09 4:00

Henry Minute

7-Sep-09 4:00

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.”

Re: TableAdapter query parameter taken from config file

LordZoster7-Sep-09 4:09

LordZoster

7-Sep-09 4:09

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.

Re: TableAdapter query parameter taken from config file

Henry Minute7-Sep-09 4:18

Henry Minute

7-Sep-09 4:18

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.

Error Crystal "report has no table" in asp.net

devlop6-Sep-09 19:11

devlop

6-Sep-09 19:11

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()

Re: Error Crystal "report has no table" in asp.net

The Vikash!25-Sep-09 3:22

The Vikash!

25-Sep-09 3:22

hiii

hey u found any solution of this error

please mail mee at vks.2009@gmail.com

games in .Net

yashwant vaishnav6-Sep-09 2:24

yashwant vaishnav

6-Sep-09 2:24

can we make some games in .Net

Re: games in .Net

harold aptroot6-Sep-09 2:31

harold aptroot

6-Sep-09 2:31

Sure, go ahead?

Re: games in .Net

Abhijit Jana6-Sep-09 3:11

Abhijit Jana

6-Sep-09 3:11

yashwant vaishnav wrote:
can we make some games in .Net

Yes.
Which type of game you want to developed ? Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: games in .Net

Luc Pattyn6-Sep-09 7:21

Luc Pattyn

6-Sep-09 7:21

Pong.NET

Luc Pattyn

Badger | [badger,badger,badger,badger...]

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Re: games in .Net

Henry Minute6-Sep-09 8:20

Henry Minute

6-Sep-09 8:20

Don't you think that parts of it smell enough already? Smile | :)

Re: games in .Net

Luc Pattyn6-Sep-09 8:42

Luc Pattyn

6-Sep-09 8:42

It could use a little refactoring, and some #5. So what?

Smile | :)

Luc Pattyn

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Re: games in .Net

Henry Minute6-Sep-09 9:06

Henry Minute

6-Sep-09 9:06

Luc Pattyn wrote:
and some #5

You have expensive tastes.

I was thinking more along the lines of air freshener. Smile | :)

Re: games in .Net

Luc Pattyn6-Sep-09 9:21

Luc Pattyn

6-Sep-09 9:21

Henry Minute wrote:
air freshener

that's disgusting. WTF | :WTF:

and if that is all it takes, then open up some windows instead. real cheap and real fresh.

Smile | :)

Luc Pattyn

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.