I want a create a constraint such that if value of cola='Y' then value of colb cannot be null.Please help

how can i convert a dataview to a dataset

how do i cal the second drop down that is the problem .How do i identify the control which is inside a datagrid

I have two drop down in a datagrid.What i want when i select an item from the first the second one should be populated accordingly.My problem is i have created an event handler for the first drop down but how do i call the second drop down to populate

try this Try Dim smtpserver As Web.Mail.SmtpMail Dim mesg As New Web.Mail.MailMessage smtpserver.SmtpServer=strsmtpserver mesg.From = mailFrom mesg.To = mailto mesg.Subject = subj mesg.Body = messg smtpserver.Send(mesg) i = "Mail Sent" Catch i = "Failed to send Mail" End Try Remember that ur mail id should be a part of the smtp server e.g if ur id is xzy@yahoo.com then smtp server should be of yahoo else u will get the relay error message

I have created a resource file using resource writer .Now after some time i want to change the value for a key at runtime how do i do it i.e after complilation

i have to keep it at the start as it is required

this query takes a lot of time .How do i optimize this

select * from premium where Reg_Number_Vehicle like '%PB-1-AD-511%' or Reg_Number_Vehicle like '%PB-1-AU-396%' or Reg_Number_Vehicle like '%PCL-6888 %' or Reg_Number_Vehicle like '%PB-1-AP-535%' or Reg_Number_Vehicle like '%PB-1-AV-223%' or Reg_Number_Vehicle like '%PIM-224 %' or Reg_Number_Vehicle like '%CHE-5851 %' or Reg_Number_Vehicle like '%PCS-5569 %' or Reg_Number_Vehicle like '%PJL-161 %' or Reg_Number_Vehicle like '%CH-3-B-99%' or Reg_Number_Vehicle like '%PB-1-AC-198%' or Reg_Number_Vehicle like '%PB-1-AL-87%'

I am using Crystal Report 10.I am using image in it .This image is visible on the local web server.But when i am hosting it on my main web server these images are not visible.What could be the problem.The path of the picture is some png file.Which is present both one the local server and web server

I am to create reports but not able to deploy it .I get the error The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. How to solve this

business intelligence project type is missing in vs 2003.How do i get it

This thing is very strange.I have been using the following connection string all these days data source=server;initial catalog=NIA;password=tpassword;persist security info=True;user id=sa But now all of my .net application is not getting connected to sqlserver [SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 NewNia.WebForm2.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\NewNia\WebForm2.aspx.vb:40 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731 Though i can acces my server through query analyzer.Please help

I have a table which has 1 Cr records .Now i have a query which has joins on 3 tables includung the one that has the large number of records.The select fields remain the same but the fields in where condition changes as per user selection.I have created a view when there is no where condition and this works fast.But now what do i do when there is a where condition.This query takes 9 min.I have already applied indexes

I have hard disk of 40 gb for d:.Now i am creating a test environment for a database that should hold more than 1 cr records in one of the tables.I am imorting data from flat files .It gives me primary filegroup full .So i created a secondary filegroup and created the table in this filegroup.After 40 lakh data the hard disk space left is 32 gb still it gives me filegroup full error while importing data.Databse growth is unrestricted.help

Hi I have never done this and think the solution should be very simple.Now i have a query which say takes 5 min to excute what i want is mean while the query is exceuted and the data is loaded an image should be dispalyed and once the query is complete the image should go and the data should come

Hi, I have a C# program that I am using to access a SQL database. The problem is one of the queries takes a reasonable long time (about 5mins in SQL query analyzer), but when I run my program it keeps throwing an exception of "Timeout Expired" I thought that by increasing the "Connect Timeout=600" to 600 would cure it but it doesn't. Help!

Hi I am using the following piece of code to export my data to an excel file Response.ContentType = "application/vnd.ms-excel" ' Remove the charset from the Content-Type header. Response.Charset = "" ' Turn off the view state. Me.EnableViewState = False Dim tw As New System.IO.StringWriter() Dim hw As New System.Web.UI.HtmlTextWriter(tw) ' Get the HTML for the control. DataGrid1.RenderControl(hw) ' Write the HTML back to the browser. Response.Write(tw.ToString()) ' End the response. Response.End() This works fine if there is only one page of data but when it has multiple pages it gives me the following error Control 'DataGrid1__ctl24__ctl1' of type 'DataGridLinkButton' must be placed inside a form tag with runat=server. How do i resolve this issue

how do i generate cumulative aggregate queries in transact-sql

How to upload heavy files more than 6 mb in .net