|
I can't help you with that I'm afraid - I've never used MVC.
|
|
|
|
|
Ok thanks for your valuable time and response..
|
|
|
|
|
Hi all,
I am trying to run a query which can allow to output 'UploadDate' value only. This is what I currently have and i keep getting a -- Cannot implicitly convert type 'System.DateTime?' to 'API_09.database_BD'-- error, on the following code:
public database_BD GetDate()
{
var data = db.database_BD.Select(d => d.UploadDate)
.OrderByDescending(c => c)
.FirstOrDefault();
return data;
}
Database_BD Entity framework class:
public partial class database_BD
{
public Nullable<System.DateTime> UploadDate { get; set; }
public string uUsername { get; set; }
}
any suggestions and help would be most welcome.
|
|
|
|
|
Hello miss, Could you please specify the return type of
public -- database_BD GetDate()
|
|
|
|
|
If you only want to return the upload date, change the return type of your GetDate method to DateTime? and everything should work:
public DateTime? GetDate()
{
return db.database_BD.Select(d => d.UploadDate)
.OrderByDescending(c => c)
.FirstOrDefault();
}
If the return type needs to be database_BD , then you'll need to return that type:
public database_BD GetDate()
{
var data = db.database_BD.Select(d => d.UploadDate)
.OrderByDescending(c => c)
.FirstOrDefault();
return new database_BD { UploadDate = data };
}
If you want the full details of the latest record, then you'll need to change your query:
public database_BD GetDate()
{
return db.database_BD
.OrderByDescending(d => d.UploadDate)
.FirstOrDefault();
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Dear Richard,
Your first solution worked. I did not realize, i was missing something so silly. I appreciate your time and help.
Many thanks.
|
|
|
|
|
No problem - we've all had days like that!
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi , I'm new to ASP.NET . I'm using visualstdio 2013 web express. I have created a Database and table in it. I have created a registration webform. In the web form if i click 'submit' button the corresponding value should be inserted in those tables and if i click preview the data should be displayed.
|
|
|
|
|
|
what have you tried so far? where you stuck? and what error you are getting?
|
|
|
|
|
i get an error when i click submit button
{"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"}
|
|
|
|
|
|
Check in your web.config if you have specified properly the connection strings.
And one thing are you using MVC?
|
|
|
|
|
nope. i just resolved that but got an syntax error in particular line
"int temp = Convert.ToInt32(com.ExecuteScalar().ToString());"
code
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["userConnectionString"].ConnectionString);
cn.Open();
string sel = "select count(*) from Table where username = '" + username.Text + "'";
SqlCommand com = new SqlCommand(sel, cn);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
if(temp==1)
{
Response.Write("User already exists..!!");
}
cn.Close();
|
|
|
|
|
oh! great..(y)
|
|
|
|
|
I got an error
An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code view details ---> {"Incorrect syntax near the keyword 'Table'."}
code:
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["userConnectionString"].ConnectionString); cn.Open(); string sel = "select count(*) from Table where username = '" + username.Text + "'"; SqlCommand com = new SqlCommand(sel, cn); int temp = Convert.ToInt32(com.ExecuteScalar().ToString()); if(temp==1) { Response.Write("User already exists..!!"); }cn.Close();
|
|
|
|
|
One thing I would like to mention Hari is seldom use select * from .... always have a habit to write all the column names. Its a very good practice.
I guess use the name propertyfor the textbox from where you need the name and then write the name in the "--" that might work out. and from the error it seems you miss some Dll's assemblies..
please check using a debugger where exactly you are getting that exception.
thanks
|
|
|
|
|
|
Table is a reserved word in SQL, so it is a bad idea to call a table "Table" - call it something significant, like Registration or UserReg
In MSSQl, if you are using a reserved word for something else, such as a table or column name, you must surround it with square brackets e.g.
SELECT * from [TABLE] ......
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
|
Your code is susceptible to SQL Injection[^].
For example, if the user types Robert';DROP TABLE [Table];-- in the username textbox, your query becomes:
select count(*) from Table where username = 'Robert';DROP TABLE [Table];
That's actually two queries; one to select the number of records with the username "Robert", and one to delete the entire table. The "--" at the end comments out the rest of the query.
It's quite easy to fix:
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["userConnectionString"].ConnectionString))
{
cn.Open();
string sel = "select count(*) from [Table] where username = @username";
using (SqlCommand com = new SqlCommand(sel, cn))
{
com.Parameters.AddWithValue("@username", username.Text);
int temp = Convert.ToInt32(com.ExecuteScalar());
if (temp == 1)
{
Response.Write("User already exists..!!");
}
}
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
thanx.
|
|
|
|
|
Dear All,
My Requirement = I have page on which it having more than 8 tab,I want to display multiple grid onClick of each tab,If i write code in each tab ContentTemplate, my page become to heavy,so it will take lot of time to load.
Current Way = I am using Ajax tab control in one of my project it has ContentTemplate and each ContentTemplate has one iframe, so onclick of each tab related page open in related iframe and all the grid on that page loads.
Problem Current Practice : = No of Pages increases.
Question : Can you suggest me best practice of Tab Concept,So that on each tab click,i should able to load heavy grid, so that each tab content load quickly.
My requirnment is I want to keep Tab Concept only.
Thanking You
|
|
|
|
|
How can I add cell with specific background?
Dim spreadsheet As DocumentFormat.OpenXml.Packaging.SpreadsheetDocument
Dim worksheet As DocumentFormat.OpenXml.Spreadsheet.Worksheet
Dim styleXml As String
spreadsheet = Excel.CreateWorkbook(workbookName)
If (spreadsheet Is Nothing) Then
Return
End If
Excel.AddWorksheet(spreadsheet, "Test")
worksheet = spreadsheet.WorkbookPart.WorksheetParts.First().Worksheet
?????
worksheet.Save()
|
|
|
|
|
when we need cookiless session and why?
|
|
|
|