Re: TableAdapter query parameter taken from config file - .NET (Core and Framework) Discussion Boards

First Prev Next

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.

Re: games in .Net

Henry Minute6-Sep-09 9:56

Henry Minute

6-Sep-09 9:56

Luc Pattyn wrote:
open up some windows instead

XP, Vista or 7?

Re: games in .Net

N a v a n e e t h6-Sep-09 3:23

N a v a n e e t h

6-Sep-09 3:23

Yes. Read about XNA.

Navaneeth

How to use google | Ask smart questions

Re: games in .Net

0x3c06-Sep-09 6:03

0x3c0

6-Sep-09 6:03

Yes. Off you go!

OSDev

Re: games in .Net

Eddy Vluggen6-Sep-09 9:12

Eddy Vluggen

6-Sep-09 9:12

A fine example would be Quake II.NET, right here on CodeProject[^] Smile | :)

I are Troll Smile | :)

QuickBooks simple questions

John Developer5-Sep-09 23:32

John Developer

5-Sep-09 23:32

Hi,

Please if you can advise on following questions on integration with QuickBooks.

1. I need to connect to QuickBooks database. How can I connect and retrieve data from QuickBooks?

2. What type of connection do you use to connect to database?

3. Is there some tool that makes it easier?

Please answer on any questions of this, if you have programmed with QuickBooks.

Note: I am developing in C#

Thanks in advance

John T.

Re: QuickBooks simple questions

Richard MacCutchan6-Sep-09 8:44

Richard MacCutchan

6-Sep-09 8:44

Read this[^]. Then read it again.

media player on vb.net

rashid20095-Sep-09 21:29

rashid2009

5-Sep-09 21:29

sir
how can i load media player control on vb.net when i select by browse any media file then that file will play .
thxx

Last Visit: 31-Dec-99 18:00 Last Update: 30-Apr-24 1:12

Refresh

ᐊ Prev 1...429 430 431 432433434 435 436 437 438 Next ᐅ

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