Posts Tagged net client code connect sql server database

SQL Update Code

Hi,

I have a DYNAMIC table with items from a database.
The table outputs the following (SAMPLE)

—————————–
<body>
<table width="800" border="0">
<tr>
<td><form id="frmMerchandise" name="frmMerchandise" method="post" action="">
<table width="100%" border="0">
<tr>
<td width="55%">Apples</td>
<td width="7%"><input name="Item_ID" type="hidden" id="Item_ID" value="2545"></td>
<td width="19%"><label>
<input type="text" name="Item_Price_Reg" id="Item_Price_Reg" />
</label></td>
<td width="19%"><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
<tr>
<td>Cherries</td>
<td><input name="Item_ID2" type="hidden" id="Item_ID" value="34"></td>
<td><input type="text" name="Item_Price_Reg" id="Item_Price_Reg" /></td>
<td><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
<tr>
<td>Bananas</td>
<td><input name="Item_ID3" type="hidden" id="Item_ID" value="136"></td>
<td><input type="text" name="Item_Price_Reg" id="Item_Price_Reg" /></td>
<td><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
<tr>
<td>Cucumbers</td>
<td><input name="Item_ID4" type="hidden" id="Item_ID" value="3789"></td>
<td><input type="text" name="Item_Price_Reg" id="Item_Price_Reg" /></td>
<td><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
<tr>
<td>Other</td>
<td><input name="Item_ID5" type="hidden" id="Item_ID" value="245"></td>
<td><input type="text" name="Item_Price_Reg" id="Item_Price_Reg" /></td>
<td><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
</table>
<p>
<label>
<input type="submit" name="Submit" id="Submit" value="Submit" />
</label>
</p>
</form></td>
</tr>
</table>
</body>
———————————-

From this page I wish to have a page constructed (item_update.asp) which will receive the values from the Item_ID, Item_Price_Reg and Item_Price_Sale and update an SQL database.

The SQL update code needs to be dynamic,and accept the values from the previous page dynamically, the Item_ID will change depending on which items are shown on the page.

Regards

Tags: , , , , , , , , , , , , , , , ,

MSMQ Watcher

Need someone to write a program that watches an MSMQ queue, responds to the message and sends a response according to the data entered.
This first task is a simple task:

1) Read queue and extract login credentials
2) Validate credentials against MS SQL Server database
3) Provide a response to the message (message may exceed 4Mb so chunking will be needed)
4) Would prefer WCF/MSMQ solution

Tags: , , , , , , , , , , , , , , , ,

Freelance ASP.NET Programmer In Mumbai

Looking for 2-3 years plus experienced ASP.NET programmer. Initial development will be 4 – 5 pages with database connectivity (SQL Server). After that next phase of development will be given.

Tags: , , , , , , , , , , , , , , ,

VB.Net SQL Connection Code

I am looking for code written with Visual Basic 2010 that will change the sql database for the dataset, binding source and tableadapter that were created by the wizard in VB 2010 at runtime. The new connection string must be created for a database that is selected by the user when with an opendialog. The structure of the databases will all be the same. The databases will not be attached to the server.

To show your code works I will need the following:
A mdi form containing two forms each with a datagrid that is attached to a bindingsource that was created with the wizard.
Form 1 should also have a button that opens a dialog box.
When I select another database the datagrid should refresh with the new data. When I open form 2 it should also contain the data from the new database.

Tags: , , , , , , , , , , , , , , , ,

Website Migration

My client had an online shop type website. It was hosted on another server with a redirect on the domain. We moved it back on to the server where the a record points to because we were missing out on SEO because of the redirection.

The previous host supported PHP and asp. This new one only supports asp.

The database needs upgraded to SQL Server and all procedures written in PHP that are responsible for uploading and resizing an image need to replicated in asp or asp.net (less than 10)

Tags: , , , , , , , , , , , , , , ,

E-Commerce Website

I want some one to design an excellent website with graphics to sell tobacco related products.
It should contain

* Product lists with pricing (Pricing will be changed dynamically, say every week)
* Shopping Cart
* Payment process

