Re: Database Connection in asp.net - ASP.NET Discussion Boards

sarang_k7-Apr-10 20:19

7-Apr-10 20:19

Hi all ,

I have created an asp.net application and my database is on another system.I want to connect that database to my application from that another system using the webconfig file. How can i do it ?

Thanks in advance.

Re: Database Connection in asp.net

yogesh_kumar_agarwal7-Apr-10 20:51

yogesh_kumar_agarwal

7-Apr-10 20:51

define the connection string in web.config under appsettigns tag like;

<appsettigns>
<add key="name" value"Data Source=remote pc name; uid=userid; password=sqlserverpassword;Initial Catalog=Database name"/>
</appsettigns>

</pre>

or U can use the connection string tag also. 

call the same is ur cs or vb file using configuration managaer class.

Re: Database Connection in asp.net

sarang_k7-Apr-10 20:56

sarang_k

7-Apr-10 20:56

yes i have done using this but now the problem is when i am writing insert query it is not inserting the data into the database.

But if i open sql server management studio and execute the query it is inserting.

can u tell me how to solve it.

Thanks in advance.

Re: Database Connection in asp.net

yogesh_kumar_agarwal7-Apr-10 20:59

yogesh_kumar_agarwal

7-Apr-10 20:59

Ok, then tell me the error. or if possible the show the code.

Re: Database Connection in asp.net

sarang_k7-Apr-10 21:04

sarang_k

7-Apr-10 21:04

there is no error. Main problem is it is not inserting in to the table.how to define the datasource of that another pc.can u give me an example or is there any thing we have to set properties or give access.And i am using sql server 2008.

Thanks in advance.

Re: Database Connection in asp.net

yogesh_kumar_agarwal7-Apr-10 21:13

yogesh_kumar_agarwal

7-Apr-10 21:13

Nothing has to be define, If the problem is in insert query the connection has no problem.

it will be inserted in the same manner it inserts with the local database.

just define the connection in your command statement

SqlCommand sql=new SqlCommand(str,con)

will work fine. Or check with ur user credential for login into sql database. sa has right and the other user not then also the insert could be failed.

Re: Database Connection in asp.net

Brij7-Apr-10 20:52

Brij

7-Apr-10 20:52

sarang_k wrote:
I want to connect that database to my application from that another system using the webconfig file.

I didn't get you. What is the problem you facing to connect the db which in another system? define the connectionstring in web.config properly

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Re: Database Connection in asp.net

sashidhar7-Apr-10 21:22

sashidhar

7-Apr-10 21:22

first check the database tht if you can access from your system using sqlserver management studio. If yes There will be no problem just specify the correct connect string as brij suggested.

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: Database Connection in asp.net

meeram3958-Apr-10 2:58

meeram395

8-Apr-10 2:58

You may select, insert or update the queries in the Sql Server Management Studio, but not from the application.

Just check whether the application is having right access to do the manipulations in db. This might be the problem, even though the connection string is correct.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

linq to sql , insert into db using store procedure

tanweer7-Apr-10 19:24

tanweer

7-Apr-10 19:24

hello every body
I am unable to insert data into a db using a store procedure in the LINQ to SQL .The code is:
LinqToSQLDataContext dc = new LinqToSQLDataContext();
info inf = new info { Id = 1, name = "Ali" ,infoD="he is agood boy"};
dc.UserDetails.InsertOnSubmit(inf);
dc.SubmitChanges();

but the error is system.data.table.InsertOnSubmit has some invalid arguments

Re: linq to sql , insert into db using store procedure

Arun Jacob7-Apr-10 21:05

Arun Jacob

7-Apr-10 21:05

tanweer akhtar wrote:
dc.UserDetails.InsertOnSubmit(inf);

I guess inf is not the same type of data object in the table UserDetails.

Arun Jacob
http://codepronet.blogspot.com/

pass javascript variable to asp.net function

Abdul Rahman Hamidy7-Apr-10 19:14

Abdul Rahman Hamidy

7-Apr-10 19:14

Dear All,
I am looking for a way where I want to pass javascript variable to asp.net function
bellow is what I am doing right now

function openWindowWithArg()
{
   var myParam = window.dialogArguments;
   var param = document.getElementById('TextBox1');
   param.value = myParam.param;
   <%bindAdvancedFilterData("1,2"); %>; //this works fine
   <%bindAdvancedFilterData(param.value); %>; //this doesnt work, I want to do it this way
}

