Hi All, I am looking for suggestions; These are my requirements; 1)I need a chat to be integrated to my website(ASP) where in the admins(we have around 5) will able to see other users(around 60) but the other users will be able to see only the admins. The basic idea is the users should not chat with each other. 2)I am ready to pay for this component. 3)I checked eTalkUp.The issue is i dont know whether i can customize this chat as per my requirement (1).They will only answer technical details once we pay up.I dont want to pay up if my specific requirement wont be met. 4)Does anyone in this forum have any experience with eTalkUp?.Will we be able to implement my requirements in eTalkUp. 5)Is their any other chat component i can buy or download and integrate to my website that will meet my requirement (1).

Hey Thanks for the fast reply. I will read through this and post an update at the earliest. Thanks

Hi All, I am looking forward to write an application that will monitor my outlook and when ever i receive an email from a particular address say (codeproject@codeproject.com) will move this email to a particular location like copy the content of the email to a SQL database column. The options i thought was to write an add in for out look. But i think there will be easier solutions. Can anybody give me better and easier suggestions. I will be using VS2008,Outlook2003 and SQL server 2005. Many Thanks......

Hey Mika, I got it working.Thanks for your help......again :). Lots of Bestwishes, Jiju

Hey , Thanks a lot to you and Mika it worked. You guys have been wonderful. Hey i ran into another problem.... I might need to integrate one more condition;ie along with our query i want it to also do this that is if the customername is Mika (ie the name is only one word and it doesnot contain any ',' or ' ')Then it should update to FirstName.....Am pasting the working query below can any of you integrate this to my query..... Name FirstName LastName Mika Mika Ben Ben QUERY:update TableName set lastname= -- get the last name case when CHARINDEX(',', customername) > 0 then SUBSTRING(customername, 1, CHARINDEX(',', customername) - 1) -- comma is delimiter when CHARINDEX(' ', customername) > 0 then SUBSTRING(customername, CHARINDEX(' ', customername) + 1, LEN(customername) - CHARINDEX(' ', customername) + 1) -- space is delimiter else '' -- neither comma nor space found end, -- get the first name firstname = case when CHARINDEX(',', customername) > 0 then SUBSTRING(customername, CHARINDEX(',', customername) + 1, LEN(customername) - CHARINDEX(',', customername) + 1) -- comma is delimiter when CHARINDEX(' ', customername) > 0 then SUBSTRING(customername, 1, CHARINDEX(' ', customername) - 1) -- space is delimiter else '' -- neither comma nor space found end

modified on Thursday, December 11, 2008 2:23 AM

Hey Mika, The time now is 7:59 AM for you,i beleive....Happy sleeping:). Thanks again to you and Ben....It worked.I made slight modification in the query though...a very slight one. The credit goes to you guys .... Please see the working query and let me know if any tweaking is necessary...becuase i will be cghnaging this select to update query for around 9million records.....:) select customername, -- get the last name case when CHARINDEX(',', customername) > 0 then SUBSTRING(customername, 1, CHARINDEX(',', customername) - 1) -- comma is delimiter when CHARINDEX(' ', customername) > 0 then SUBSTRING(customername, CHARINDEX(' ', customername) + 1, LEN(customername) - CHARINDEX(' ', customername) + 1) -- space is delimiter else '' -- neither comma nor space found end as [lastname], -- get the first name case when CHARINDEX(',', customername) > 0 then SUBSTRING(customername, CHARINDEX(',', customername) + 1, LEN(customername) - CHARINDEX(',', customername) + 1) -- comma is delimiter when CHARINDEX(' ', customername) > 0 then SUBSTRING(customername, 1, CHARINDEX(' ', customername) - 1) -- space is delimiter else '' -- neither comma nor space found end AS [firstname] from TableName

Hey Mika, Thanks again to you and Ben....It worked.I made slight modification in the query though...a very slight one. The credit goes to you guys .... Please see the working query and let me know if any tweaking is necessary...becuase i will be cghnaging this select to update query for around 9million records.....:) select customername, -- get the last name case when CHARINDEX(',', customername) > 0 then SUBSTRING(customername, 1, CHARINDEX(',', customername) - 1) -- comma is delimiter when CHARINDEX(' ', customername) > 0 then SUBSTRING(customername, CHARINDEX(' ', customername) + 1, LEN(customername) - CHARINDEX(' ', customername) + 1) -- space is delimiter else '' -- neither comma nor space found end as [lastname], -- get the first name case when CHARINDEX(',', customername) > 0 then SUBSTRING(customername, CHARINDEX(',', customername) + 1, LEN(customername) - CHARINDEX(',', customername) + 1) -- comma is delimiter when CHARINDEX(' ', customername) > 0 then SUBSTRING(customername, 1, CHARINDEX(' ', customername) - 1) -- space is delimiter else '' -- neither comma nor space found end AS [firstname] from TableName

