|
I have an ASP.NET database that lives online. I would really love to be able to run a local version and do "batch updates" or to synchronise them daily, but our developer says it's in the too hard basket?
regards
Max 
|
|
|
|
|
What do you mean by ASP.NET database?
Database name should be something like MSSQL, MySQL or etc...
|
|
|
|
|
It's an online database built using asp.net technology - cannot expand on this as that's all the developer said.
regards
Max
|
|
|
|
|
>>It's an online database built using asp.net technolog
ASP.NET is a programming language for developing Web Application on Microsoft Platform.
Okay. Anyways..
Let's say you have MSSQL database which is hosted on Live Server. You also have another database in local machine.Your goal is that you wanna do synchronization or batch-update from Local Database to Live Database. You wanna know whether it's easy to achieve this goal or not.
The answer is that it's not that difficult if you have reliable and high-speed internet connection. There are some build-in features for this purpose in the most of databases. But you have to think about security issue very seriously.
|
|
|
|
|
Hi,
I am a student and making a final project on web development, my project is on House decoration but my problem is i want my website to have its own amail id like info@housedecoration.com, so that if the company wants to send any newsletter or and reply of the request made by the user he can.
My supervisor is out of country and i need an help I am using ASP.NET and VB.NET for my project. Now plz can anyone help me in giving code that how can i implement it
Regards,
fiaz_khawaja@hotmail.com
Khawaja
|
|
|
|
|
So you want someone to write an SMTP server and give you the code? Wow.
See if your hosting provides email boxes, otherwise you need a server with MS Exchange, postfix, or some other SMTP server on it.
|
|
|
|
|
It's not about programming languages (eg: VB.NET or ASP.NET). AFAIK, you can only have that kinda Email Id when you owned this domain..
For example, I owned one domain name called "http://michaelsync.net". So, I can create any Email address like info@michaelsync.net or blabla@michaelsync.net.
So, If you are sure that you own this website "http://housedecoration", you can create the id that (info@housedecoration.com) you want.
Only thing you need to do is that you need to buy this domain. Then, you can use Google Application (http://google.com/a/) to host your email. Plus, you need to configure MX record in your domain in order to use Google Application as Email hosting..
Hope it helps.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
|
|
|
|
|
Hi
I have writing the following login screen in asp.net which uses an stored procedure, which if the login credentials equal whats returned from the select statement it should return a 1
I am having problems getting my asp page to grab the value which is returned from the stored procedure
for some reason this code sets the return value to 6, wether its right or wrong!
here is my stored procedure code
CREATE DEFINER=`jshort`@`localhost` PROCEDURE `sp_userlogin`(IN p_UserName VARCHAR(50), IN p_Password VARCHAR(50))
BEGIN
IF EXISTS(SELECT * FROM Users WHERE UserName = p_UserName AND PASSWORD = p_Password) THEN
SELECT 1;
ELSE
SELECT 0;
END IF;
END
and my code for the asp page is as follows
Sub sendData(ByVal sender As Object, ByVal e As EventArgs)
Dim litErr As New LiteralControl
'Create connection string to pass database, string holds login information to mySQL,
Dim connectionString As String
connectionString = "Server=localhost; uid=; pwd=;database=ftp1;"
'Builds .net mysql connection and passes connection string into method
Dim connection As New MySqlConnection(connectionString)
'Create mySql command string for passing query or SPROC(Stored Procedure)
Dim cmdString As New MySqlCommand
'Set Command to equal mySql connection,t so can pass SQL query
cmdString.Connection = connection
Try
'Set command string to equal SPROC
cmdString.CommandText = "sp_userlogin"
'ONLY PLACE THIS IF SPROC, sets the command to a SPROC
cmdString.CommandType = CommandType.StoredProcedure
Dim param As New MySqlParameter
param = cmdString.Parameters.Add("?p_username", MySqlDbType.VarChar)
param.Direction = ParameterDirection.Input
param.Value = txtUserName.Text
param = cmdString.Parameters.Add("?p_password", MySqlDbType.VarChar)
param.Direction = ParameterDirection.Input
param.Value = txtPassword.Text
param = cmdString.Parameters.Add("return", MySqlDbType.Int32)
param.Direction = ParameterDirection.Input
param.Value = ParameterDirection.ReturnValue
'Executes stored procedure
connection.Open()
cmdString.ExecuteNonQuery()
connection.Close()
Catch ex As Exception
'Returns error message
litErr.Text = ex.Message
MsgBox(ex.Message)
End Try
Dim validation As Object = cmdString.Parameters("return").Value
If validation = 0 Then
MsgBox("user login not valid")
Else
Response.Redirect("userhome.aspx")
End If
|
|
|
|
|
boyindie wrote: I am having problems getting my asp page to grab the value which is returned from the stored procedure
No wonder, as your procedure isn't returning any value.
As your procedure is sending a result (using a select query), you have to use ExecuteReader or ExecutScalar instead of ExecuteNonQuery to get the result.
---
single minded; short sighted; long gone;
|
|
|
|
|
can we hide (set visible = false) of an item inside the datalist? Note: this item is NOT a server control like asp:label or asp:button, etc so it does not have an ID. This item is just a link that is executed on clientside.
I would appreciate your help very much!
|
|
|
|
|
I have a gridview that contains a checkbox for a user to select his choice.
I want a code that enables user to check all and uncheck the check box at ones
I am using ASP.net and C_sharp.And this should be done with out postback.
Please advice
|
|
|
|
|
use javascript.
and performe your job in a java script function
|
|
|
|
|
javascript will solve it!!
but one thing,the id of the controls inside the gridview is different from the server controls!!!!
In the page check the id of the checkboxes with viewsource of the page!!!
Write the javascript accordingly!!!!
Hope itll help!!!
I was born dumb!!
 Programming made me laugh !!!
--sid--
|
|
|
|
|
Could you give me a code in javascript and how to incorporate in in to my ASP.net,C sharp?
I havent used Javascript before.
Thanks for your help
|
|
|
|
|
FUNCTION FUNC_NAME()
{
VAR CHK=DOCUMENT.GETELEMENTBYID("CHECK BOX NAME");
VAR COUNT="COUNT_OF_CHECKBOXES";
WHILE(COUNT>0)
{
IF(CHK.CHECKED==TRUE)
{
CHK1.CHECKED=TRUE;
}
ELSE
{
CHK1.CHECKED=FALSE;
}
}
IN THE CODE
CHECK_ALL_CHECK_BOX.ATTRIBUTES.ADD("ONCLICK","RETURN FUNC_NAME();");
HOPE IT HELPS!!!!
I was born dumb!!
Programming made me laugh !!!
--sid--
|
|
|
|
|
Thanks very much.Where will i put the code in the (.aspx) for the page together with the HTML. or somewhere else...
Please advice
Thanks for your time
|
|
|
|
|
I need to check enable and disable (using Javascript code) value of following steps:
Tools->Internet Options->Security->LocalIntranet->Custom Level->initialize and script activeX controls not marked as safe for scripting
I need to change values in registy of Enabling and Disabling using Javascript code.
If my question was not good defined plz ask.
I Love SQL
|
|
|
|
|
OK, if what you want to do works, then it's a huge security hole, and I hope Microsoft fixes it soon.
In other words, forget it. Perhaps your intentions are benign, but you're asking how to do something that every person trying to spread a virus via the web would want to do. I'm sure there were ways to do that in 1998, but not today.
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 )
|
|
|
|
|
Hello All;
I have search page and result page.
in search page I have drop down list that specify the value of car
like this * <20000 * between 20000 and 300000 * >300000
the selected value sent in query string .I have colum in table Name (price) type (money) that get the value from QueryString diplay the datalist in depend of it .
but give error always? unable to convert string value to ... moeny and something like that
anybody can help
aj123
|
|
|
|
|
Based on your description, I doubt you'll get any help. The error you get obviously relates to a point in the code where you try to convert a string to a numeric value. Find that code, and fix it, and you'll be done. Or, perhaps the error is in the list control, your aspx is trying to bind a numeric format, and getting a string back.
Set some breakpoints and work out what data is causing the error, then you should be able to work out how to fix 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 )
|
|
|
|
|
I'm coming across a problem while trying to read values from dynamically added text boxes. This is my method:
*Create placeholder inside of the aspx.
*Read in data from sql, creating a label and textbox for each entry.
*Add those controls to the placeholder.
That works just fine. However, I can't seem to read the values from those dynamically added textboxes. When I run in debug mode, the placeholder is empty by the time the page loads. Any advice on the matter?
Thanks.
|
|
|
|
|
I found out that it will not delete the controls inside of the placeholder, provided I DO NOT assign the controls a unique id. This functionality is... strange at best. But I guess a part of learning a solution is becoming familiar with its quarks.
|
|
|
|
|
Hi everybody,
I'm new to asp.net, I was a PHP programmer so I have some questions.
How I can write something like include in asp.net, also I do not know why but master Pages do not work. 
Here is the Result of Running Master page:
"The type of page you have requested is not served because it has been explicitly forbidden. The extension '.Master' may be incorrect. Please review the URL below and make sure that it is spelled correctly. "
Thanks a lot,
|
|
|
|
|
Master pages are not served, only aspx pages, Master pages are used as templates by the aspx pages for layout and common controls across many pages, supose you want the same navigation on every single page you would create the navigation in the master page, maybe add some logic to it and then just reference the master page from the aspx page the easiest way to do this is first create the master page, and then just right click on the master page and select the "add new content page" option from menu.
Includes is a different thing, if is logic you want you can create this logic in classes and reference them in your logic for the pages, but if what your looking is for layout I would suggest researching more on the master pages.
Greets! Joel
|
|
|
|
|
Thanks for your answer 
Yes, I want includes for layout, but Master Pages are really better but I can't configure them correctly. So I create a Master Page, then Content page for this master page and execute this content page. Am I right?
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