any ideas how i can pass param.value to the asp.net method bindAdvancedFilterData()?, I can do this using query string and session but May be it should be possible to do it like this?

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass javascript variable to asp.net function

sashidhar7-Apr-10 20:02

sashidhar

7-Apr-10 20:02

Why dont u use hidden field..?
are u trying to call a method?
what is bindAdvancedFilterData()? in here..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: pass javascript variable to asp.net function

Abdul Rahman Hamidy7-Apr-10 20:10

Abdul Rahman Hamidy

7-Apr-10 20:10

well, I am calling openWindowWithArg function in onload of body as bellow

<body onload="openWindowWithArg();">

and the function

<%bindAdvancedFilterData("1,2"); %>;

is asp.net function which I am calling it from javascript.
How to pass javascript variables to asp.net method? which I want to do it as bellow

function openWindowWithArg()
    {
        var myParam = window.dialogArguments;
        var param = document.getElementById('TextBox1');
        param.value = myParam.param;
        //<%bindAdvancedFilterData("1,2"); %>;
        <%bindAdvancedFilterData(param.value); %>;
    }

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass javascript variable to asp.net function

sashidhar7-Apr-10 20:14

sashidhar

7-Apr-10 20:14

To My knowledge use hidden control for that .I mostly uses that. Its Only a suggestion .
http://www.dotnetcurry.com/ShowArticle.aspx?ID=203[^]

If this the way you dont want please ignore..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: pass javascript variable to asp.net function

Abdul Rahman Hamidy7-Apr-10 20:20

Abdul Rahman Hamidy

7-Apr-10 20:20

thanks for reply, well I am not doing postback, If you I call that function in body load.
If I do post back then Its possible to do it but since I am looking to do it only in body load.

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass javascript variable to asp.net function

sashidhar7-Apr-10 20:40

sashidhar

7-Apr-10 20:40

Then the other approach is using webservice
Refer this article..!
http://www.asp.net/AJAX/Documentation/Live/Tutorials/ConsumingWebServicesWithAJAXTutorial.aspx[^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: pass javascript variable to asp.net function

Not Active8-Apr-10 1:36

Not Active

8-Apr-10 1:36

Because you don't always need to use a hidden field.

I know the language. I've read a book. - _Madmatt

Re: pass javascript variable to asp.net function

Mogamboo_Khush_Hua7-Apr-10 20:35

Mogamboo_Khush_Hua

7-Apr-10 20:35

Developers in Afghanistan strange

Re: pass javascript variable to asp.net function

Abdul Rahman Hamidy7-Apr-10 21:47

Abdul Rahman Hamidy

7-Apr-10 21:47

thanks for your strange, I think It shouldn't be strange. using Ajax is the simplest way which I am not willing to use.there are other solutions like using QueryString and Sesstion which I can use. but I thought of using javascript which I think this could be impossible.

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass javascript variable to asp.net function

Mogamboo_Khush_Hua8-Apr-10 0:07

Mogamboo_Khush_Hua

8-Apr-10 0:07

pagemethods in asp.net ajax , help u to call any function from aspx page in code page just google pagemethods

Re: pass javascript variable to asp.net function

Abdul Rahman Hamidy9-Apr-10 19:20

Abdul Rahman Hamidy

9-Apr-10 19:20

thanks for reply, You are asking me to use asp.net ajax and I am saying, I am in an envoirnment where no ajax should be used. every thing should be done through javascript and c#.

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass javascript variable to asp.net function

Mogamboo_Khush_Hua7-Apr-10 20:37

Mogamboo_Khush_Hua

7-Apr-10 20:37

Use Ajax

FCKEditor

sriharsha_127-Apr-10 18:56

sriharsha_12

7-Apr-10 18:56

I'm using FCKEditor in one of my pages....it was working fine....recently when i load that page in the place of the editor it shows "page cannot be found"....but when i run application in my local system it is working fine...

i even tested with live data in my local application everything is fine...there is no problem with the data, it is the editor that is not loading in my live application...any suggestions??

Re: FCKEditor

Anurag Gandhi7-Apr-10 20:37

Anurag Gandhi

7-Apr-10 20:37

There might be the problem with path.
The path/relative path w.r.t root folder might have been changed on deploying to the live server.
Also check whether all the files and folders required for FCK editor has been copied to the server.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

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