|
Persist the Data either in the page view state or inside the session.Both these way will cause a severe performance issue.
|
|
|
|
|
check this latest post for ur issue
http://opexsolution.com/forum/viewtopic.php?f=15&t=20&p=52#p52
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Ok, then tell me the error. or if possible the show the code.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
tanweer akhtar wrote: dc.UserDetails.InsertOnSubmit(inf);
I guess inf is not the same type of data object in the table UserDetails.
|
|
|
|
|
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"); %>;
<%bindAdvancedFilterData(param.value); %>;
}
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
|
|
|
|
|
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.
|
|
|
|
|
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(param.value); %>;
}
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
|
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
|
|
|
|
|
|
Because you don't always need to use a hidden field.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Developers in Afghanistan strange
|
|
|
|
|
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
|
|
|
|
|
pagemethods in asp.net ajax , help u to call any function from aspx page in code page just google pagemethods
|
|
|
|
|
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
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
