|
|
Two things:
1) If you want us to look at code, make it easy for us: use the "Code block" button (above) or enclose it in <pre></pre> tags. We don't get paid, so won't want to struggle too hard.
2) Ask a question. Just code doesn't often get an answer - we don't know what your problem is (apart from "He doesn't like commenting").
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
public partial class Default2 : System.Web.UI.Page
{
SqlConnection cnx = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Coupon Management.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlDataAdapter da1 = new SqlDataAdapter();
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
DataTable dataTable;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillVendorGrid();
}
}
private void FillVendorGrid()
{
dataTable = new DataTable();
cmd.Connection = cnx;
cmd.CommandText = "SELECT Coupon_Info.RecievingDate, CouponType.CouponName, Coupon_Info.Serial_Start, Coupon_Info.Serial_End, Coupon_Info.Recieved_By FROM Coupon_Info INNER JOIN CouponType ON Coupon_Info.Coupon_TypeID = CouponType.CouponTypeID";
da1 = new SqlDataAdapter(cmd);
da1.Fill(dataTable);
GridView1.DataSource = dataTable;
GridView1.DataSource = ds;
GridView1.DataSourceID = String.Empty;
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
FillVendorGrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
cmd.Connection = cnx;
cmd.CommandText = "DELETE FROM Coupon_Info WHERE RecievingDate='" + GridView1.DataKeys[e.RowIndex].Values[0].ToString() + "'";
cnx.Open();
cmd.ExecuteNonQuery();
cnx.Close();
FillVendorGrid();
}
}
|
|
|
|
|
Ok, so it looks prettier. But not quite there.
What the code block does is preserve formatting. So the indentation that VS enforces show up. For example:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillVendorGrid();
}
}
and
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillVendorGrid();
}
}
are posted with the same info - see the difference?
When you add the code block, paste it from VS, not from your earlier message!
Plus, remember that bit about asking a question?
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
dear griff i m sorry but dear plz help me if u have any idea
|
|
|
|
|
No need to call me dear - you don't know me that well.
What is the problem? Code - ok. What is not happening? Or happening that shouldn't?
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
ok sorry sir i remove this error but i face another error when i click delete in the gridview
cmd.CommandText = "DELETE FROM Coupon_Info WHERE RecievingDate='" + GridView1.DataKeys[e.RowIndex].Values[0].ToString() + "'";
it highlight this code nd error is
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
|
|
|
|
|
Change your routine to:
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
cmd.Connection = cnx;
cmd.CommandText = "DELETE FROM Coupon_Info WHERE RecievingDate='";
DataKeyArray dk = GridView1.DataKeys;
IOrderedDictionary iod = dk[e.RowIndex].Values;
cmd.CommandText += iod[0].ToString();
cmd.CommandText += "'";
cnx.Open();
cmd.ExecuteNonQuery();
cnx.Close();
FillVendorGrid();
}
Place a breakpoint at the definition of dk, and single step. That should tell you which index is in error.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
|
Only code.. whats the question?
Thanks,
Arindam D Tewary
|
|
|
|
|
What do I do with this?
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Stop dumping this cr@p 
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
|
creend wrote: It's my mistake,Sorry!
you did the same mistake three times.....
|
|
|
|
|
|
See above 
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Maite, no body has time here to guess a question out of the code?
You need to tell your problem,s o that some one may can help you.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
|
Nice code dump - I'm sure we don't need the designer contents too. Try using <pre></pre> tags around your code.
Now what is the problem/question as you seem to have forgotten that bit?!
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
|
Hi Experts,
I want to add shortcut in places bar in Open File Dialog Box.I know we can archive it using Regedit,But like to know how can i do it using Windows API (Hooking).
Urgently.....
|
|
|
|
|
If I read you correctly, what you want to do is modify the "Places" pane of the standard windows "Open" and "Save" dialogs, to include custom locations rather than just the standard "My Documents" and "My Computer" etc.
You can do this in two ways, but they both mean editing the registry, either by hand or by software.
This works in XP, don't know about Vista 
Note that Office has its own set of "Places" pane settings, which varies depending on which version you are using (Thanks, Microsoft! Standards! Lovely!).
The key you are interested in is:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\ComDlg32\PlacesBar
If it does not exist, create it. WARNING: the existance of this key overrides standard Windows behaviour and removes all items from the "Places" pane - you can delete this key to restore them.
You now need to create up to five values, named "Place0" to "Place4" inclusive, and items will be displayed in this order, with Place0 at the top of the pane.
The values can be string as in "E:\Correspondance", or DWORD as in the following table.
The DWORD values give you access to the standard items that existed before you started changing the registry - for example, if you set "Place0" to DWORD 5, the top item, in the pane will be "My Documents"
This list is (probably) not exhaustive, but if you find others that are useful, let me know. The list is (obviously) in Hex:
0 Desktop
1 Internet Explorer
2 Start Menu\Programs
3 My Computer\Control Panel
4 My Computer\Printers
5 My Documents
6 <user name>\Favorites
7 Start Menu\Programs\Startup
8 <user name>\Recent
9 <user name>\SendTo
a <desktop>\Recycle Bin
b <user name>\Start Menu
c logical "My Documents" desktop icon
d "My Music" folder
e "My Videos" folder
10 <user name>\Desktop
11 My Computer
12 Network Neighborhood (My Network Places)
13 <user name>\nethood
14 Windows\Fonts
16 All Users\Start Menu
17 All Users\Start Menu\Programs
18 All Users\Startup
19 All Users\Desktop
1a <user name>\Application Data
1b <user name>\PrintHood
1c <user name>\Local Settings\Applicaiton Data (nonroaming)0x001d
1e Nonlocalized common startup
1f Common favorites
20 Internet Cache
21 Cookies
22 History
23 All Users\Application Data
24 GetWindowsDirectory()
25 GetSystemDirectory()
26 C:\Program Files
27 C:\Program Files\My Pictures
28 USERPROFILE
29 x86 system directory on RISC
2a x86 C:\Program Files on RISC
2b C:\Program Files\Common
2c x86 Program Files\Common on RISC
2d All Users\Templates
2e All Users\Documents
2f All Users\Start Menu\Programs\Administrative Tools
30 <user name>\Start Menu\Programs\Administrative Tools
31 Network and Dial-up Connections
35 All Users\My Music
36 All Users\My Pictures
37 All Users\My Video
38 Resource Directory
39 Localized Resource Directory
3a Links to All Users OEM specific apps
To do this via REGEDIT is pretty obvious; I don't need to cover that.
Programmatically is pretty simple:
RegistryKey regKey = Registry.CurrentUser.CreateSubKey(@"Software\Microsoft\Windows\CurrentVersion\Policies\ComDlg32\PlacesBar");
try
{
regKey.SetValue("Place0", 6, RegistryValueKind.DWord);
regKey.SetValue("Place1", @"E:\Correspondance", RegistryValueKind.String);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
regKey.Close();
}
You will need to add the using for "Microsoft.Win32" - but you know how to do that, right!
This example sets the top two entries in the "Places" pane to "Favourites" and "E:\Correspondance".
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
Hi Experts,
I want to Create a Virtual Drive using C#. Exactly same as M-files.
Thanks & Regards
Satish
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
