Re: C#.Net ASP (Urgent) - ASP.NET Discussion Boards

connecting to sql server using application configuration file

$h@ma!|@6-Jul-07 22:42

6-Jul-07 22:42

i m working on widows application..for connectivity to sql i want to give datasource in app config file..and in every page i wan to call that string
but i dont understand how to do that
can anyone help me??

$h@ma!|@

Re: connecting to sql server using application configuration file

Vipin.d6-Jul-07 23:18

Vipin.d

6-Jul-07 23:18

hi,
add a appconfig file to your application... and

add a key to that appconfig file..

eg:<
<configuration>

<appsettings>

<add key="DATASOURCE" value="MYDATASOURCE">

>

and in cs/vb file

 <br />
 string keyval = ConfigurationSettings.AppSettings["DATASOURCE"].ToString();<br />
<br />

All I ever wanted is what others have....
CrazySanker

Re: connecting to sql server using application configuration file

$h@ma!|@7-Jul-07 0:10

$h@ma!|@

7-Jul-07 0:10

thx but it is giving error i.e;
The name 'ConfigurationSettings' does not exist in the current context

$h@ma!|@

Re: connecting to sql server using application configuration file

$h@ma!|@7-Jul-07 0:12

$h@ma!|@

7-Jul-07 0:12

and i have written in app file

<configuration>
<rescue>
<connection>
<odbcname>rescue15

is it ok???

$h@ma!|@

Re: connecting to sql server using application configuration file

Vipin.d7-Jul-07 1:31

Vipin.d

7-Jul-07 1:31

use this name space

using System.Configuration;

in ur .cs file

All I ever wanted is what others have....
CrazySanker

C#.Net ASP (Urgent)

| Muhammad Waqas Butt |6-Jul-07 22:15

| Muhammad Waqas Butt |

6-Jul-07 22:15

Hi,

I have a question.

I have a comobox, i've bind data something like this

oleDbDataAdapter1.Fill(dataSet11);
DropDownList1.DataSource = dataSet11.Tables[0].DefaultView;
DropDownList1.DataTextField = dataSet11.tbacdes.ac_headColumn.ToString(); //Display AC Head
DropDownList1.DataValueField = dataSet11.tbacdes.ac_idColumn.ToString(); // Display AC Id
DropDownList1.DataBind();

first of all is correct. Now I want to to show Account Header in comobox and when user select any value than selectindex pass header id this my question, please help me out init.

Example
=======
[Student Fee] Display value and in backend of this entry in comobox header id is 2

I'm using asp.net 1.1, C#.Net.

|Muhamad Waqas Butt|
waqasb4all@yahoo.com
www.sktech.freewebspace.com

Re: C#.Net ASP (Urgent) [modified]

Vipin.d6-Jul-07 22:41

Vipin.d

6-Jul-07 22:41

i think this is u r trying to ask ..from drpdwn list

drpdwn1.selecteditem.value is AC id

and drpdwn1.selecteditem.text is AC header

plz,dont put "URGENT" in posting queries..

-- modified at 5:29 Saturday 7th July, 2007

All I ever wanted is what others have....
CrazySanker

Re: C#.Net ASP (Urgent)

Paul Conrad7-Jul-07 6:57

Paul Conrad

7-Jul-07 6:57

Don't cross post. You asked this same question in the C# forum.

"That's no moon, it's a space station." - Obi-wan Kenobi

Barcoding In asp.net

Debi Prasad6-Jul-07 22:12

Debi Prasad

6-Jul-07 22:12

I have developed a project in asp.net for saling products of a company in different locations in a city.They use barcode tag on the product to retrive product information.

So how can i trap that barcode and display the result on my application.

Is it possible or is there any altrnative?

Please Suggest

Thanks

DPM

Re: Barcoding In asp.net

N a v a n e e t h6-Jul-07 23:54

N a v a n e e t h

6-Jul-07 23:54

Ask them how they generate barcode for their products. Their program will be using a logic to decode that? Why don't use same in your APP.

My Website | Ask smart questions

Bind the query value in datagrid bound column...,

Member 38798816-Jul-07 22:01

Member 3879881

6-Jul-07 22:01

Using my query i try to bind the fields in my datagrid boundcolumn...,
Now in that query i given two fields name as same, like this:

"MHD.AppWHours as AppHours,MHD.AppSHours as AppHours"

In my grid i given one of the bound column name as "AppHours"...,

If i bind the grid it's binding the first AppHours only...,
In that first apphours not have any value...,
Then it want to bind that bound column cell, second apphours value...,

How to do that...,
Any possible way is there plz tell me...,

Regards,
Magi

Re: Bind the query value in datagrid bound column...,

N a v a n e e t h6-Jul-07 23:52

N a v a n e e t h

6-Jul-07 23:52

I think if two column name's are same, datagrdid will take only the first. An alternative solution would be keeping one function that checks your first value and return appropriate value. Then call that function like this

<%# YourFunctionName(BoundValue,SecondBoundValue %>

in codebehind page create your function like

public string YourFunctionName(Param1,Param2)
{
    if ( string.compare(Param1,"") == 0 )
       return Param2
    else
       return Param1
}