Hey Mika, Thanks for you trying to help.My server i unavailable now.I will be able to access it only after 5hours.As soon as i try thi s query i will post a reply and let you know. Many Thanks for your help....:) Merry Christmas

Hi Mika, I modified my query like this;It still is not working :( select customername, case when CHARINDEX(',', customername)>0 then substring(customername,1,CHARINDEX(',', customername) -1) as [firstname ], SUBSTRING(customername, CHARINDEX(',', customername) + 1, LEN(customername)) AS [LastName] else substring(customername,1,CHARINDEX(',', customername) -1) as [firstname ], SUBSTRING(customername, CHARINDEX(',', customername) + 1, LEN(customername)) AS [LastName] from TableName

Hello Friends, I wrote a query for a purpose like this;I have a field by name "CustomerName".I want it to be split as FirstName and LastName as shown below: CustomerName FirstName LastName Jack Daniels Jack Daniels Jack,Daniels Jack Daniels My query looks like this; select substring(customername,1,CHARINDEX(',', customername) -1) as [firstname ], SUBSTRING(customername, CHARINDEX(',', customername) + 1, LEN(customername)) AS [LastName] from TableName My Problem is i have two conditions the splitter could be "," or "" in the customername field I need to integrate this conditions to my query either using "case" or "iif". ie if the charindex is " " do this and if the charindex is ", " do this I am not sure how i can do this.Any help is welcome

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Diagnostics; using System.Data.SqlClient; namespace GUI { public partial class GUI : Form { public GUI() { InitializeComponent(); } private void GUI_Load(object sender, EventArgs e) { } private void btnCreate_Click(object sender, EventArgs e) { if (ifthursday()) { CreateDatabase(GetDatabasename()); CreateDatatable(GetTableName(), GetDatabasename()); } } /// /// Gets the name of the database from datetime picker and returns the value to the createDatabase Method /// /// /// public void Kill() { return; } public string GetDatabasename() { string namedatabase = dateTimePicker1.Value.ToString("MMdd"); string nameDB = "CustList_PGE_" + namedatabase; MessageBox.Show("The name of the database will be CustList_PGE_" + namedatabase); return nameDB; } public bool ifthursday() { //string dayisthursday= dateTimePicker1.Value.ToString("") if (dateTimePicker1.Value.DayOfWeek.ToString().Equals("Thursday")) { MessageBox.Show("Thursday"); } else if (MessageBox.Show("The selected date is not Thursday,Do you want to continue?", "Options", MessageBoxButtons.YesNo,MessageBoxIcon.Warning) == DialogResult.No) { return false; } return true; } /// /// Gets the name of the table from the datetime picker and returns the value to the createDatatable Method /// /// public string GetTableName() { string nameTable = dateTimePicker1.Value.ToString("MMddyy"); string nameTB = "CustList_PGE" + nameTable; MessageBox.Show("The name of the Table will be CustList_PGE" + nameTable); return nameTB; } //public void con() //{ // Businesslayer.Businesslayer

Thanks Mike. I did like this if (dateTimePicker1.Value.DayOfWeek.ToString().Equals("The selected date is Thursday")) { MessageBox.Show("Thursday"); } else MessageBox.Show("The selected date is not Thursday,Do you want to continue?", "Options", MessageBoxButtons.YesNo); } I have one more doubt; Is it possible for me to stop the process if i click on "No" in the message box? If yes How? Thanking You,

Hi, I am creating an applicatio that creates databases on the date provided. I have a problem. I am using datetimepicker for selecting the date. I need the application to create the database if teh day of the selected date is Thursday only.Otherwise it should show a message box saying "The selecetd day is not Thursday Do you want to continue or not". How can i do this? public string GetDatabasename() { string namedatabase = dateTimePicker1.Value.ToString("MMdd"); string nameDB = "CustList_PGE_" + namedatabase; MessageBox.Show("The name of the database will be CustList_PGE_" + namedatabase); return nameDB; } The above mentioed code takes the month and day. My datetime picker display is like Thursday February 28,2008 Planning to do it like if in the datetimepicker if its Thursday ,then it will go to a if statement and show the message box. But my problem is how can i read that it is a thursday from datetime picker. Thanking You,

Yes,because there is no other by that name.Thats why i am so much lost. For example i am creating the same stored procedure in another comp.But still getting the same error.

Thank You Sourie. It works. Thanks a lot :)

Hi Friends, May be this will help you guys to help me :). I have in the form a textbox,a enter button and datagrid. I want to enter data into my DB Table named "Self" on the click of button "Enter". Till there its working fine. Now on form load am trying to display the contents in my database (for simlicity i have only one coloumn in my database:"Name") in a datagrid. The problem am facing is in writting that part of the code. Shown below is my code.Please correct me. private void Form1_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(); con.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\My Documents\Selftest.mdb"; OleDbCommand cmd = new OleDbCommand(); cmd.CommandText = "select * from Self"; cmd.Connection = con; OleDbDataAdapter adap = new OleDbDataAdapter(); adap.SelectCommand = cmd; DataSet ds = new DataSet(); adap.Fill(ds); } Now i will display my entire code if it might help. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.Odbc; using System.IO; namespace My_self_Test { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(); con.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\My Documents\Selftest.mdb"; con.Open(); OleDbCommand cmdObj = new OleDbCommand(); cmdObj.CommandText = "Insert into Self(Name) values ('" + txtName.Text + "')"; cmdObj.Connection = con; cmdObj.ExecuteNonQuery(); } private void txtDisplay_Click(object sender, EventArgs e) { } private void gridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { } private void Form1_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(); con.Conn

