|
|
i want to retrieve date from SQL database using c# [Stored Procedure] and show all the value of Database in a grid.i don't know how to call this procedure in view. this is my Controller code :-
namespace sp_insert.Controllers
{
public class EmployeDetailController : Controller
{
//
// GET: /EmployeDetail/
public ActionResult Index()
{
Employee Employee = new Employee();
return View("DisplayEmployee",Employee);
}
public ActionResult DisplayEmployee(Employee Employee)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString"].ConnectionString.ToString());
con.Open();
SqlCommand cmd = new SqlCommand("spEmpSelect",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteReader();
return View("DisplayEmployee",Employee);
}
}
}
|
|
|
|
|
I would suggest you to Google and learn MVC and Ado.Net first because the code simply reveals that the way you are trying to do is fundamentally wrong.
So, even if we answer your question, it won't help you.
|
|
|
|
|
actully i am very much clear about mvc and ado.net...but how practically implemented that i am not able to understand that's why i am asking you....
|
|
|
|
|
please any 1 provide me an Example of:"Insert , Display ,Update ,and Delete on Database in asp.net with MVC using Stored Procedure Example".i want to learn how actually application is working with database.
|
|
|
|
|
|
i want to retrieve date from SQL database using c# and show the value as a text property of a label. this is my code  
string calidd = "select calid from calib where Tulname Like @myse";
cmd2 = new SqlCommand(calidd, con);
cmd2.Parameters.AddWithValue("@myse", se);
DateTime dt;
dar2 = cmd2.ExecuteReader();
while (dar2.Read())
{
dt = Convert.ToDateTime((dar[0].ToString()));
xxcd = dt.ToString("dd/MM/yyyy");
}
calibdlab.Text = xxcd;
There is No problem anywhere!.. you only lack Insight on How to provide the Solution.... Knowledge is Power..
|
|
|
|
|
|
I need to add a grid to a web page and implement auto scrolling for the grid. The grid should display a maximum of 15 rows and auto scroll showing each loaded row (0 - 100) at a configurable speed. The number of rows loaded to the grid will vary each time data is pulled from a database. Does anyone know how to automate scrolling for a grid using ASP.Net with VB.Net. Any advice would be greatly appreciated.
|
|
|
|
|
If you want to scroll vertically or Y
Then you need to wrap the control in a div element, and use CSS to control the scrolling
<div style="overflow-y: auto;">
</div>
If you want to scroll X or horizontal, replace Y with X
http://www.w3schools.com/cssref/css3_pr_overflow-y.asp[^]
|
|
|
|
|
Not what I am needing. I need to have the gridview data to scroll automatically with animation. Probably using JavaScript or CSS 3.0 animations. Thanks anyway for the advice, but the solution to my problem will be a bit more advanced.
|
|
|
|
|
You just said grid, wasn't' sure if your talking about individual cells, or the entire gridview object. Perhaps you should fine tune your question.
|
|
|
|
|
|
1. No
2. Read carefully the rules of this forum (top of the page)
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Annoying people you want help from is rarely a good way to start things.
And not reading clear instructions is a good way to annoy people.
So do as it says at the top of the page, and don't post technical questions here.
Post here instead: http://www.codeproject.com/Questions/ask.aspx[^]
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Semi-useful answer:
If I could create a folder on your system from my web app, I'd be creating folders on your system until you ran out of hard drive space.
Rethink what it is you're trying to solve. I'm gonna leave it at that.
|
|
|
|
|
dandy72 wrote: If I could create a folder on your system from my web app, I'd be creating folders on your system until you ran out of hard drive space.
Well, you're just not nice!
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Only to people who post programming questions to the lounge
|
|
|
|
|
But watching people post programming questions to the Lounge is my favourite spectator sport!
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Mark_Wallace wrote: But watching people post programming questions to the Lounge is my favourite spectator sport!
I'm not sure whether that means you're disappointed in my initial response. 
|
|
|
|
|
Well,the answer is obviously "NO" as you can't take the OS level control of client.
Why do you want to create folder on client machine?
Please provide your requirement.
|
|
|
|
|
Hello,
I'm pretty new to ASP.NET..
I'm creating Models using EF, and then creating controllers and views automatically, which is great.
What I want to achieve is that, I want unregistered users not to see create new/Delete/update links. Only admins should see those links and do those operations. How can I do that?
Thanks.
|
|
|
|
|
What you need is authentication service. To authenticate the users before they can continue to those actions (Create/Delete/Update), and let only Admin users to continue and perform them by visiting those web pages.
You would find yourself at ease at this web page: http://www.asp.net/identity[^] ASP.NET Identity is the service by ASP.NET that can be used to authenticate users.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
how can i find iis manager in windows 8 .. i searched for (inetmgr) and in control panel .. and no result ??
|
|
|
|
|
Sounds like it's not installed. Try searching for "Turn Windows Features on or off", and look under "Internet Information Services" -> "Web Management Tools" -> "IIS Management Console".
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
