|
I am trying to develop a concept for my back-office system so that I can define the work that needs to be done. I am not a programmer so please be gentle with me!
I have an MS SQLExpress database sitting behind my (VB.Net2) my website. The database has a table into which orders go when customers buy online.
What I want to do is to have a copy of this table on my local server and use a web service to feed the local database from the website database.
I already have a web service which takes data from the local database up to the web database. Thus my assumption that a web service would be the best way to bring data down.
So my idea is that as soon as the website database receives a new record it initiates the web service which sends the record down to the local databse. But can the website database trigger the sending down of data when a new record is added to a table?
Simple in theory but is this feasible in practice?
Thanks in anticipation.
Chris
|
|
|
|
|
A webservice does not push, it pulls. So, the web service needs to be on the machine that is recieving the data not sending it.
You can write triggers in your DB, and you can run .NET code in SQL Server 2005, so I don't see why this should be a problem.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
cbjroms wrote: copy of this table on my local server and use a web service to feed the local database from the website database.
Are these two databases on the same server? SQL2005 does have support for creating http endpoints, though it isn't for a novice. There is also an option to use Service Brokers to communicate between the databases, but again it isn't a novice skill.
cbjroms wrote: I am not a programmer so please be gentle with me!
No offensive, but maybe you should leave this to professionals.
only two letters away from being an asset
|
|
|
|
|
If you just want a copy, why not just have the database back itself up to the local server periodically?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
How can I clear the history of a browser page by using scripts or programming
Gopinath.R
|
|
|
|
|
Use the following script for the same in your first page:
<script type="text/javascript" language="javascript">
javascript:window.history.forward(1);
</script>
Best Regards,
Sam Xavier
www.componentone.com
|
|
|
|
|
Dear all,
i have one table named ContactPerson in which there is one column named "PersonImg" which has a datatype - image and it stores image(.gif, .jpeg) in binary format.
I have inserted data into one XML file, but i m not able to read that image data from XML file in .aspx page.
Needed yr help. Any suggestion is welcome.
Thanks in advance
Regards,
Rana k.j.
|
|
|
|
|
The data should be in a CDATA tag, and then you get it out using normal XML methods, and build the image by passing the data via a stream to it's constructor. Of course, you won't be able to display an image that's not on your file system, unless you have a custom page extension and custom handler defined which reads this data and passes it down to the client, in this case, you'd just pass the data out of the CDATA tag. Now, a CDATA section that contains binary data, would need to be uuencoded, or similar, to make all the data appear as text. So, it would have to be converted back to a byte stream of pure data at the other end.
Where is the XML coming from ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
window.location.replace(URL)only works in IE. I need it to be worked in both the IE and Firefox... Could you help me
Advance thanks for ur help
Gopinath.R
modified on Wednesday, February 27, 2008 7:41 AM
|
|
|
|
|
Try this function
function Redirect(URL)
{
if (window.location.replace)
window.location.replace(URL)
else
window.location.href=URL
}
*jaans
|
|
|
|
|
Hello Friends,
I've no knowledge about AJAX in ASP.NET can anybody suggest me the right book(s) for the AJAx......
Thnx in Advance
|
|
|
|
|
|
AJAX in Action is a great book if you want to learn AJAX. If you just want to use the ASP.NET AJAX library, then the best book is ASP.NET AJAX in Action[^]
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I have a web form in asp.net and C# on the basis of selection from the dropdown i fill a dataset then assign that dataset to a reportdocument
datasource. that data set fills, but when the report is loaded there
is no data . I also have a Dataset1.xsd file which has a table with
same structure as that is filled with data in SP
In crystal report i have selected project data as dataset1.tablename
Pls help....
Code is as below
int sbu = Convert.ToInt32(ddl1.SelectedItem.Value);
report=new CrystalReport1();
string conn1 = " ";
SqlConnection conn = new SqlConnection(conn1);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("sp_cis",conn);
DataSet Dataset1 = new DataSet();
DataTable Temp = Dataset1.Tables.Add();
Temp.TableName="CISTemp";
SqlCommand cmd = new SqlCommand("sp_cis",conn);
cmd.CommandType= CommandType.StoredProcedure ; cmd.Parameters.Add( new SqlParameter("@hlevelid",sbu));
da.SelectCommand=cmd;
da.Fill(Dataset1,"CISTemp");
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
myReportDocument.Load(Server.MapPath("CrystalReport1.rpt"));
myReportDocument.SetDataSource(Dataset1); CrystalReportViewer1.ReportSource = myReportDocument;
CrystalReportViewer1.DataBind();
|
|
|
|
|
Hi,
I have a DataList listing the items a customer has added to their shopping cart. The quantity value of each item in the cart is displayed in a textbox (also happy to go with a DropDownList).
I need for the customer to be able to simply change the textbox value (or DropDownList value), and then this automatically update the cookie which corresponds to this item.
My problem is that i dont know how to transfer the DataList row data to a usable codebehind class/method. Normally if say using a button its a simple case of adding a CommandName to the button, which is called from the codebehind when the button is pressed.
Any help would be greatly appreciated.
|
|
|
|
|
I have created login1.ascx
and using that in newlogin.aspx
when user clicks a linklable in newlogin.aspx
I need to display login1.ascx but the rest of page should be transperant
reg..
prashanth,
s/w Engineer,
Syfnosys.
|
|
|
|
|
pashitech wrote: I need to display login1.ascx but the rest of page should be transperant
Once page is rendered and shown in the browser, there is no separation like user controls and page. All the controls including user controls will be rendered to produce the single page. That said, you won't be able to do what you are asking.
|
|
|
|
|
please refer to
www.seventymm.com
in the bottom(footer)
click on contct us
I just want to display like that, but directly user control
prashanth,
s/w Engineer,
Syfnosys.
|
|
|
|
|
Place a div that covers the entire page with a semi-transparent background image (png). Place the control on top of that div.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
hi,
i am developing a web application in asp.net (c#), when i m logged in related entries are made in database. similar with logout, now suppose if i logged in and my net connection is failed. how can i check this and make logout entries in database.
need urgently, please
thanking you in advance.
Ratnadeep Raul
Web Developer
|
|
|
|
|
AFAIK, there is no efficient method to do. You need to keep the time when user logged in. And update the logout time from a scheduled job by comparing the login time. This scheduled job should run at specified intervals.
|
|
|
|
|
hi,
i m developing chat application. i have used iframe which displays chat message. what i want is when i write message in textbox and click on send button. iframe should scroll down to show the latest message.
please someone help me, i need it urgently
|
|
|
|
|
Hi
I have a query which is inserting a value into datetime field in a database. It shows the error:
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated."
Any help woudl be great thanks!!
DateTime dttimenow = DateTime.Now;
dttimenow.ToShortTimeString();
lbtime.Text = dttimenow.ToShortTimeString();
string sttiming = lbtime.Text;
SqlCommand insertusername = new SqlCommand("INSERT INTO table(Startdate) VALUES
('" + stdate + "') ", con);
|
|
|
|
|
delete from table
where field< dateadd(day,-1,getdate())
cheers!!
|
|
|
|
|
Hi,
try with the following statement for inserting value into Datetime field
string sttiming = DateTime.Parse(DateTime.Today.ToShortDateString(), System.Globalization.CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat)
instead of ur
DateTime dttimenow = DateTime.Now;
dttimenow.ToShortTimeString();
lbtime.Text = dttimenow.ToShortTimeString();
string sttiming = lbtime.Text;
code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