Hello, Am trying to bind data.This is my code.Is there any problem with my code since it does not seem to work. Take your time. Thanking You using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace TestDb { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnInsert_Click(object sender, EventArgs e) { OleDbConnection conObj = new OleDbConnection(); conObj.ConnectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\j\My Documents\MyDb.mdb"; conObj.Open(); OleDbCommand cmdObj = new OleDbCommand(); cmdObj.CommandText = "Insert into MyTable(Name) values ('" + txtName.Text + "')"; cmdObj.Connection = conObj; cmdObj.ExecuteNonQuery(); txtName.Clear(); } private void btnBind_Click(object sender, EventArgs e) { OleDbConnection conObj = new OleDbConnection(); conObj.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\j\My Documents\MyDb.mdb"; conObj.Open(); OleDbCommand cmdObj = new OleDbCommand(); cmdObj.CommandText = "select Name from MyTable"; DataSet ds = new DataSet(); cmdObj.Connection = conObj; OleDbDataAdapter adapObj = new OleDbDataAdapter(); adapObj.SelectCommand = cmdObj; adapObj.Fill(ds); } } }

Hi, Thanks now it works. Thanks for the help. I changed it like this BODY { } .intro{ font-weight: bold; font-size: 14pt; font-family: arial; color:green; } .cashback{ font-size: 14pt; color: lime; font-style: italic; font-family: Arial; } .heading{ font-weight:lighter; font-size: 18pt; color: #09529E; font-family: Arial; } .notavailable{ font-size: 9pt; color: green; font-family: Arial; } .tabs { padding-right: 5px; padding-left: 5px; font-weight: bold; color: #09529E; text-align: center; text-decoration: none;line-height:24px; } a.tabs:link { color: #09529E; text-decoration: none; } a.tabs:visited { color: #000000; text-decoration: none; outline:none; } a.tabs:hover {color: orange; text-decoration: none;font-size: 24pt; } a.tabs:active { color: lime; } Thanks again

Hi, Thanks,but still the issue persists; My source: <%@ 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>Untitled Page</title> <link rel="Stylesheet" href="customer.css" /> </head> <body> <form id="form1" runat="server"><br /> <br/> <br/> <div class="cashback" > <asp:HyperLink ID="HyperLink1" CssClass="tabs" runat="server" NavigateUrl="http://www.google.co.in" BackColor="Transparent" BorderColor="#FFC0C0">Google</asp:HyperLink></div><br/> <br/> <div class="intro"> Program </div> <div class="cashback"> Get Cash back </div> <br/> <div class="notavailable"> Please inquire with your local company .</div> <br/> <div class="heading"> Mission Statement </div> <br/> Our mission has been simply stated and vigorously followed. <br/> <br/> <div class="heading">Brief History</div> <br/> We xxxxxxxxx </form> </body> </html> My CSS: BODY { } .intro{ font-weight: bold; font-size: 14pt; font-family: arial; color:green; } .cashback{ font-size: 14pt; color: lime; font-style: italic; font-family: Arial; } .heading{ font-weight:lighter; font-size: 18pt; color: #09529E; font-family: Arial; } .notavailable{ font-size: 9pt; color: green; font-family: Arial; } .tabs { padding-right: 5px; padding-left: 5px; font-weight: bold; color: #09529E; text-align: center } A.tabs:link { color: #09529E; text-decoration: none; } A.tabs:visited { color: #FFFFFF; text-decoration: none; outline:none; } a.tabs:hover {color: orange; text-decoration: underline; } A.tabs:active { color: lime } May be this will help Thanking you,

Thanks a lot ..........:) cheers to you i understood something that i always had difficulty in understanding.... :) :)