Yes I check it it is there and as I said write now it is working.

Thanks Simon..As I already said it was working fine for many days and still working fine but a few day back I got the error 'Message Queuing has not been installed' and I just want to know what have caused this error.

1. First Create a temp tabel. 2. Then count the now of row in the first table. 3. use loop while < rownum Then add the column in the temp table using the below dynamic query ( set @colname = @colname + ' ALTER TABLE #Temp ADD col'+ cast(@count as varchar(10)) + ' decimal(10, 2) NULL ' exec(@colname) ) 4. using cursers update the different column values.

I am running a dotnet application which grabes the broadcast message in MSMQ. The apllication works fine at most of the time but recently I got an error "Message Queuing has not been installed.." while it was working fine before that. Do anybody has any idea about it? What may be the causes this error. Thanks Hem

Before instering the arabic value put N before the text... N’Arabic Text’

If the stored procedure you are using for your search takes both eventID and Status field then you need to pass both the parameter otherwise always error message will be thrown. My suggestion is either you use different stored procedure for different combination of search criteria or handlle it on the single stored procedure depending upon the value of SQL parameter.

In Rollback part just add the dll... I think it should work...jus try it

if(dateTimePicker1.Value>DateTime.Now) { MessageBox.Show("Greater"); }

use it like below.. try { while(dbrUsers.Read()); { pwd = dbrUsers.GetString(0); } } catch(Exception e) { }

R u changing(Enrypting/Decrpting) value of connection string in web config each time. You just need to put encrypted connection string in web config and whenever you want to use it just fatch the encrypetd connection string, decrypt it and use it.

select case INDEX_CODE when 'Default' Then 'Default123' when 'Int' Then 'International' when 'Bnk' Then 'BankDep' When 'Inv' Then 'Investment' END from TableTest

just try this .... response.setDateHeader("Expires", 0); response.setHeader("Pragma", "no-cache"); or <script>document.execCommand("ClearAuthenticationCache", false)</script>

modified on Monday, October 13, 2008 9:43 AM

Hi Can you tell how much time it is taking to process the current job?Is it taking more than 10 sec? You can declare a boolean variable with value flase.S et it's value to true after completing the current job and check the value of boolean variable if it is true then only move forwad otherwise return from the time function...

Hi, Can you explain how you are exporting data to excel....It will help to get ur problem solve quickly.. If u want you can use the below code for exporting the data in excel..... private void btnExportToExcel_Click(object sender, System.EventArgs e) { dataGrid1.DataSource=TT_Reports.getDefaultersList(DateTime.Parse(TxtFromDate.Text),DateTime.Parse(TxtToDate.Text ),ddnTeamList.SelectedValue.ToString()); dataGrid1.DataBind(); Response.Clear(); Response.Buffer= true; Response.ContentType = "application/vnd.ms-excel"; Response.Charset = ""; this.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); Response.AddHeader("content-disposition", "attachment;filename=DefaultersList_"+DateTime.Today.ToShortDateString()+".xls"); this.ClearControls(dataGrid1); dataGrid1.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } private void ClearControls(Control control) { for (int i=control.Controls.Count -1; i>=0; i--) { ClearControls(control.Controls[i]); } if (!(control is TableCell)) { if (control.GetType().GetProperty("SelectedItem") != null) { LiteralControl literal = new LiteralControl(); control.Parent.Controls.Add(literal); try { literal.Text = (string)control.GetType().GetProperty("SelectedItem").GetValue(control,null); } catch { } control.Parent.Controls.Remove(control); } else if (control.GetType().GetProperty("Text") != null) { LiteralControl literal = new LiteralControl(); control.Parent.Controls.Add(literal); literal.Text = (string)control.GetType().GetProperty("Text").GetValue(control,null); control.Parent.Controls.Remove(control); } } return; }

Just go through the below article.It may be helpful for you... http://www.codeproject.com/KB/edit/TNumEditBox.aspx?display=Print[^]

Do you have given permision to this folder "\\server\d$\softwares"? Give access to both source and destination folder?

Hi follow the below link it may be useful for you.. http://paypaldev.org/\[^\]

Hi follow the below link it may be useful for you.. http://paypaldev.org/[^]

Hi kandalu, do not use DateTime.Now()it will fatch the client current date.Create a procedure at database side which will return the current date(using getdate()).This will always return the cureent date of the database server. Thanks

Hi Kandalu, All the element in the connection string will be same you only have to replace the database name for each month. So just get the curreent month and update the connection string dynamicaly so that the recrods can be insrerted for the current month. Thanx