Hi Friends, I need information on SQl Server Certifications. I am working as a Dot Net Developer(Version 3.5) and using SQL as BackEnd. For my profile, which Paper i need to take? And what books i want refer? Please Suggest me... Thanks In Advance

Delete Table YourTable Where Column1='UrCondition'

Hi, insertCmd.Parameters["@Id"].Value = ddlCType.Text;insertCmd.ExecuteNonQuery(); replace the above code with insertCmd.Parameters["@Id"].Value = int.Parse(ddlCType.SelectedValue);insertCmd.ExecuteNonQuery();

Hi, How to change keyboard language programmatically in asp.net. so that user can enter in their own language instead of specifying everything in Resource File Thanks in Advance

Hi, I can able to Open Child Window in PopUpextender in button Click Event by(Modalpopupextender.show() syntax), but i am not able to open when we click GridView Row in FireFox. Its working fine in IE. I am not able to close the Child window in all the cases.

Hi, How can i read my Mails from another computer. Below code reads mails from the current system Inbox. In Outlook.NameSpace.Logon Profile property what value i need to pass to read other Inbox? Outlook.Application myOlApp = new Outlook.Application(); Outlook.NameSpace ns = myOlApp.GetNamespace("Mapi"); ns.Logon("","",false,true); Outlook.MAPIFolder inbox = ns.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderInbox ); foreach (Microsoft.Office.Interop.Outlook.MailItem submail in inbox.Items) { Microsoft.Office.Interop.Outlook.Attachments ii = submail.Attachments; for (int j = 1; j <= ii.Count; j++) { Microsoft.Office.Interop.Outlook.Attachment aa = (Microsoft.Office.Interop.Outlook.Attachment)ii[j]; Console.WriteLine(aa.FileName); string mypath = @"D:\FileUpload\" + aa.FileName; aa.SaveAsFile(mypath); } } Thanks in Advance

Hi Friends, I want to read Attachment of a mail in my Inbox. I could able to read Subject, Body, From Email ID. Now i struced with attachment. Please help me.

you mean to say have i given any security?

Hi, i am trying for WhiteBoard by connecting to remote machines using IP Address. I got source code for that. but when i run the code, i am unable to connect to the other machines... its giving error like "No connection could be made because the target machine actively refused it" But the target machine dint receive any request to refuse... i am using the same Ip Address and port no which i have used for Audio & Video conference. There its working fine... Below is the link for the source code... http://www.codeproject.com/KB/dotnet/csharpwhiteboard.aspx?fid=4351&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=627213&fr=26[^] Any help is appreciated.... Thanks in advance....

u can access session variables in user controls

Hi!!.. I have a gridview with Password column.. when i bind that column to the GridView i should get as "***". how can i get that? thanks

Thanks a lot sandeep... its working.... thank u very much....

Hi!! I am using Javascript in user control.. My problem is i am not getting the value of textbox in javascript. here is my code function InputChange() { var ctl=document.getElementById('txtEmp').value; alert(ctl); } <asp:TextBox ID="txtEmp" onchange="InputChange();" runat="server" CssClass="form_textbox" Width ="80px"></asp:TextBox> its displaying 'ctl' value as 'null' please help me ASAP... Thanks in Advance...

Hi!! try the below code for (int i = 0; i <= ListBox1.Items.Count - 1; i++) { if (ListBox1.Items[i].ToString() == TextBox1.Text) { //your statement } }

Hi!! I am running an application which is developed in VS2 Beta version in VS2.. Everything is fine except Reports.. When i run reports i am getting an error like "Failed to load database information. Details: The database DLL 'crdb_fielddef.dll' could not be loaded. Error in File C:\DOCUME~1\USHA~1.SNI\LOCALS~1\Temp\registrations {A2A0D120-17C0-49B3-A8AD-8F27D24A9C59}.rpt: Failed to load database information." I am using 'ttx' files to generate Report.. If i dont use 'ttx' file its working fine.. please tel me the solution for my problem?

Actually this has been developed 2 years back.. at that time they were using this version. now they want to convert this in to VS 2005.. Currently this project is not running in VS 2005.. i want to make this project to run in Framework 2.0

Thanks for ur reply... i am using VS2005.. please guide me how to convert...

Hi!!! I have an ASP.Net project in Beta version i want to convert that into 2.0... Any help is appreciated..

Hi friends i am creating a mobile application.. i created a dataset through the Wizard.. i had given a parameter in the select statement. Now i want to pass the value of the parameter my query in wizard is: SELECT reg_Id, PatientRegId, pat_name, DOB, Age, Gender FROM PatientRegistration WHERE (PatientRegId = @PatID) in normal applications i use to pass like sqldataadapter.selectcommand.parameter("@PatId").value=10 but in mobile application its not accepting the above format.. i tried in many ways finally i got the below code PatientRegistrationTableAdapter.FillBy(MobilehealthcareDataSet1.Tables("Pat", "PatientRegistration"), Val(TextBox1.Text)) Note: PatientRegistration is table name but i am getting the error like: "Null Refernece Exception" when i debug and go inside the above method in .designer.vb (below code) Public Overloads Overridable Function FillBy(ByVal dataTable As mobilehealthcareDataSet6.PatientRegistrationDataTable, ByVal PatID As Integer) As Integer Me.Adapter.SelectCommand = Me.CommandCollection(1) Me.Adapter.SelectCommand.Parameters(0).Value = PatID If (Me.ClearBeforeFill = true) Then ' dataTable.Clear End If <b>Dim returnValue As Integer = Me.Adapter.Fill(dataTable) </b>Return returnValue End Function now i got the error like " "Value can not be null. Parameter name: dataTable " if anyone knows please help me..

Can anyone tel me Advantages of Delegates, where and when we can use these Delegates