SELECT user_Name,SELECT user_Name,    Sum(DateDiff(minute, 0, Duration)) As [TotalMinutes], Convert(varchar(max), Sum(DateDiff(minute, 0, Duration)) / 60)    + ‘ : ‘    + Convert(char(2), Sum(DateDiff(minute, 0, Duration)) % 60) + ‘ : ‘  + Convert(char(2), Sum(DateDiff(SECOND, 0, Duration)) % 60)    As [Description]FROM View_SumTime_Statuswhere user_Id=’A-036’ and Date between ‘2018-05-01’ and ‘2018-06-22’ group by  user_Name Continue reading Sum data type time over 24 hours SQL server

INSERT INTO [dbNewRealTime].dbo.tblMainPosting_Al (user_Name, FromDate, ToDate,Duration,LeaveType,Reason) SELECT SSN,startDate,endDate,duration,typeName,reason FROM [att2000New].dbo.View_List_Leave_Type Continue reading Copy data from table to other table sql server

con.Open(); SqlCommand cmd = new SqlCommand(“INSERT INTO dbo.tblMainStatus(user_Id,user_Name,Start_Time)VALUES(@user_Id,@user_Name,@Start_Time) SELECT SCOPE_IDENTITY();”, con); cmd.Parameters.AddWithValue(“@user_Id”, txtUser_ID.Text); cmd.Parameters.AddWithValue(“@user_Name”, txtUser_Name.Text); cmd.Parameters.AddWithValue(“@Start_Time”, SqlDbType.Time).Value = txtStartTime.Text.ToString(); string query2 = “Select @@Identity as no from dbo.tblMainStatus”; cmd.CommandText = query2; cmd.CommandType = CommandType.Text; decimal no = (decimal)cmd.ExecuteScalar(); con.Close(); txtIdentity.Text = no.ToString(); //using full. Continue reading Get identity after inserted to database C#

protected void Button2_Click(object sender, EventArgs e) { string pageurl = “WebForm2.aspx”; Response.Write(“<script> window.open(‘” + pageurl + “‘,’_blank’); </script>”); } Continue reading How to open new page in new tab asp C#

using System; using System.Data; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) {  string str = “select * from Table1 where id between “+pageIndex+” and “+PageSize;             da = new SqlDataAdapter(str,con);             ds = new DataSet();             da.Fill(ds);             dt = ds.Tables[0];             bi.DataSource = dt;             dataGridView1.DataSource = bi;             dataGridView1.ClearSelection(); } } } Continue reading C# DataGridView Binding – SQL Server dataset

this is web config for web base asp empty: <system.webServer> <defaultDocument>           <files>                   <add value=”cvregister.aspx” />           </files>           </defaultDocument>       <directoryBrowse enabled=”false” /> </system.webServer> Continue reading Web Config asp.net

<asp:ScriptManager runat=”server” ID=”sm”> </asp:ScriptManager> <asp:updatepanel runat=”server”> <ContentTemplate> <asp:button id=”button1″ runat=”server” Text=”clickme” onclick=”function” /> </ContentTemplate> </asp:updatepanel>   Continue reading Button click not Refresh but process event asp.net

SELECT  * FROM tbl_Name_Cus JOIN tbl_Booking_Cus ON tbl_Name_Cus.id = tbl_Booking_Cus.Cus_id;   Continue reading Inter join two table Column name difference but values match

SELECT user_Id, UserName, Date, [Add New], Match, Insufficient, [Delete], SUM(COALESCE ([Add New], 0)) + COALESCE (Match, 0) + COALESCE (Insufficient, 0) + COALESCE ([Delete], 0) AS [Item Total] FROM dbo.View_TargetByStatus GROUP BY user_Id, UserName, Date, [Add New], Match, Insufficient, [Delete] Continue reading Sum value multi column and column is null value sql server

SqlConnection conn = new SqlConnection(“ConnectionString”); conn.Open(); SqlCommand comm = new SqlCommand(“SELECT COUNT  FROM table_name”, conn); Int32 count = Convert.ToInt32(comm.ExecuteScalar()); if (count > 0) { lblCount.Text = Convert.ToString(count.ToString()); //For example a Label } else { lblCount.Text = “0”; } conn.Close(); //Remember close the connection Continue reading Count row from sql server database