In back-end there will be a SQL server database to make sure that we can maintain the system through an external system.

Please let me know in details with your estimate.

Tags: , , , , , , , , , , , , , , ,

Access To SQL Connect, Database To Website

I have a website that is current using an access database to manage the memberships. I want to take all the records and put them into an SQL Server 2005 database from an Access database while keeping the website working correctly. I also need to then connect my current website, which is .asp, to the sql server and disconnect it from the access database.

I have a low budget but hope someone can complete this project satistactorily. There are only about 400-500 records that need to be moved to the SQL server 2005.

My budget is $100.00 for the project.

Tags: , , , , , , , , , , , , , , , ,

Re: Server Migration (Tailender)

Server migration to aws. Someone has already setup the server just need to migrate files and connect database.

NB: Cloud hosting

06/12/2010 at 22:02 EDT:

category added

Tags: , , , , , , , , , , , ,

Support Of Existing .NET/MSSQL Project.

We have existing online store, there is a need to do some modifications,
Project requires knowledge of
C#, MS SQL, JQuery/JavaScript.
The project is ongoing maintenance.

Tags: , , , , , , , , , , , , , , ,

Directory & New Site needs completion

New and Directory Website

Tags: , , , , , , , , , , , , , , , ,

Odds comparison xml import script

Description
We are looking for an odds-comparison script to be used in conjunction with approximately 8 XML feeds provided.
Similar Sites:
– betbrain.com
– bwin.com
– unibet.com
– bet365.com
– bet-at-home.com

The possibility to add all the bookmakers that we want.

In the page in which theres the comparison, should be shown an image that recall the bookmaker and clicking on it the user should be redirected in the page of the event (if this is impossible to do, the link should be the affiliate link with the bookmaker).
The odds should be updated every 5 minutes.

– Read odds from each bookmaker,
– Each odds may need to be stored in a MySQL or SQL server database (Windows hosted),
– Group bets for each match/game for different betting options. E.g. For Soccer: score, goalscorers, total goals etc;
– Extract/display each game for display on the web site, showing each bookmakers odds side by-side for that game.

For example, here are three feeds:
http://adserver.itsfogo.com/default.aspx?zoneid=44655
http://banners.willhill.com/xml/viewxml.asp?sport=FB&amp;style=10
http://xml.stanjames.com/data/football-coca-cola2.XML

You can see that each feed is completely different in its formatting, even though each feed is largely referencing the same games.

The specific items that will need to be parsed from the XML document are as follows:

Time of event:
The date and time of the scheduled match, in 24hr format (i.e. "23/04/2009 19.00").

League:
The league corresponding to the match (i.e. "World Cup" "Group B" or Premier League)

Home Team Name:
The name of the team playing at their home stadium (i.e. "Germany")

Visiting Team Name:
The name of the team visiting the opponents stadium (i.e. "Ecuador")

Home Money Line
Odds on the home team to win the match. (i.e. "7/1" or "8.00" *)

Away Money Line
Odds on the away team to win the match. (i.e. "7/1" or "8.00" *)

Draw Money Line
Odds on the match ending in a draw. (i.e. "7/1" or "8.00" *)

We will want to display both fractional and decimal odds for each game, each individual XML feed will have its own distinct formatting and naming conventions for each item to be parsed.
If a particular bookmaker does not offer any particular odds for a game, they will simply show as a blank entry for that game/field. The published odds require a bit of seo, with url names, titles and page headings matching.

Im here to listen your offers for it and Ill take a decision.

Example website:
– http://www.onlinewedden.net/wedden-voetbal-nederland-1-7/

Please bid ONLY if you skilled 🙂

Tags: , , , , , , , , , , , , , , , ,

Simple web page with connection to SSH

I need simple web page with a few input forms to input IP/user/login/port and the ability with this information to connect to server through ssh and send an integrated command (through button click) for example button "restart" and the command "/usr/local/etc/rc.d/apache22 restart" There are also some few other functions which we will discuss. The database will be MySQL.
Budget for this 100$.

Tags: , , , , , , , , , , , , , , , ,