public class ValuesController : ApiController
{
//For get all data
public IEnumerable<BookMaster> Get()
{
}
//For get by ID
public void Get(int id)
{
}
[HttpPost] // insert or add or create new
public string Post([FromBody]string value)
{
return value;
}
// PUT api/<controller>/5 update
public void Put(BookMaster bookMaster)
{
}
// DELETE api/<controller>/5
[HttpDelete]
public void Delete(int id)
{
}
>Add object datasource from controls in visual studio
> Add TypeName Property(class name .cs file) where you have get, update and delete methods.
>Click on configure data source and select dataset or typename file and you will get select insert update delete methods and click on finish and use this object datasource id in grid view or other controls.
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
>First open services.msc from wondow + r (Window Services)
> Then right click on sql server (SQL express)
>go to Properties.
Then go to Log On tab and select Local System account.
Click on Ok button and start the service.
protected void Unnamed_Click(object sender, EventArgs e)
{
//TextBox t = DetailsView1.FindControl("TextBox1") as TextBox;
string conStr = ConfigurationManager.ConnectionStrings["testdbConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
if (ddlSelect.SelectedValue == "1")
{
abc(txt1.Text, con);
}
if (ddlSelect.SelectedValue == "2")
{
abc(txt1.Text, con);
abc(TextBox2.Text, con);
}
}
}
void abc(string value, SqlConnection con)
{
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand("INSERT INTO BookMaster(BookName) VALUES (@BookName)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@BookName", value);
con.Open();
cmd.ExecuteReader();
con.Close();
}
> Give full control access to the visual studio file devenv.exe
Also in shortcut you can check Run as administrator option.
https://www.getfishtank.com/insights/automatically-run-visual-studio-as-administrator
>Open sql server
>Right Click on database >click on task>restore>database
>From device >select database bak file
>In option tab > Check overwrite the existing database (with replace)
or > in file tab click on reallocate all files to folder
Ctrl+M+M
Or in visual studio go to Edit and outlining and there are different shortcuts for more commands.
>First you have to add three files in project 1)Global.asax 2) testApiController.cs by adding web api controller class in project(add new item) 3)WebApiConfig.cs file
> Add below code in these files
Global.asax
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
YashWebsiteWebForm.WebApiConfig.Register(System.Web.Http.GlobalConfiguration.Configuration);
}
WebApiConfig.cs
public static class WebApiConfig
{
public static void Register(HttpConfiguration config)
{
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
}
}
In webapplication we have CodeBehind
In website we have codefile
>First Open Visual Studio
>Right Click on table and click on Design
>Right Click on column name left side
>Click on Indexes/Key
>Select Unique key in 'Type' Filed
Note:- Sometime unique key option is not visible
<asp:Button ID="Button1" runat="server"
PostBackUrl='<%# Eval("Id","~/Employee/Update/{0}") %>'
Text="Save" Width="75px" />
webclient in asp.net
for get
string handlerUrl = String.Format(Request.Url.Scheme+"://" +Request.Url.Authority+"{0}","/api/values");
string response = (new WebClient()).DownloadString(handlerUrl);
for post
using (var client = new WebClient())
{
string handlerUrl = String.Format(Request.Url.Scheme + "://" + Request.Url.Authority + "{0}", "/api/values");
client.Headers[HttpRequestHeader.ContentType] = "application/x-www-form-urlencoded";
var data = "=Short test...";
string result = client.UploadString(handlerUrl, "POST", data);
Response.Write(result);
}
https://www.aspsnippets.com/Articles/2149/Call-Consume-Web-API-using-WebClient-in-ASPNet-C/
object input = new { Name ="yash"};
input = 6;
List<object> a = new List<object>();
a.Add(5);
a.Add( "ere");
object[] jji=new object[2]{ new {s = "df"}, new {s= "df"}};
some times we can use
dr.ItemArray = new Object[] {new { AgentName = "dfdf"}, new {AgentName = "df"} };
string json = (new WebClient()).DownloadString("https://raw.githubusercontent.com/aspsnippets/test/master/Customers.json");
//Return the JSON string.
return Content(json);
> Add new item in visual studio
> Add ADO.net entity data model
>Click generate from database
>Set connection string Yes or no
> Select table
>Click finish
> Click on ok when says it can harm computer
> Go to model.tt
> You can copy entity model
Note:- When creating a Entity Data Model> In the EDMX file > Goto properties and Code generation Stratigy to Default > you will see the code in the designer file(if it is showing blank file)
In web.config file connection string name will store as (use dbcontext) for remeber.
we have to use context.cs class for CRUD operation
example
//create
using (EmployeeDBContext dbContext = new EmployeeDBContext())
{
dbContext.Employees.Add(employee);
dbContext.SaveChanges();
}
===============
//update
using (EmployeeDBContext dbContext = new EmployeeDBContext())
{
var entity = dbContext.Employees.FirstOrDefault(e => e.ID == id);
entity.FirstName = employee.FirstName;
entity.LastName = employee.LastName;
entity.Gender = employee.Gender;
entity.Salary = employee.Salary;
dbContext.SaveChanges();
}
==============
//Delete
using (EmployeeDBContext dbContext = new EmployeeDBContext())
{
dbContext.Employees.Remove(dbContext.Employees.FirstOrDefault(e => e.ID == id));
dbContext.SaveChanges();
}
============
//Getall
using (BookMasterdbEntities db=new BookMasterdbEntities())
{
return db.BookMasters.ToList();
}
==============
//Getbyid
using (BookMasterdbEntities dbContext = new BookMasterdbEntities())
{
dbContext.BookMasters.add(dbContext.BookMasters.FirstOrDefault(a => a.BookID == id));
dbContext.SaveChanges();
}
ref:- https://dotnettutorials.net/lesson/web-api-with-sql-server/
give Target="_blank"
<asp:HyperLinkField Target="_blank" />
public class File1
{
public string FileName { get; set; }
}
List<File1> Files = new List<File1>();
if (Directory.GetFiles(Server.MapPath("/uploads/")).Count() > 0)
{
foreach (var item in Directory.GetFiles(Server.MapPath("/uploads/")))
{
Files.Add(new File1 { FileName = item });
Response.Write(item);
grdTest.DataSource = Files;
grdTest.DataBind();
}
}
Response.Write(Request.PhysicalApplicationPath ); //output C:\Users\Yash User\Documents\Visual Studio 2012\WebSites\YashWebsiteWebForm\
Response.Write(Request.PhysicalPath + Environment.NewLine); // output C:\Users\Yash User\Documents\Visual Studio 2012\WebSites\YashWebsiteWebForm\Default3.aspx
Response.Write(Request.RawUrl ); //output /Default3.aspx
Response.Write(Request.Url); // output http://localhost:49730/Default3.aspx
Server.MapPath (""); //output C:\Users\Yash User\Documents\Visual Studio 2012\WebSites\YashWebsiteWebForm
> Open Sql server management studio
> Right click on editor and click on "Design query in editor"
> And right click in that to change insert update or delete query.
SELECT [Date]
,[SchemeNo] ,[Commission]
INTO test3
FROM PolicyDetails
>Go to settings
>Go to Sim cards
>Click on sim slot
>Change the color of sim slot
