Tuesday, April 27, 2010

C# Bits: DisplayAttribute “Prompt” or Watermark in Dynamic Data 4 (Visual Studio 2010 & .Net 4.0)

C# Bits: DisplayAttribute “Prompt” or Watermark in Dynamic Data 4 (Visual Studio 2010 & .Net 4.0)

Error: Debugging Failed Because Integrated Windows Authentication Is Not Enabled

Error: Debugging Failed Because Integrated Windows Authentication Is Not Enabled

To enable integrated Windows authentication
Log on to the Web server by using an administrator account.

Click Start and then click Control Panel.

In Control Panel, double-click Administrative Tools.

Double-click Internet Information Services.

Click the Web server node.

A Web Sites folder opens underneath the server name.

You can configure authentication for all Web sites or for individual Web sites. To configure authentication for all Web sites, right-click the Web Sites folder and then click Properties. To configure authentication for an individual Web site, open the Web Sites folder, right-click the individual Web site, and then click Properties.

The Properties dialog box is displayed.

Click the Directory Security tab.

In the Anonymous access and authentication control section, click Edit.

The Authentication Methods dialog box is displayed.

Under Authenticated access, select Integrated Windows authentication.

Click OK to close the Authentication Methods dialog box.

Click OK to close the Properties dialog box.

Close the Internet Information Services window.

http://msdn.microsoft.com/en-us/library/x8a5axew(VS.90).aspx

Tuesday, April 20, 2010

Merging Multiple XML Files

XStreamingElement mergeElem = new XStreamingElement(rootName,
  from at in FileMergeAttributeStreamAxis(localFiles.First(), rootName) select at,
  from el in FileHeaderStreamAxis(localFiles.First(), mergeName) select el,
  new XStreamingElement(mergeName,
    from at in FileMergeAttributeStreamAxis(localFiles.First(), mergeName) select at,
    from el in FileMergeElementStreamAxis(localFiles, mergeName) select el),
  from el in FileTrailerStreamAxis(localFiles.Last(), mergeName) select el
);
 
 

Thursday, April 15, 2010

Run stored proc using cmd.Parameters.AddWithValue C#

void

crtaspdotcustMsg()

{

SqlConnection myConnection = new SqlConnection(ConnectionString);

//string strSQL = "jde_rk.dbo.lins_CustomerMsg '" + @Email + "','" + Txtfn.Text + "','" + txtLnam.Text + "','" + Txtphno.Text + "','" + TextBox12.Text + "','" + TextBox10.Text + "','" + Session["Usrid"] + "','" + 11 + "'";

string strSQL = "jde_rk.dbo.lins_CustomerMsg ";

SqlCommand cmd = new SqlCommand(strSQL, myConnection);

cmd.CommandType =

CommandType.StoredProcedure;

cmd.Parameters.AddWithValue(

"@Email", Txtemail.Text);

cmd.Parameters.AddWithValue(

"@Firstname", Txtfn.Text);

cmd.Parameters.AddWithValue(

"@Lastname", txtLnam.Text);

cmd.Parameters.AddWithValue(

"@Phone", Txtphno.Text);

cmd.Parameters.AddWithValue(

"@PHSUB", TextBox12.Text);

cmd.Parameters.AddWithValue(

"@PHMSG", TextBox10.Text);

cmd.Parameters.AddWithValue(

"@PHUSER", Session["Usrid"]);

cmd.Parameters.AddWithValue(

"@CustomerID", 111);

myConnection.Open();

cmd.ExecuteNonQuery();

myConnection.Close();

}

Wednesday, April 14, 2010

Dataset row count C#

//Response.Write(ds.Tables[0].Rows.Count);

ds.Tables[0].Rows.Count

Wednesday, April 7, 2010

Create a folder mm.dd.yyyy in dos command or in batch file

Create a folder mm.dd.yyyy in dos command or in batch file

echo on

::variables

set folderdate="%date:~4,2%.%date:~7,2%.%date:~10,4%"

mkdir c:\%folderdate%

PAUSE




--
Rajeev Kumar

Monday, April 5, 2010

Asp.net 4.0 Accessing access database queries in gridview

<%

@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<

html xmlns="http://www.w3.org/1999/xhtml">

<

head runat="server">

<title></title>

</

head>

<

body>

<form id="form1" runat="server">

<div>

<br />

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true"

DataSourceID="AccessDataSource2" DataTextField="Owner" DataValueField="Owner">

</asp:DropDownList>

<asp:AccessDataSource ID="AccessDataSource2" runat="server"

DataFile="S:\CertificatesDB.mdb"

SelectCommand="SELECT distinct [Owner] FROM [500a1: Daily Report]">

</asp:AccessDataSource>

<br />

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

DataSourceID="AccessDataSource1">

<Columns>

<asp:BoundField DataField="Owner" HeaderText="Owner" SortExpression="Owner" />

<asp:BoundField DataField="Store" HeaderText="Store" SortExpression="Store" />

<asp:BoundField DataField="CityState" HeaderText="CityState"

SortExpression="CityState" />

<asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />

<asp:BoundField DataField="UPC" HeaderText="UPC" SortExpression="UPC" />

<asp:BoundField DataField="Sales" HeaderText="Sales" SortExpression="Sales" />

<asp:BoundField DataField="Units" HeaderText="Units" SortExpression="Units" />

</Columns>

</asp:GridView>

<asp:AccessDataSource ID="AccessDataSource1" runat="server"

DataFile="S:\CertificatesDB.mdb"

SelectCommand="SELECT * FROM [500a1: Daily Report] WHERE ([Owner] = ?)">

<SelectParameters>

<asp:ControlParameter ControlID="DropDownList1" Name="Owner"

PropertyName="SelectedValue" Type="String" />

</SelectParameters>

</asp:AccessDataSource>

</div>

</form>

</

body>

</

html>