Posts

Showing posts from February, 2022

Stylesheet

Image
import * as React from 'react'; import styles from './Employeespotlight.module.scss'; import { IEmployeespotlightProps } from './IEmployeespotlightProps'; import { escape } from '@microsoft/sp-lodash-subset'; import * as $ from 'jquery'; import { WebPartContext } from '@microsoft/sp-webpart-base'; import { SPHttpClient, SPHttpClientResponse } from '@microsoft/sp-http'; import { SliderHelper } from './Helper'; export interface SpotlightDetails { userDisplayName: string; userEmail: string; userProfilePic: string; description: string; designation?: string; } export interface IStateEmployeeSlider { value:SpotlightDetails[]; } var result=[]; export interface ResponceDetails { title: string; id: string; } export default class Employeespotlight extends React.Component { private defaultProfileImageUrl: string = "/_layouts/15/userphoto.aspx?size=L"; private helper: SliderHelper = new SliderHe...

Windows Application CRUD Operation with ADO.net

Image
  Posted by Ganesan - +919042710472    Create STUDENTDB Database in Server Explorer. Create table StudentDetails in STUDENTDB with the below code snippet, Design Form1 as below, Textbox Properties StudentName Name - txtStudentName Age Name - txtAge Save -btnSave Show Data Link Name -linkLabel1 Events btnSave OnClick =btnSave_Click Show Data Link onClick= linkLabel1_LinkClicked Add below Namespace in Form1.cs Using System.Data.SqlClient; Using System.Configuration; Add Reference System.Configuration.DLL in the Project. In Form1.cs (Replace) put the below Snippet, public partial class Form1 : Form  { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TestConnection"].ConnectionString); public Form1()  {  InitializeComponent();  }  private void btnSave_Click(object sender, EventArgs e)  {  con.Open();  SqlCommand cmd = new SqlCommand("insert into StudentDetails values('"+txtStudentName...