My Website | Ask smart questions

Need ValidationExpression string for time format

Imran Khan Pathan6-Jul-07 21:49

Imran Khan Pathan

6-Jul-07 21:49

Hi friends

I need ValidationExpression string for time format like as "11:11:11 AM" or PM for valid time.

Thanks in advance

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Re: Need ValidationExpression string for time format

N a v a n e e t h6-Jul-07 23:42

N a v a n e e t h

6-Jul-07 23:42

Hi
Try this regular expression

\b[0-9]{2}:[0-9]{2}:[0-9]{2}\s(?:AM|PM)\b

My Website | Ask smart questions

Re: Need ValidationExpression string for time format

Imran Khan Pathan7-Jul-07 1:23

Imran Khan Pathan

7-Jul-07 1:23

Hi

It should be invalid for 13:85:85 AM

THanks

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Re: Need ValidationExpression string for time format

N a v a n e e t h7-Jul-07 2:15

N a v a n e e t h

7-Jul-07 2:15

Imran Khan Pathan wrote:
It should be invalid for 13:85:85 AM

Ys, I know it won't validate this. But you can split the match using ":" in your application. Then check it is in between the valid range.

My Website | Ask smart questions

Re: Need ValidationExpression string for time format

Imran Khan Pathan7-Jul-07 2:22

Imran Khan Pathan

7-Jul-07 2:22

Finally i got solution

This is valid validationExpression string
"^([1-9]|1[0-2]|0[1-9]){1}(:[0-5][0-9]\s[aApP][mM]){1}$"

Best regard

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Error :must be placed inside a form tag with runat=server

n_gchaitra6-Jul-07 21:24

n_gchaitra

6-Jul-07 21:24

Hi, I have used the following code to export the data from datagrid (asp.net 2.0, vbscript) to an excel sheet. But i am getting the error, Control 'dgresult_ctl03_ctl00' of type 'Button' must be placed inside a form tag with runat=server.
I have set the form tag attribute and button attribute to runat=server

<asp:button id="button1" text="excel ?" runat="server/">
But no it is of no help. Any suggestion? Thanks for any help.

Private Sub RenderGrid()
Response.ContentType = "application/vnd.ms-excel"
' Remove the charset from the Content-Type header.
Response.Charset = ""
' Turn off the view state.
Me.EnableViewState = False
Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
' Get the HTML for the control.
dgresult.RenderControl(hw)
' Write the HTML back to the browser.
Response.Write(tw.ToString())
' End the response.
Response.End()
End Sub

Protected Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button1.Click
RenderGrid()
End Sub

Re: Error :must be placed inside a form tag with runat=server

N a v a n e e t h6-Jul-07 23:34

N a v a n e e t h

6-Jul-07 23:34

All server side controls should be placed and rendered inside the form tag. In you case you miss that .You are rendering the control and sending the HTML to page using Response.Write. This will place controls HTML code before the <HTML> tag starts. That makes this error. Solution could be putting a literal control on the place where you want to show this rendered control. Then replace Response.Write with literalName.Text = YourRenderedHTML.

Hope this helps

My Website | Ask smart questions

Re: Error :must be placed inside a form tag with runat=server

n_gchaitra7-Jul-07 1:46

n_gchaitra

7-Jul-07 1:46

no. all the controls are between,

Chaitra N

Re: Error :must be placed inside a form tag with runat=server

sidbaruah8-Jul-07 23:53

sidbaruah

8-Jul-07 23:53

The error talks about the button control check the runat server tag of the button field !!! might be there you have missed something a runat="server" may be!!!!

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

Re: Error :must be placed inside a form tag with runat=server

n_gchaitra9-Jul-07 21:35

n_gchaitra

9-Jul-07 21:35

Thank you sid. But I have not missed form tag runat="server". Still could not figure it out the reason for this error.

Chaitra N

creating an exe in .net?

vijay_836-Jul-07 20:59

vijay_83

6-Jul-07 20:59

hi,

what is an exe and why do we create an exe? How is an exe useful in Asp.Net? Give me some examples for creating an exe in .net...

Regards
Vijay.

Re: creating an exe in .net?

Tarik Guney6-Jul-07 23:16

Tarik Guney

6-Jul-07 23:16

You want to create an exe for asp.net . I think you cannot do that. but if you wanna do for visual c#.net ,just build it and look in the bin folder in folder of your project,

Re: creating an exe in .net?

N a v a n e e t h6-Jul-07 23:24

N a v a n e e t h

6-Jul-07 23:24

vijay_83 wrote:
what is an exe

EXE is a file extension which denotes executable type files. What ever program you are executing in windows will be having one EXE.

vijay_83 wrote:
How is an exe useful in Asp.Net?

ASP.NET is not having any relation with EXE. It is applicable for standalone application. ASP.NET is server side scripting language which executes on the server depends on the request it gets.

vijay_83 wrote:
Give me some examples for creating an exe in .net...

Create a new Console or WindowsApplication in .NET. Write your code and run it. You will get an EXE in your output directory.

My Website | Ask smart questions

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