Great Deals for Families

Wednesday, June 10, 2020

Adaptive Insight Data Integration & Connection API

Web Services API
• Design and implement your own automated integration to Adaptive products
• Access data within your Adaptive application with a lightweight interface
• Adhere to RESTful Web Services principles
• Accepts and returns requests in the form of XML documents

http://cloud-erp.com.au/wp-content/uploads/2014/08/ap_data_integration_screen.pdf

Thursday, July 12, 2018

MVC CSHTML Database connection using Connectionstring

MVC CSHTML Database connection using Connectionstring
got error WebMatrix.Data
you have to do reference in reference folder
find WebMatrix.Data.dll in machine browse and add. after that write code as following:-

@using WebMatrix.Data;

@{
/**/

ViewBag.Title = "About";
var db = Database.Open("vislidbConnectionString");
var selectQueryString = "SELECT * FROM [vislidb].[dbo].[tbl_OrderUserDetails]";

}

@ViewBag.Title.

@ViewBag.Message

Use this area to provide additional information.

this is test1

this is test2

Id
Product
Description
Price

@foreach (var row in db.Query(selectQueryString))
{

@row.UDUSRID
@row.UDPASSWD
@row.UDFNAM
@row.UDLNAM

}

Wednesday, May 23, 2018

Sample Select Web page c# gridview

Default.aspx:

asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" DataKeyNames="BusinessEntityID"
GridLines="None" AutoGenerateColumns="False" AutoGenerateEditButton="True" AutoGenerateDeleteButton="True" DataSourceID="SqlDataSource1">

connection string

ConnectionString="<%$ ConnectionStrings:AdventureWorks2008R2ConnectionString %>"
UpdateCommand= "update Person_test set BusinessEntityID=@BusinessEntityID,FirstName=@FirstName,MiddleName=@MiddleName,LastName=@LastName WHERE BusinessEntityID=@BusinessEntityID"
DeleteCommand="Delete from Person_test where BusinessEntityID=@BusinessEntityID"

>

Default.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlDataSource1.SelectCommand = "SELECT * FROM [Person_test]";
}
protected void Button1_Click(object sender, EventArgs e)
{
// SqlDataSource1.SelectCommand = "select * from Person_test where BusinessEntityID ='" + TextBox1.Text + "' or FirstName= '" + TextBox2.Text + "' or MiddleName= '" + TextBox3.Text + "' or LastName='" + TextBox4.Text + "'";
SqlDataSource1.SelectCommand = "Select * from Person_test where BusinessEntityID like '%" + TextBox1.Text + "%'or FirstName like '%" + TextBox2.Text + "%'or MiddleName like '%" + TextBox3.Text + "%'or LastName like '%" + TextBox4.Text + "%'";
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlDataSource1.SelectCommand= "Insert into person_testshweta([BusinessEntityID],[FirstName],[MiddleName],[LastName]) select '"+TextBox1.Text+"','"+TextBox2.Text+"','"+TextBox3.Text+"','"+TextBox4.Text+"'";
}
}

Webconfig.aspx

providerName="System.Data.SqlClient" />

Sql command to create table

select BusinessEntityID,FirstName,LastName into Person_test from Person.Person

Thursday, May 10, 2018

Divide by Sum SQL Server same table join

select a.objsub,a.bu, a.period_01a, a.period_01a/sum(b.period_01a),sum(b.period_01a)FROM FORECAST_DATA a
left outer join FORECAST_DATA b on a.bu=b.bu and b.objsub like '9991%'
where left(a.objsub,2) in ('41','53','54','55','56')
--and a.bu='021000'
group by a.objsub, a.period_01a,a.bu
having sum(b.period_01a)<>0

Wednesday, March 7, 2018

SQL Server VBA Connection and display on Excel

Sub ExcelADOSQLServer()

Dim Cn As ADODB.Connection
Dim Server_Name As String
Dim Database_Name As String
Dim User_ID As String
Dim Password As String
Dim SQLStr As String
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset

SQLStr = "SELECT top 100 * FROM [GLDATA]" ' Enter your SQL here

Set Cn = New ADODB.Connection
Cn.Open "Driver={SQL Server};Server=JDEDBPC01\SQL1; Database=budget; UID=budget; PWD=M3dak$AP"

rs.Open SQLStr, Cn, adOpenStatic
Dim NewRecord As Range

ThisWorkbook.Sheets("Sheet1").Range("B2").CopyFromRecordset rs

rs.Close
Set rs = Nothing
Cn.Close
Set Cn = Nothing
End Sub

Thursday, March 30, 2017

Add a task C# sample outlook

Outlook.TaskItem task = null;
Outlook.RecurrencePattern recPattern = null;
 
try
{
    task = (Outlook.TaskItem)OutlookApp.CreateItem(Outlook.OlItemType.olTaskItem);
    task.Subject = "Do billing";
    task.StartDate = new DateTime(2013, 06, 25);
    task.DueDate = new DateTime(2013, 06, 25);
    task.Status = Outlook.OlTaskStatus.olTaskNotStarted;
 
    recPattern = task.GetRecurrencePattern();
    recPattern.RecurrenceType = Outlook.OlRecurrenceType.olRecursMonthly;
    recPattern.PatternStartDate = new DateTime(2013, 07, 25);
    recPattern.NoEndDate = true;
    task.Save();
}
finally
{
    if (recPattern != null)
        Marshal.ReleaseComObject(recPattern);
    if (task != null)
        Marshal.ReleaseComObject(task);
}

https://www.add-in-express.com/creating-addins-blog/2013/06/12/outlook-tasks-create-get-delete/

Tuesday, May 24, 2016

Javascript get text from dropdown

alert( occupation1.options[occupation1.selectedIndex].text);

Sunday, August 22, 2010

YouTube - Little Mermaid 2: Return to the Sea part 3

Saturday, March 28, 2009

Apple iPod classic 80 GB Silver (6th Generation)

Apple iPod classic 80 GB Silver (6th Generation)

Price:
$199.99

Thursday, January 8, 2009

Transcend T.sonic 850 8 GB Video MP3 Player (Black): Electronics Price: $64.82

Transcend T.sonic 850 8 GB Video MP3 Player (Black): Electronics

List Price:
$75.99
Price:
$64.82 & this item ships for FREE with Super Saver Shipping. Details
You Save:
$11.17 (15%)
http://www.svdeals.com/

Cross Hamilton Ballpoint & Pencil Set, Chrome With Checkered Engraved Pattern Cap & Black Lacquer Barrel: Office Products Price: $24.99

Cross Hamilton Ballpoint & Pencil Set, Chrome With Checkered Engraved Pattern Cap & Black Lacquer Barrel: Office Products

Price:
$24.99 & eligible for FREE Super Saver Shipping on orders over $25. Details
http://www.svdeals.com/

Wednesday, January 7, 2009

Swingline Collectors Edition 747 Rio Red Business Stapler (S7074736E): Office Products Price: $13.99

Swingline Collectors Edition 747 Rio Red Business Stapler (S7074736E): Office Products

List Price:
$36.49
Price:
$13.99 & eligible for FREE Super Saver Shipping on orders over $25. Details
You Save:
$22.50 (62%)
http://www.svdeals.com/