update query.. - ASP.NET Discussion Boards

Communicate between Applications using Httpcontext object.

suravi22-Jul-09 23:27

22-Jul-09 23:27

I have two applications configured in IIS. I need to Pass some values from one application to other using HttpContext object.

I have tried out using

FormsAuthentication.SetAuthCookie("Hello", false)

which sets one value in the Httpcontext object which i m retrieving from other application through

HttpContext.Current.User.Identity.Name property.

Upto this all works fine but i need to pass more user data using Httpcontext object and retrive it in other application.

How can i do that?
Is it possible to pass more user data Using HttpConext Object or not....

Please help me out Frown | :(

Re: Communicate between Applications using Httpcontext object.

Mike Ellison23-Jul-09 18:18

Mike Ellison

23-Jul-09 18:18

Actually, what is happening is simply a cookie being set on the client. SetAuthCookie establishes the user authentication cookie, which allows HttpContext.Current.User to be available.

If you want to application #2 to read application #1 data, you could have app#1 set a cookie that app#2 can then read.

MishaInTheCloud.blogspot.com

Read the list of all open windows in client machine

Ashi77722-Jul-09 23:17

Ashi777

22-Jul-09 23:17

I need to fetch the list of open windows, which all currently open in client machine. Though i did some finding and code is working in local web server, however this does not works if this hosted in remote machine.

I am trying to access the link (application hosted in remote server) in my local machine, and while doing so this does not return me list for currently opened windows.

What should i do to make this work? Here is the code sample i am using:-

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Runtime.InteropServices;
using System.Text;

namespace SIGN
{
public partial class EnumDesktopWindows : System.Web.UI.Page
{
const int MAXTITLE = 255;

private static ArrayList mTitlesList;

private delegate bool EnumDelegate(IntPtr hWnd, int lParam);

[DllImport("user32.dll", EntryPoint = "EnumDesktopWindows",
ExactSpelling = false, CharSet = CharSet.Auto, SetLastError = true)]
private static extern bool _EnumDesktopWindows(IntPtr hDesktop,
EnumDelegate lpEnumCallbackFunction, IntPtr lParam);

[DllImport("user32.dll", EntryPoint = "GetWindowText",
ExactSpelling = false, CharSet = CharSet.Auto, SetLastError = true)]
private static extern int _GetWindowText(IntPtr hWnd,
StringBuilder lpWindowText, int nMaxCount);

protected void Page_Load(object sender, EventArgs e)
{
string[] desktopWindowsCaptions = GetDesktopWindowsCaptions();
string tmpCaption=string.Empty;
foreach (string caption in desktopWindowsCaptions)
{
tmpCaption = tmpCaption + "@@@" + caption;
}
Response.Write(tmpCaption);
}

private static bool EnumWindowsProc(IntPtr hWnd, int lParam)
{
string title = GetWindowText(hWnd);
mTitlesList.Add(title);
return true;
}

/// <summary>
/// Returns the caption of a windows by given HWND identifier.
/// </summary>
public static string GetWindowText(IntPtr hWnd)
{
StringBuilder title = new StringBuilder(MAXTITLE);
int titleLength = _GetWindowText(hWnd, title, title.Capacity + 1);
title.Length = titleLength;

return title.ToString();
}

/// <summary>
/// Returns the caption of all desktop windows.
/// </summary>
public static string[] GetDesktopWindowsCaptions()
{
mTitlesList = new ArrayList();
EnumDelegate enumfunc = new EnumDelegate(EnumWindowsProc);
IntPtr hDesktop = IntPtr.Zero; // current desktop
bool success = _EnumDesktopWindows(hDesktop, enumfunc, IntPtr.Zero);

if (success)
{
// Copy the result to string array
string[] titles = new string[mTitlesList.Count];
mTitlesList.CopyTo(titles);
return titles;
}
else
{
// Get the last Win32 error code
int errorCode = Marshal.GetLastWin32Error();

string errorMessage = String.Format(
"EnumDesktopWindows failed with code {0}.", errorCode);
throw new Exception(errorMessage);
}
}
}
}

Re: Read the list of all open windows in client machine

himanshu256123-Jul-09 0:51

himanshu2561

23-Jul-09 0:51

Ashi777 wrote:
I need to fetch the list of open windows, which all currently open in client machine. Though i did some finding and code is working in local web server, however this does not works if this hosted in remote machine.

Yup that will happen because of the Asp.net nature.If you want this in client machine you have only one option that is ActiveX control... Smile | :)

himanshu

Re: Read the list of all open windows in client machine

Ashi77723-Jul-09 6:10

Ashi777

23-Jul-09 6:10

Thanks. Let me do some more digging

Re: Read the list of all open windows in client machine

DoctorMick23-Jul-09 5:16

DoctorMick

23-Jul-09 5:16

As the code runs on the server it is returning you the open windows on the server, not the client PC. This distinction about where code runs is often overlooked but it is fundamental to understanding ASP.net. As the above post, you'd need ActiveX.

Re: Read the list of all open windows in client machine

Ashi77723-Jul-09 6:10

Ashi777

23-Jul-09 6:10

Thanks. Let me do some more digging.

update query..

mylogics22-Jul-09 22:10

mylogics

22-Jul-09 22:10

