I would like to query and find all related massages that have the same head line. I have use the headline as actionlink but I have no clue how to continue from here, (I using a repository and IRepository models against EF4 in mvc 2 )
View 3 RepliesI have several hundred html files that I want to remove the <head></head> tag from and all information contained in the tag. I am fairly sure I can do this in Visual Studio using the Find and Replace In Files with REGEX.
View 5 RepliesI have a table articles where i keep all the records of the articles wriiten by people online. Now i need to retrieve related articles based on the title i guess. I tried doing that using my stored procedures with the LIKE operator, but i guess that doesn't work because it does not take the whole string of the title and match with the ones in the database.
View 2 RepliesMy app in not MVC style, its WebForms style but I was unable to find the right forum related to routing.
View 2 RepliesBy right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 RepliesI have a basic CMS which I'm adding to a site to display some downloads organised into groups. I have two tables, one for the groups and one for the downloads. I'm using a repeated to display the groups with another repeater inside to display the children. This works perfectly.
However some of my download groups may not have any downloads related to them and I'd like to handle this by filter the groups so that only those with a relate download record(s) are shown.
I'm trying to do this with the query which populates the top repeater based on some ideas I read but I must be going wrong with the syntax.
Here is what I'm using to try and only select downloads groups which have downloads linked to them by the download group ID.
[Code]....
Can anyone offer any thoughts on how I should construct the query to perform this?
I am trying to zip files using command line Below is the code I am using.
Dim filePath As
String =
"C:Program FilesWinZipWINZP32.exe"
Dim outputfile
As
String =
"D:GeneratedReport25.zip"
Dim csvfile
As
String =
"D: est1"
Dim startInfo
As System.Diagnostics.ProcessStartInfo
startInfo = New System.Diagnostics.ProcessStartInfo(filePath,
"winzip32 -min -a " & outputfile &
" " & csvfile)
startInfo.UseShellExecute = False
startInfo.WindowStyle = Diagnostics.ProcessWindowStyle.Normal
startInfo.CreateNoWindow = False
System.Diagnostics.Process.Start(startInfo)
I am getting the Win32 Exception. (System cannot find the file specified.)
System.NullReferenceException: Object reference not set to an instance of an object
at ASP.document_down_upload_aspx.__Render__bctrl_23 (System.Web.UI.HtmlTextWriter __output, System.Web.UI.Control parameterContainer) [0x0008a] in /home/rajiv/Documents/8erp_final (2)/erp/Document_Down_Upload.aspx:24
I have to create a line chart from a sql query. It is as follows:
[Code]....
However,I need to take PlayerName into account too.For example,if there are 2 different PlayerNames,2 different series will be shown on the line chart.
I have some code like this
Dim conn As SqlConnection = New SqlConnection("server='h'; user id='w'; password='w'; database='w'; pooling='false'")
conn.Open()
Dim query As New SqlCommand("DECLARE @investor varchar(10), @sql varchar(1000) Select @investor = 69836 select @sql = 'SELECT * FROM OPENQUERY(db,''SELECT * FROM table WHERE investor = ''''' + @investor + ''''''')' EXEC(@sql)", conn)
dgBookings.DataSource = query.ExecuteReader
dgBookings.DataBind()
I need to add in an If statement basically saying if the SQLCommand query returns no rows then show a specific label Can this be done?
I have a page signup.aspx where user can register, how this page will find from which page request came from and how it will redirect user after registration to the requesting page, i want to do this using query string but don't know how PLZ SHOW ME CODES.
View 2 RepliesI have added a linq to sql layer in my MVC 2 application.
This is the code I am using:
using (ProductPortalDataContext ctx = new ProductPortalDataContext())
{
var Title = from aps in ProductPortal.Models.AppSettingsView[code]...
It says to be unable to find a quey model for AppSettings view and then says "where not found".
Tried googling, nothing came up. Tried searching here(first two pages) and nothing that seemed relevant popped up.But the best of all, created a new ASP.NET applicatio, imported the model using Linq to SQL and it compiled!Ok, I tried adding a button and a label to the asp.net application just to see if it would work... guess what? It doesn't!Still the same error message and I have *NO* clue what's wrong with it!
I have a page signup.aspx where user can register, how this page will find from which page request came from and how it will redirect user after registration to the requesting page, i want to do this using query string but don't know how SHOW ME CODES.
View 6 Replieshow to find and replace substring in select query
DATA RELEASE FORM $LSB$DRF$RSB$
I am getting frustrated with this problem, I dont know what i did, but now I cannot execute any stored procedured when I could last time.When I use my asp.net application to run the query, it finds the stored procedure but when I execute it is sql management studio it says it cannot find the stored procedure even though it is there.I tried to execute other procedures and the samething happens. Even when I try a simple query it says it cannot find the tableI could execute the query if i placed Use [databasename] in front, but even with this, I cannot execute stored procedures.
View 12 Repliesquery to find the 5th highest salary from an employee table?
View 2 RepliesI am having a web form initially which have href as follows
<a href="downloadInfo.aspx">ACH File Management System Trail(msi)</a>
<a href="downloadInfo.aspx">ACH File Management System Trail(zip)</a>
These are my two anchor tags when i click on this i will redirect both to a same page where user has to fill details and a mail will be send to the user for the given mail id. When the user clicks on mail i would like to have the download for which he opted to download. If msi means i would like to prompt msi file to be downloaded and if zip it should be downloaded I need this to be worked with out using query-string
I have the following attributes in my table
[code]....
how do I create sql query to find out the number of times participant A took part in the club activity?
i get the following exception (missing primary key) in the line of using Find() method "Table doesn't have a primary key." I've rechecked the Database and all Primary Key columns are set correctly.
DataTable dt = p.GetAllPhotos(int.Parse(Id));
DataTable temp = new DataTable();
temp = dt.Clone();
temp = (DataTable)(Session["currentImage"]);
DataTable dtvalid = new DataTable();
dtvalid = dt.Clone();
DataRow[] drr = new DataRow[1];
drr[0] = dt.Rows.Find((int.Parse(temp.Rows[0]["photoId"].ToString()))+1);
foreach (DataRow dr in drr)
{
dtvalid.ImportRow(dr);
}
dtvalid.AcceptChanges();'
I am using a textbox to populate mySQL database. My problem is when I recall the text it displays without line brakes or line spacing, inserted in the input textbox. I have tried all the field types i.e. Text, Small, Medium Text and Chars. I have tried gridview, repeater and datalist all displaying continuous text without line brakes.
View 4 RepliesIf I have a text file like:
123, joe blow, USA
Where the first values represent:
USERID, NAME, COUNTRY
If my file has 5000 rows, could I update a particular row somehow using C#?
I have a gridview which i want to update line by line.Its for confirmed users.SO i have a list of users and they are confirmed by clicking the checkbox and updating the value in the database.But how can i find the checkbox on the gridview and get the value. Ive tried the following code but no joy
[Code]....
I am trying to read a multilined textBox line by line into a List<String> but with the code below the compiler says that "'System.Environment' does not contain a definition for 'Newline'
[Code]....
If I have a variable that contains text information (say taken from a textarea), how can I read the text content held in a string variable line by line?
The text entered in the text area will have (enter key) to separate the line.
In a section in the <head> tags of my document I have code that lets me use the Id of my asp.net control from JavaScript like this:
<script language="javascript" type="text/javascript">
var customerId = '<%= Me.CustomerTextbox.ClientID %>';
</script>
However, if I want to modify the page structure in later stages of the page life cycle, it give me an error because I have the ASP tags in there. A work-around is enclosing the ASP tags in a server control like this:
<div id="customerIdContainer" runat="server">
<script language="javascript" type="text/javascript">
var customerId = '<%= Me.CustomerTextbox.ClientID %>';
</script>
</div>
But then I get a warning that a div tag is not allowed in the head tag. So is there a container tag that is valid in the head that I can add runat="server" to to make it a server control so I can workaround this problem without the warnings?