|
Hi
I have windows form.in that
I have table tbluseraction
actionid actionname
-------------------------
1 read
2 write
3 delete
I have another table tbluserform
formid formname
---------------------------------
1 frmbackup
2 frmrestore
Now i want to give premission to each form.I have check box for every permission
after giving rights it is saved in table as
formid actionid
1 1
1 2
2 1
I have given source code and Please help me
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace DERPS
{
public partial class frmERPRights : Form
{
int ModuleCode;
int UserCode;
DataTable dtColumns;
public frmERPRights()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
dgvERPPermission.Columns.Add("clmFormCode", "Form Code");//0
dgvERPPermission.Columns.Add("clmFormDescription", "Form Description");//1
using (SqlConnection CNN = new SqlConnection(AppManager.GetConnectionString()))
{
CNN.Open();
using (SqlCommand scmd = new SqlCommand()) {
scmd.CommandText = "select ActionCode, ActionName from erpactions where isPermissible=1";
scmd.Connection = CNN;
SqlDataAdapter sda = new SqlDataAdapter(scmd);
dtColumns = new DataTable();
dgvERPPermission.AutoGenerateColumns = false;
sda.Fill(dtColumns);
foreach (DataRow row in dtColumns.Rows)
{
DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
checkColumn.Name = row[0].ToString();
checkColumn.HeaderText = row[1].ToString();
checkColumn.Width = 50;
checkColumn.ReadOnly = false;
checkColumn.FillWeight = 10; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values
dgvERPPermission.Columns.Add(checkColumn);
}
}
}
using (SqlConnection CNN = new SqlConnection(AppManager.GetConnectionString()))
{
CNN.Open();
using (SqlCommand scmd = new SqlCommand())
{
scmd.CommandText = "select FormCode,FormDescription from ERPFORMS";
scmd.Connection = CNN;
SqlDataAdapter sda = new SqlDataAdapter(scmd);
DataTable dt = new DataTable();
dgvERPPermission.AutoGenerateColumns = false;
sda.Fill(dt);
object[] row1;
foreach (DataRow row in dt.Rows)
{
row1 = new object[] { row[0], row[1] };
dgvERPPermission.Rows.Add(row1);
}
}
}
}
private void tsbSave_Click(object sender, EventArgs e) //to be saved
{
try
{
using (SqlConnection CNN = new SqlConnection(AppManager.GetConnectionString()))
{
CNN.Open();
foreach (DataGridViewRow row in dgvERPPermission.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
string value = cell.Value.ToString();
if (cell.Value.ToString() == "true")
{
MessageBox.Show(value);
}
}
}
}
}
catch (Exception ex)
{
}
}
}
}
Thanks
chandran
|
|
|
|
|
Sorry, could you explain better where is the problem?
From your statement, it seems that you are just posting a working code.
|
|
|
|
|
That sounds the wrong way to do it. You would normally declare a set of allowable functions in your form/database etc. You then assign permissions to users, based on their job, and when the user logs onto the system, you can check what functions they are allowed to perform.
|
|
|
|
|
Hi All,
I use a MS SQL Database with Windows Application c#
and I need to manage the deadlock of my table of multiple users insert into this table in the same time, I need to check if the table was deadlock at each save before insert into it, and i don't need to depend on the Try catch block (dead lock exception).
Please let me know how to Solve it.
Thank you
|
|
|
|
|
You can't check for a deadlock and then perform an action as these are two discrete operations. In other words, in the period between you somehow performing the check and then performing the save, another operation may have deadlocked the table. You can pretty much only react to the deadlock.
This space for rent
|
|
|
|
|
Use "transactions"; you know: "commit" and "roll-back"?
|
|
|
|
|
Hello, are you sure it's a deadlock or it is a generic timeout? A table can't deadlock just because many users try to insert.
Deadlock means someone is blocking record A then try to lock record B while other process locked B then try to lock A.
If that happens just have both the process lock the resources in the same order (first A then B) this will avoid the deadlock, by definition, and can be done saving all records sorted by primary key, for example, within a trasaction.
Best Regards
Andrea
|
|
|
|
|
hi all,
i want to copy control from one flowlayoutpanel to other,
but when i copy it from panel 1 to panel 2,control from panel 1 automatically deleted.
please help me for this.
|
|
|
|
|
That means you are moving not copying. But exactly how and when you are doing this is a total mystery to anyone reading your question.
|
|
|
|
|
foreach (Control ctrl in panel1.Controls)
{
panel2.Controls.Add(ctrl);
}
|
|
|
|
|
A Control can only ever have one Parent: when you add it to a different Controls collection it is automatically removed from the existing collection.
If you want a visually similar control in two different places, you have to Copy it - but that means that it's a different control, any changes to one will not be reflected in the other.
To clone it isn't difficult using reflection:
public static class GeneralMethods
{
public static T Clone<T>(this T control) where T : Control
{
T result = Activator.CreateInstance<T>();
PropertyInfo[] piCollection = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach (PropertyInfo pi in piCollection)
{
if (pi.CanWrite)
{
if (pi.Name != "WindowTarget")
{
pi.SetValue(result, pi.GetValue(control, null), null);
}
}
}
return result;
}
}I suspect that you don't really want to do this - why are you trying? What are you trying to achieve? There may be a better way.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
it means i have to use here cloning for the controls.
thanks its done now
modified 20-Aug-16 3:47am.
|
|
|
|
|
Hi,
I'm trying to make a simulation of an object going down an inclined plane with friction. I have all the calculations I need, but I'm having some problems with figuring out how to actually draw this using GDI+.
At the moment I can draw the inclined plane and the object at a custom angle using Matrix.RotateAt. I also use a timer tick event to set the coordinates of the object and then invalidate the form to refresh it.
But what I can't figure out is how to calculate the coordinates of my object so it moves down on the inclined plane like it is actually sliding on it?
Any idea is appreciated!
Thanks in advance!
|
|
|
|
|
Start with the math: Mass on incline[^] - the acceleration is g * sin(angle in radians) so for Earth, and a 45 degree slope the acceleration is 9.81 * sin (45 * 3.1415 / 180) = 6.93 ms-2
So you know the initial speed, you know the acceleration, you should be able to work out the distance from the start point at any moment in time (i.e. when the Timer ticks.)
Handle the Paint event for a Panel or similar, and Invalidate the panel each tick. In the event handler, draw the object in it's current position.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Thanks for the reply, but you almost said the same as I said...
I know the calculations for the acceleration and how to work with the timer ticks and invalidate the panel.
It's the calculation and the coding of the object on the incline plane that I can't figure out. I'm having trouble with this, because everything is at an angle and I used Matrix.RotateAt for that (which I'm not sure if it's the right way to do it).
|
|
|
|
|
If you know the calculations, then you know how far away from the start point it needs to be at time "t", yes? So all you have to do is draw it that far away!
And you've already said that you can draw it and the plane, so what is the problem?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Yes, I can draw it on the plane at the starting point. But when I try to add movement to the object, it starts moving away from the plane. So that is the problem. To rotate the plane and the object I use the following:
public void Rotate(Graphics g, Rectangle r, float angle, float x , float y)
{
using (Matrix m = new Matrix())
{
m.RotateAt(angle, new PointF(x, y));
g.Transform = m;
g.DrawRectangle(Pens.Red, r);
g.ResetTransform();
}
}
|
|
|
|
|
Why are you rotating the plane and the object when the acceleration you calculate is a vector parallel to the plane?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Because that is the only thing I found and that is why I'm here asking for help. But the only thing I get I answers with questions that point out how bad I am at trying to solve this... :s
|
|
|
|
|
I'm obviously doing this wrong, but would be nice if somebody pointed me in the good direction(keeping in mind that I'm new at this)...
|
|
|
|
|
We ask questions because all we get to work with is what you type - we don't get any context beyond that to work from.
So start by ignoring the object and use a "placeholder" - a circle or dot is fine - and get that working first.
Write a method to draw a plane, and a dot on the plane corresponding to a time you pass as the parameter, along with the Graphics object to draw onto (you get given this in the Paint event handler arguments).
The Plane is easy, a 45 degree incline is just:
g.DrawLine(Pens.Black, 0, 0, 0, 200);
g.DrawLine(Pens.Black, 0, 200, 200, 200);
g.DrawLine(Pens.Black, 200, 200, 0, 0);
And drawing a dot is trivial:
g.DrawEllipse(Pens.Red, x - 1, y - 1, 3, 3); Add a Panel to your form, handle the
Paint event, and call the method, passing it the number of seconds since the movement started.
All you have to do then is call Invalidate on the Panel in the Tick event of your timer after workign out the time since the start.
Does that make sense?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Yes, that makes sense. But the angle needs to variable, so I'm going to use the following to calculate the inclined line:
x1 = startx
y1 = starty
x2 = x1 + cos(angle) * length
y2 = y1 + sin(angle) * length
I also know that my info is not clear, but that is because I don't understand it enough to formulate a good description of my problem. But the placeholder makes it a bit less complicated (still don't have a clue how to draw the rectangle at an angle without using the rotate method);
Thanks for your patience!
|
|
|
|
|
Member 12688377 wrote: still don't have a clue how to draw the rectangle at an angle without using the rotate method
 Worry about it later!
(But... How different is it to drawing the inclined plane? The equation you give will draw two of the lines for you, and the other two are just joining them up - so it's just a case of four Point values which you need to offset by the X and Y of the time-based location. Think about it when you have the basics working.)
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I was able to complete this! Thanks for the help!!!
|
|
|
|
|
You're welcome!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