hii.....
i wanna update the table column name Description (Having single row) through a multiline textbox.table name is ManageAboutJA.
i hav written following code but still its not updatin..can u help me..plz do help
string str = "UPDATE ManageAboutJA SET Description=@Descrip";
SqlCommand cmd = new SqlCommand(str,conn);
conn.Open();
cmd.Parameters.Add("@Descrip",TextBox2.Text);
cmd.ExecuteNonQuery();

conn.Close();

not even single time i use to get answers from cp why is it so...
wat is it ment for....
thnks...

Please Ignore : Cross Post

Abhijit Jana22-Jul-09 22:52

Abhijit Jana

22-Jul-09 22:52

Posting again and again will not help you. This is Rude.

pariofshona wrote:
not even single time i use to get answers from cp why is it so...
wat is it ment for....

That means you are not trying to follow the answer that other member already gave to you.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.

Re: update query..

saran78923-Jul-09 1:31

saran789

23-Jul-09 1:31

Why cant you try this. Simple when you are using only few parameters.
and dont forget to add where clause while updating, It may update all records in the table.

string str = "UPDATE ManageAboutJA SET Description='" + TextBox2.Text + "'";
SqlCommand cmd = new SqlCommand(str,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

Re: update query..

Abhijit Jana23-Jul-09 1:59

Abhijit Jana

23-Jul-09 1:59

saran789 wrote:
Why cant you try this. Simple when you are using only few parameters.

saran789 wrote:
tring str = "UPDATE ManageAboutJA SET Description='" + TextBox2.Text + "'";

This can cause SQL Injection. Smile | :)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.

datatable

Malik112222-Jul-09 21:58

Malik1122

22-Jul-09 21:58

i want to fill one datatable by another datatable but its not working. so plz help in solving this.

Re: datatable

Brij22-Jul-09 22:02

Brij

22-Jul-09 22:02

can you post your code?How are you doing this.

Cheers!!
Brij

Re: datatable

Malik112222-Jul-09 22:12

Malik1122

22-Jul-09 22:12

int colm = 0;
if (objBUS.busDataSet.Tables["tblSwapedColumns"].Columns.Count > 0)
{
for (int X = 0; X < objBUS.busDataSet.Tables["tblSwapedColumns"].Columns.Count; X++)
{
if (objBUS.busDataSet.Tables["tblSwapedColumns"].Columns[X].ToString() == objBUS.busDataSet.Tables["tbl"].Columns[colm].ToString())
{
if (colm == 0)
{
for (int Q = 0; Q < objBUS.busDataSet.Tables["tbl"].Rows.Count; Q++)
{
objBUS.busDataSet.Tables["tblSwapedColumns"].Rows.Clear();
DataRow DRow = objBUS.tblSwapedColumns.NewRow();

DRow[objBUS.busDataSet.Tables["tblSwapedColumns"].Columns[X]] = objBUS.busDataSet.Tables["tbl"].Rows[Q][colm].ToString();//here code
//give exception "Column 'FIRST NAME' does not belong to table tblSwapedColumns"
//'FIRST NAME' is the column name which is previously present in the table.

objBUS.tblSwapedColumns.Rows.Add(DRow);
}
colm++;
}
else
{
for (int Q = 0; Q < objBUS.busDataSet.Tables["tbl"].Rows.Count; Q++)
{
objBUS.busDataSet.Tables["tblSwapedColumns"].Rows[X][Q] = objBUS.busDataSet.Tables["tbl"].Rows[X][colm].ToString();
objBUS.busDataSet.Tables["tblSwapedColumns"].AcceptChanges();
}
colm++;
}
}
}
}

Re: datatable

Brij23-Jul-09 0:49

Brij

23-Jul-09 0:49

Sorry for late reply.But as your exception you are trying to access some invalid column name.Please check the schema..

Cheers!!
Brij

Re: datatable

Malik112222-Jul-09 22:39

Malik1122

22-Jul-09 22:39

you got what i have done...?

Re: datatable

Vimalsoft(Pty) Ltd22-Jul-09 22:04

Vimalsoft(Pty) Ltd

22-Jul-09 22:04

Good Mornig Malik1122

We cant know what is the Problem until we see the code, another thing that can be easly done on the SQL.

e.g

INSERT INTO TABLE2
SELECT COL1,COL2 FROM TABLE1
WHERE COL1 IS NOT NULL

Always try to keep the sql side in SQl , because these things can be achieve at ease that side than trying to loop through a datatable.

Please explain clearly what is your problem.

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: datatable

Malik112222-Jul-09 22:44

Malik1122

22-Jul-09 22:44

Good Morning Smile | :)

i have send the code so please check it and help me in doing this.

Re: datatable

Vimalsoft(Pty) Ltd22-Jul-09 22:50

Vimalsoft(Pty) Ltd

22-Jul-09 22:50

Can i see the Structure of tblSwapedColumns ?

Re: datatable

Malik112222-Jul-09 23:08

Malik1122

22-Jul-09 23:08

The column of 'tbl' are
1. FIRST NAME
2. LAST NAME
3. DATE OF BIRTH
4. AGE
5. GENDER

And that of 'tblSwapedColumns' are
1. GENDER
2. DATE OF BIRTH
3. AGE
4. LAST NAME
5. FIRST NAME

Re: datatable

Vimalsoft(Pty) Ltd22-Jul-09 23:15

Vimalsoft(Pty) Ltd

22-Jul-09 23:15

The Problem might be the names of your Columns in SQl it would be fine. Try not to name your Field names with Spaces , when Defining your Column names use something like th

First_Name or Firstname
Last_Name or LastName

please Fix that and try to run your code again