ASP.NET

Christian Graus3-Aug-07 21:20

Re: Database Connectivity !! [modified]

3-Aug-07 21:20

You say you tried, what did you try ? There are hundreds of samples online showing how to connect to a DB, we need to know what you tried, and what went wrong, to give you more focused help than you can get from a google search.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

manowj3-Aug-07 21:21

3-Aug-07 21:21

Hi,

Try this.

In Web.config file
<appSettings>
<add key="conn" value="Server=<ServerName>;Integrated Security=no;User ID=;PWD=;database=" />
</appSettings>

In Code-behind File

using System.Data.SqlClient;
string ConnectionString =System.Configuration.ConfigurationSettings.AppSettings["conn"];
SqlConnection Sconn=new SqlConnection(ConnectionString);
Sconn.Open();

-- modified at 3:42 Saturday 4th August, 2007

Regards,
Manowj

Christian Graus3-Aug-07 21:30

Re: Database Connectivity !! [modified]

3-Aug-07 21:30

I'm guessing that may work if using the default DB on the same machine. Perhaps.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

sulabh20203-Aug-07 21:52

sulabh2020

3-Aug-07 21:52

Hi shweta, well what i guess abou you is , u r new to this field.
may i ask u that r u working for noida branch.

well this is ur ans for connectivity.
string connect= "Server=Server_path;Database=ABC;User=user;Password=Password";

SqlConnection con = new SqlConnection(connect);

try it and make me know.

Hello Forum
Always be in touch to help about the topic ASP.NET

Christian Graus3-Aug-07 22:01

3-Aug-07 22:01

Why is your connection string not in resources ? Why do you create two connection objects in this code ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

sulabh20203-Aug-07 22:07

sulabh2020

3-Aug-07 22:07

plz look the code properly than question.

I have taken one connection object
and another a simple strin to pass on this object as credentials of server where to connected to.

Hello Forum
Always be in touch to help about the topic ASP.NET

Christian Graus3-Aug-07 22:22

3-Aug-07 22:22

OK, so long as you're asking

public SqlConnection con = new SqlConnection();
string connect= "Server=Server_path;Database=ABC;User=userassword=Password";

con = new SqlConnection(connect);

I assume that public means that con is a member variable. Otherwise, it's an error.

You create a new object at the point of declaring the variable.

You assign a string to the connection string, although you don't expose it in any way ( which is not wise )

Then you use this string to create a new connection object ( your second ), meaning that the first one is never used, and if this is a member variable, as it seems to be, it means that you have a member object, but you recreate it, every time you use it.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

sulabh20203-Aug-07 22:37

sulabh2020

3-Aug-07 22:37

Also we can use our common sense while declaring the variables.

What i ans for the connectin doesnt mean that this is the exact and only ans for this post, its a Hint of doing.

And one who needs toimplement this can use its little mind according to its need.

For ur graet information i always use this as staic and defined under one class, so every time u have to declare the connection string.

Hello Forum
Always be in touch to help about the topic ASP.NET

Christian Graus3-Aug-07 22:47

3-Aug-07 22:47

sulabh2020 wrote:
What i ans for the connectin doesnt mean that this is the exact and only ans for this post, its a Hint of doing.

OK, well, I pointed out some bad practises in your code, you rejected the claim. It seems that you accept it now ?

sulabh2020 wrote:
so every time u have to declare the connection string.

It is always better to expose your connection string in a config file.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

N a v a n e e t h3-Aug-07 22:36

N a v a n e e t h

3-Aug-07 22:36

sulabh2020 wrote:
public SqlConnection con = new SqlConnection();
string connect= "Server=Server_path;Database=ABC;User=userassword=Password";

con = new SqlConnection(connect);

Looks bad design for me. con = new SqlConnection(connect); is not needed, using this line you are creating one more object for the SQLConnection class. SQlConnection object have a property ConnectionString. Instead of creating new connectiion assign value to this property. Or write connection initialization code after creating connectionstring.

My Website | Ask smart questions

set length for value

praveenkumar_mca3-Aug-07 19:57

praveenkumar_mca

3-Aug-07 19:57

Hi guys i have a value for example 23 now i display this like "000023.0" length shoulbe be 8. if i give 44.5 means it should display "000044.5", so lenght not exeed 8. please tell me how to display like this.

Praveen Kumar.R

Re: set length for value

Christian Graus3-Aug-07 21:19

3-Aug-07 21:19

Same as below - the Format method on the string class, or even the ToString on the int class, can be told what number format is needed.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: set length for value

manowj3-Aug-07 21:24

3-Aug-07 21:24

Hi,

Try this

Format(<VariableName>,"000000.00") will give the result.

Regards,
Manowj

Time fromat

praveenkumar_mca3-Aug-07 19:16

praveenkumar_mca

3-Aug-07 19:16

Hi guys i want displat the time like this format "06:12:12000000008" please let me know anybody know. how to write code

Praveen Kumar.R

Re: Time fromat

Christian Graus3-Aug-07 21:18

Exporting grid data to Excel

3-Aug-07 21:18

Use the string's Format method to build the number in the format you need.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Rahithi3-Aug-07 19:01

Rahithi

3-Aug-07 19:01

hi,

i am trying to export the data from ASP.NEt datagrid to Xls file.
i am recieving this error :

Control 'dgBillsReviewed__ctl2__ctl0' of type 'DataGridLinkButton' must be placed inside a form tag with runat=server.

i am using HTMLtext writer to export the data. i am taking template columns in my grid. if i remove these template columns(when i drctly set the datasource, it is working fine)

please let me know the solution...

Thanks,
Rahi

If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Re: Exporting grid data to Excel

praveenkumar_mca3-Aug-07 19:27

praveenkumar_mca

3-Aug-07 19:27

HI Rahi in ur HTML there is no Form tage so please put form tag and try again may be it will work if ur coding is correct.

Praveen Kumar.R

Re: Exporting grid data to Excel

manowj3-Aug-07 21:26

Re: Exporting grid data to Excel

3-Aug-07 21:26

Hi,

Confirm that the datagrid is placed in between the <form> and </form>.

Regards,
Manowj

Rahithi4-Aug-07 4:07

Rahithi

4-Aug-07 4:07

hi,

thanks for responding to my query.

my grid is placed in the Form Tag. still it is giving this error.

i am using Item Template to bind the data ...and i am using lables to display the grid data.

how to resolve this?? any idea??

Thanks,
Rahi

If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

why Session_End is fired?

Nicejith3-Aug-07 18:44

Nicejith

3-Aug-07 18:44

why Session_End is fired after i deleted a folder using directory.delete(folderpath,true)

Re: why Session_End is fired?

manowj3-Aug-07 21:29